July 2011 - Posts

• Denali Enhancement–Duplicate Key Error Message

  When I was editing my chapter on implementing a database, I noticed a really nice improvement in the error message I had from the previous edition of the book. Instead of just telling me that there was a value in my modification statement that duplicated Read More... Posted Thursday, July 14, 2011 1:12 AM by drsql | 6 Comments Filed under: Constraints, Denali, T-SQL

• Chapter 8–Patterns and Anti-Patterns

  In this last kind of “creative” chapter, I will look at some of the ways you implement common problems in your relational database, and some of the ways you probably shouldn’t. The “should” sections will deal with: Uniqueness – Beyond the simple uniqueness Read More... Posted Sunday, July 10, 2011 1:29 PM by drsql | 0 Comments Filed under: Database Design, Design, Writing