Category Archives : Powershell

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

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