Our database systems become more important to the operation of our world all the time. We store data from sensors, back commerce systems, and more. We know software has bugs, and there will be security lapses, perhaps even from insiders. I suspect that as our software evolves, auditing will become more and more important all the time.
This week I'm curious to what extent you have auditing in your environment. For some of us it's included in the software we write, for others we might have to retrofit auditing when some issue occurs, but most applications I've used have very limited auditing or logging capabilities.
How extensively is auditing deployed in your environment.
Whether it's something simple like a Trace or Extended Events, the built-in SQL Audit, or some third party product, what percentage of your applications use some sort of auditing or logging? Is it a requirement, perhaps for certain types of systems? Or is it rarely implemented?
I think auditing will become more prevalent in the future, perhaps even a core function that we expect to find in every piece of new software.
Steve Jones
The Voice of the DBA Podcasts
We publish three versions of the podcast each day for you to enjoy.
- Watch the Windows Media Podcast - 19.3MB WMV
- Watch the iPod Video Podcast - 15.0MB MP4
- Listen to the MP3 Audio Podcast - 3.1MB MP3
The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:
Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. They have a great version of Message in a Bottle if you want to check it out.
I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.