Securing an SSIS Params Table using Keys

SQL Server Integration Services (SSIS) was introduced with the 2005 version to replace the functionality of the SQL Server 2000 Data Transformation Services (DTS).  SSIS provides DBAs and database developers with the tools to create packages with which data can be exported, transformed and imported from/to various data sources such... [Read More]

Database Object Code Split on Multiple Lines

During a recent database migration I encountered strange behaviour when scripting out views, stored procedures and triggers. The issue was reported by the development team who noticed that object code lines were being split into two lines. After fixing the objects affected by this problem I investigated the cause and... [Read More]

A Low-Cost Solution to Track Database Code Changes

When developing application code it is always recommended that all source code is backed up, preferably using a version control application to allow for code sharing and providing a change rollback. Using a tool such as SQL Server Management Studio, a developer can store database code developed with SSMS in... [Read More]

Generate TABLEDIFF Commands to Identify Data or Schema Differences

A while back I wrote a short post about the tablediff.exe command-line application. As a quick reminder, the tablediff.exe utilty can be used to compare table schema and/or data and generate a T-SQL script which can be used to bring the two in sync. [Read More]

Active Directory Groups for Easier Permissions Management

SQL Server supports two authentication mechanisms, namely Windows and Mixed Mode. In Windows Authentication only accounts created on the local machine or domain accounts (users, groups, etc.) can be granted access to the SQL Server instance. This is the preferred and recommended (by Microsoft and most DBAs) implementation since the... [Read More]