Monthly Archives: August 2012


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 […]

AuditLocator2

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 […]


SQLSaturday #160, Kalamazoo

Date: September 22, 2012 Title: So I started this blog…now what? Abstract: Ever thought about trying your hand at blogging? Or maybe you’ve started a blog but struggle with what to write about. We’ll take a beginner’s look at blogging and examine what makes a great blog, finding topics, finding your voice, building authority and […]