Semi-Automated T-SQL Code Reviews

I am usually quite cautious when mentioning third-party tools since I don’t have any affiliations with any company or product mentioned.  In this case I want to make an exception.  I recently came across an SSMS addin called SQL Code Guard. [Read More]

Why I avoid using User-Defined Data Types

User-defined data types (UDT) were introduced with SQL Server 2000.  UDTs provide Database Designers, Developers, and DBAs functionality with which a custom data type can be created and which is based on one of the SQL Server system data types.  If you think of this as an approach to standardise... [Read More]

Per Server + CAL Licensing Model For Small Business' Development Environments

Whenever a new SQL Server version is released, unless an organisation is forking out the [slightly steep annual cost of] Software Assurance, a DBA has to build a business case to upgrade to the latest database platform.  This because, at the end of the day the licence cost has to... [Read More]

Script User-Defined Data Types

Continuing with the “database migration using scripting” series, this week I am publishing a script that’ll script user-defined data types. The script reads columns from the sys.types and sys.schemas DMVs to build the DROP TYPE and CREATE TYPE statements. Special attention is given to UDTs based on character, decimal, numeric,... [Read More]

A Couple of SSIS Package Error Workarounds

The How to: Import or Export a Package by Using SQL Server Management Studio MSDN article esxplains the steps to save or retrieve an SSIS package from/to SQL Server.  Like most DBAs (or not…?) I try to use the latest version of SSMS to execute queries against the various SQL... [Read More]