Skip to main content

Home  Design Book  DMV Book  Presentations  Code  Calendar  Contact  About   
Pro SQL Server 2012 Relational Database Design and Implementation
 
 

A fairly substantial rewrite of the book for its latest version, this time showcasing some of the new features in SQL Server 2012, but enhancing much of the title with updated introduction material, simplified explanations and examples of normalization, a tremendous amount of new code samples throughout the last 7 chapters of the book.

 

As an added bonus, Jessica Moss (twitter: @jessicammoss) wrote the final chapter of the book, highlighting database design for reporting.

 

In the future, watch this space for more material, including code samples that have been tested with Azure, and new examples that I come up with after the release (unlike last edition, I already have a few items in process, so please ping me if you are interested... louis@drsql.org)

 

Downloads:

 

Code:  SQL Files  -  2012 SSMS Project

 

 Purchase From Apress: http://www.apress.com/9781430236955
 
 
 
 
Pro SQL Server 2008 Relational Database Design and Implementation
                               

Continuing the drive towards the longest title in the history of books, Pro SQL Server 2008 Relational Database Design and Implementation will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

 
Code:T-SQL Code Samples.zip
 
 
 
 
 
Pro SQL Server 2005 Database Design and Optimization
 

 

 

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.