April 2012 - Posts

• 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

• SQL Rally Relational Database Design Pre-Con Preview

  On May 9, 2012, I will be presenting a pre-con session at the SQL Rally in Dallas, TX on relational database design. The fact is, database design is a topic that demands more than a simple one hour session to really do it right. So in my Relational Database Read More... Posted Friday, April 13, 2012 11:58 PM by drsql | 1 Comments Filed under: SQLPASS, SQLRally, User's Group