Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Cleveland DBA

Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data.

Archives: 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… Read more

5 comments, 5,772 reads

Posted in Cleveland DBA on 31 July 2012

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… Read more

3 comments, 2,317 reads

Posted in Cleveland DBA on 16 July 2012

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… Read more

0 comments, 553 reads

Posted in Cleveland DBA on 10 July 2012

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… Read more

0 comments, 551 reads

Posted in Cleveland DBA on 10 July 2012

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… Read more

4 comments, 1,890 reads

Posted in Cleveland DBA on 9 July 2012

SQL Server Auditing – Getting started

In my organization, one of my jobs is auditing our database environment.  I’ve been tasked with this responsibility for several years now, and it hasn’t always been easy.  In fact, I used to despise the entire process.  Why?  Because I wasn’t using the right tool for the job.  I didn’t… Read more

5 comments, 1,422 reads

Posted in Cleveland DBA on 3 July 2012