Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Cleveland DBA

Colleen Morrow is a SQL Server Consultant at UpSearch, a provider of DBA resources in northeastern Ohio. She has worked in the IT industry for 20 years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms.

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit. To help promote women in technology, I’m declaring… Read more

0 comments, 500 reads

Posted in Cleveland DBA on 24 October 2012

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

2 comments, 1,214 reads

Posted in Cleveland DBA on 18 October 2012

SQLSaturday #171 Pittsburgh recap

This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171.  They picked the perfect time of year to host this event, the leaves changing color made for a really pretty drive.

The Event

The weekend started with the speaker dinner, held inside the Rivers Casino.… Read more

2 comments, 371 reads

Posted in Cleveland DBA on 9 October 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit.  To help promote women in technology, I’m declaring… Read more

0 comments, 536 reads

Posted in Cleveland DBA on 26 September 2012

Parsing Windows event logs with PowerShell

Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that to my Inventory scripts. I like the idea of pulling out the important errors and messages into a central place for easy viewing/reporting. Depending on what platform you’re running… Read more

5 comments, 3,520 reads

Posted in Cleveland DBA on 20 September 2012

SQLSaturday #160 – Get your SQL learn on in Kalamazoo

If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip, come on out to SQLSaturday #160 at Kalamazoo Valley Community College.  There are some fantastic speakers lined up, including Brent Ozar, Jeff Moden, Eddie Wuerch (giving a 2-part series on… Read more

0 comments, 495 reads

Posted in Cleveland DBA on 17 September 2012

SQLSaturday #171, Pittsburgh

Date: October 6, 2012

Title: Searching for the Holy Grail of DDL Auditing

Abstract:

Who altered this view and how? When was that index created? What happened to my stored procedure? From SQL Trace to SQL Audit and everything in between, we’ll explore various methods of auditing events in SQL… Read more

0 comments, 441 reads

Posted in Cleveland DBA on 16 September 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:

Read more

1 comments, 1,210 reads

Posted in Cleveland DBA on 29 August 2012

SQLSaturday #164 – Cleveland – Touchdown!!

SQLSaturday #164 is in the books and the months of work and planning that went into putting this event together really paid off.  This was my first foray into the planning aspect of such an event and it was quite a learning experience.  Putting together a SQLSaturday is hard work!… Read more

5 comments, 466 reads

Posted in Cleveland DBA on 20 August 2012

I couldn’t help myself…

5 comments, 540 reads

Posted in Cleveland DBA on 16 August 2012

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

2 comments, 1,562 reads

Posted in Cleveland DBA on 13 August 2012

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

0 comments, 364 reads

Posted in Cleveland DBA on 8 August 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, 4,970 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

2 comments, 1,701 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, 450 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, 461 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

3 comments, 1,343 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, 991 reads

Posted in Cleveland DBA on 3 July 2012

Goals – The end of one year, start of another

Just about a year ago, I talked about the importance of setting goals for yourself, both personally and professionally, making sure they’re lofty enough to challenge you, and making them public in order to hold yourself accountable.  It’s hard to believe a year has passed already, but here we are,… Read more

5 comments, 530 reads

Posted in Cleveland DBA on 25 June 2012

Slacking Off: The Right Side of the Brain

I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking off, don’t you?  All work and no play makes Colleen a very grumpy DBA, and no one wants that.  So today I’m sharing with you some ways to stretch the… Read more

0 comments, 547 reads

Posted in Cleveland DBA on 15 June 2012

Newer posts

Older posts