Tag Archives: auditing

Architecture for Auditing

Posted on June 4, 2015 by way0utwest

In the analog world, when we need to provide an auditing system for checking on physical activity, we usually separate out the roles of people that might record or track activity from those that perform activities. The better separation we … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Architecture for Auditing

Native Audits

Posted on May 22, 2015 by way0utwest

As our databases contain more and more information, it is becoming increasingly more common to implement some sort of auditing feature to ensure that our data is not being inappropriately accessed or altered. It’s not only the management of our … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Native Audits

Can Auditing Fail?

Posted on May 5, 2015 by way0utwest

I saw someone’s list of requirements for a SQL Server auditing system recently that included many of the standard items most of us would want. DDL changes should be captured, along with configuration alterations. The performance impact should be low, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Can Auditing Fail?

QA for Data

Posted on April 16, 2015 by way0utwest

Here’s a typical DBA scenario. You’re at your desk, working on something, when you get a trouble ticket, phone call, or tap on your shoulder. There’s a problem in production and an order, or some other important piece of data, … Continue reading →

Posted in Editorial | Tagged , | 1 Comment