Archive for July, 2012
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
SQLSaturday #164, Cleveland
Date: August 18, 2012 Session 1 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 [...]
July 10, 2012
Posted in: Events No Comments
SQLSaturday #122, Louisville
Date: July 21, 2012 Session: 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 [...]
July 10, 2012
Posted in: Events No Comments
SQL Audit 101 – Creating a basic audit
SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in SQL Server, meaning it could be managed by DDL statements. It was built on the extended events framework and what made it really neat was that the event was recorded when the permission-check for that [...]
July 9, 2012
Tags: Auditing, SQL Audit, SQL Server Posted in: Features 3 Comments
