Tag Archives: auditing

Acing an Audit

Posted on January 29, 2013 by way0utwest

I’ve been through relatively few audits in my database career. I’ve worked in a few industries that didn’t require them, and avoided the stringent requirements of PCI and HIPAA. ISO 9000 was the first audit I encountered and I had been preparing for Sarbanes-Oxley (recently passed) when … Continue reading →

Posted in Editorial | Tagged | Comments Off on Acing an Audit

Regulators, Mount Up

Posted on November 28, 2012 by way0utwest

I have an encryption talk that I give and usually find a few people in the audience that have implemented encryption. In almost every case this has been because of PCI or HIPAA regulations that dramatically reduce penalties if data is encrypted. … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Regulators, Mount Up

Finding DDL Triggers

Posted on September 13, 2012 by way0utwest

Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious way to tell that a table has a trigger on it and since most tables don’t have triggers, this is … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Finding DDL Triggers

Disabling DDL Triggers

Posted on August 21, 2012 by way0utwest

Suppose you want to stop using a DDL trigger for a short period of time, such as the login trigger I created recently. If you want to disable an index, you use ALTER INDEX xxx DISABLE That doesn’t work for … Continue reading →

Posted in Blog | Tagged , , | 5 Comments