Event Notifications 101 – Intro to Event Notifications
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server.В And I told you all about how to use SQL Audit to monitor what’s going on in your databases.В Remember that?В If you do, you might also recall that I mentioned there being more than one [...]
April 15, 2013
Tags: Auditing, Event Notifications, SQL Server Posted in: Features 
2 Comments
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
