Author Archives: dslattery

Column Change Auditing with SSIS

I was recently asked by a client to write an SSIS package to update some data in a database.  One of the requirements was to audit all changes with before and after column values, update user and update date. The client requested that CDC (Change Data Capture) NOT be implemented. And not being very proficient [...]

Posted in ETL | 1 Comment

Using Synonyms for Flexibility in a SQL Server Environment

Synonyms are a useful tool to make database aplications more flexible, portable and easier to code. A synonym can be viewed as a pointer to a fully qualified SQL Server object that is used in place of its fully qualified name. This allows application code to be more concise and easier to maintain.
Synonyms are a [...]

Posted in SQL Server | Leave a comment