Tag Archives: auditing

The Future of Auditing

This editorial was originally published on Dec 5, 2013. Is it being re-run as Steve is on holiday. I was reading Captain’s Share the other day and enjoying a quiet afternoon at home. It’s a science fiction book about one man’s … Continue reading

Posted in Editorial | Tagged | 1 Comment

Who’s Touching My Database

Abstract: As databases become more critical to the operation of our organizations, we are being asked to audit and report on access to both data and the configuration of our systems. SQL Server has a number of features that can … Continue reading

Posted in Presentations | Tagged , ,

Finding out Who’s Touching Your Database at DevConnections

I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready … Continue reading

Posted in Blog | Tagged , , ,

T-SQL Tuesday #81–Sharpening Skills

This is an interesting month for T-SQL Tuesday. The challenge is from Jason Brimhall to Sharpen Something, and learn something new. However, his challenge isn’t just a simple “learn something.” Instead, he writes: “This month I am asking you to … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

Architecture for Auditing

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 , ,

Native Audits

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 ,

Can Auditing Fail?

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 ,

QA for Data

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

Quick Schema Auditing

I was working on a demo recently and needed to show that a little monitoring can help you catch schema changes. At first I looked at SQL Audit and DDL Triggers, but then I ran across a short custom metric … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Disconnecting Auditing

We know security is becoming more and more of a topic for IT professionals. As we realy more heavily on our computer systems, we have to be sure that the information contained in them is secure. We know that we … Continue reading

Posted in Editorial | Tagged , , ,