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]

Delegate Password Management to Unpriviliged Database Users

When an application used SQL Authentication credentials for each login have to be created and delivered [securely] to the end user.  Alternatively a developer can opt to develop his/her own authentication mechanism where an application uses a single login to connect to the database and each end-user is created as... [Read More]

Skipping a beat

All last week I was really busy with other [personal] commitments and didn’t have any time to put pen to paper (or rather fingers to keyboard…).  Considering the situation I thought that having no article would be better than a post of poor quality. [Read More]

Deploying what in my opinion is messy code

Some background. In organisation I work at there are clear delineations between DBA and Database Development duties. The DBA is more of a DBMS-A with some working knowledge of the application and basically “what it does” (or should). On the other hand, most of the time the Database Developer is... [Read More]