Author Archives : Colleen M. Morrow


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 […]


Patience. Patience is a virtue that I’ve been struggling with this week. I’ve been working with a person who adamantly believes that the SQL Server backup process locks tables in the database and will therefore cause his application to fail. I explained that this simply isn’t the case. I quoted numerous reputable sources. I offered […]