Browse by Tags

• Best Practices
• Catalog Objects
• Database Design
• Denali
• T-SQL
• Utility

• Utility Queries–Column Metadata

  Very often, I find myself wanting to query system metadata for columns. Some of the metadata is fairly easy to deal with, like if you want to find column names, just simply querying sys.columns is very straightforward. But if you want to query data types, Read More... Posted Sunday, April 22, 2012 11:57 PM by drsql | 0 Comments Filed under: Catalog Objects, Constraints, T-SQL, Utility

• 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

• Business Rule Enforcement

  I know this is a topic that could cause a few heads to spin around uncontrollably if taken the wrong way, but I preserve.  Today I was having a conversation with an end user, an influential one at that, about a business rule that was needed for the Read More... Posted Monday, February 16, 2009 11:55 PM by drsql | 9 Comments Filed under: Best Practices, Constraints, Database Design