Monthly Archives: July 2011

SSIS Configurations – Best Practice

SSIS provides flexible and varied methods for configuring its packages. These allow operators or developers to change a package’s behaviour at run time to adapt to changing environments. While SSIS is flexible, I personally found there was a lack of … Continue reading

Posted in Data Focus | Tagged , , , , | 1 Comment

A Technique for Auditing User Initiated Batch Updates on SQL Server

Overview Auditing of user actions is a common business requirement. Typically users change data on a record-at-a-time basis using an interface that allows maintenance of a single record. In this case each change results in a single entry in an … Continue reading

Posted in Data Focus | Tagged , , , , | Leave a comment