SQL Audit – User-defined Audit Events
One thing I failed to touch on during my series on SQL Audit was the use of user-defined events in audits. This was brought to my attention in a comment by one of my readers. He was trying to make use of user-defined events and was having a problem getting the output to actually write [...]
October 18, 2012
Tags: Auditing, SQL Audit, SQL Server Posted in: Features 
No Comments
SQL Audit 302 – Deploying the Audit Solution with Powershell
This is it, ladies and gentlemen.В One last post and I promise I won’t mention the word audit for at least a week. Before we begin, let’s take a moment to recap what we’ve covered so far: SQLAudit 101 – Creating a basic audit SQLAudit 102 – Reading audit output SQL Audit 201 – Creating [...]
August 29, 2012
Tags: Auditing, powershell, SQL Audit, SQL Server Posted in: Features, Powershell One Comment
SQL Audit 301 – Using Powershell to Manage Audits
Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell and SMO. Managing SQL Audit objects via PowerShell is actually pretty simple, even for a newbie like me. And I’m proud to say that these might be the first PowerShell scripts I’ve written that were [...]
August 13, 2012
Tags: Auditing, powershell, SQL Audit, SQL Server Posted in: Features, Powershell 2 Comments
SQL Audit 201 – Creating an Audit Solution
Welcome back, folks! Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s put the pieces together to form a complete solution. As with any implementation, the key to success lies in careful planning. Before we take off running, we need to take a moment and figure [...]
July 31, 2012
Tags: Auditing, SQL Audit, SQL Server Posted in: Features 6 Comments
SQL Audit 102 – Reading audit output
Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in place, you’re going to want to look at the output once in a while, right? Right. So that’s what we’re going to go over today. If you’re using the default file output for your audit, [...]
July 16, 2012
Tags: Auditing, SQL Audit, SQL Server Posted in: Features 2 Comments
