Pro SQL Server Relational Database Design and Implementation
Coming to a bookshelf (probably virtual, naturally) near you later this year. The update you have no doubt been waiting for.
Not necessarily a tremendous rewrite this time, but we will be bringing the book up to 2016 in the material, and there are some new features from SQL Server 2014 and 2016 that really change the physical design of your databases.
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... email@example.com)
Code: SQL Files - 2012 SSMS Project
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.
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.