Monthly Archives: July 2011

SQL Server A to Z – Audit

In previous versions of SQL Server, there were a number of methods for auditing activity within an instance or database.  You could use DDL triggers to track any DDL changes, login auditing to write login successes or failures to the error log, Profiler tracing, and even C2/Common Criteria Compliance Auditing.  But each of these methods […]


Most people set goals in January.  It’s a brand new calendar year full of possibilities.  They join gyms.  They quit smoking.  I’ve never been one for New Year’s resolutions, personally.  And I don’t think goal-setting should be confined to January.  For me, in my professional life, July makes more sense.  I’ve had my annual review […]