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 Database Engineer for a software company in Westlake, Ohio. She has worked in the IT industry for 15+ years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms.

I couldn’t help myself…

5 comments, 514 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,473 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, 342 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,731 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,614 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, 431 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, 436 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,256 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, 912 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, 488 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, 485 reads

Posted in Cleveland DBA on 15 June 2012

Performance reviews – Self-evaluations

My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit differently.  For the first time in my career, I’ve been asked to perform a self-evaluation.  There’s no form to fill out.  Overall, it’s very unstructured; we’re simply being asked to… Read more

4 comments, 766 reads

Posted in Cleveland DBA on 11 June 2012

PAGE_VERIFY – Checksum vs. Torn Page Detection

All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a good time to discuss page verification options in SQL Server.  Sometimes bad things happen to good SANs and data pages aren’t quite the same when we read them as when… Read more

4 comments, 3,282 reads

Posted in Cleveland DBA on 7 June 2012

SQLSaturday #164 Cleveland – Tick tock, people!

If you haven’t already heard, Cleveland is hosting SQLSaturday #164 on August 18.  That date is coming up fast and right now we need you (yes you!).  The call for speakers is open for 2 more weeks, so if you’re interested in presenting, submit an abstract.

Cleveland’s last SQLSaturday Read more

4 comments, 365 reads

Posted in Cleveland DBA on 6 June 2012

Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?

Is it just me, or does there seem to be a lot of discussion these days about testing backups and having a good restore plan in place, before you need it.  You don’t want to be “testing” your backups at 3am during a critical restore operation.

Verify Backup Integrity (aka…

Read more

2 comments, 799 reads

Posted in Cleveland DBA on 4 June 2012

Building a SQL Server Inventory – Part 2

Last time I went through my script to gather server information for my inventory. Today I’m going to go through my script to collect SQL Server instance data. So, I think I made it clear last time that I’m not a Powershell guru, and there are probably countless ways in… Read more

5 comments, 2,134 reads

Posted in Cleveland DBA on 31 May 2012

Building a SQL Server Inventory – Part 1

Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with you my script for gathering server-level information as part of my SQL Server inventory. Now, I want to make one thing perfectly clear before we begin, and I can’t… Read more

5 comments, 4,206 reads

Posted in Cleveland DBA on 29 May 2012

SQLSaturday #119 Chicago – In the Books

As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room.  The SQLSaturday #119 afterparty is probably underway, and I’ll head down in a while, but for now I need some time to decompress, recharge my battery.

I’m whooped.  All-day SQL events or training… Read more

2 comments, 368 reads

Posted in Cleveland DBA on 21 May 2012

SQL Saturday #119 – One week to go

One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).

One week from tonight, I’ll be attending my first speaker dinner.

One week from tomorrow, I’ll be presenting at my first SQLSaturday event.  My presentation,  “So I started this blog… now… Read more

0 comments, 326 reads

Posted in Cleveland DBA on 11 May 2012

Blogging Tools: BlogDesk Review

As a blogger, you have several options available to you when it comes to writing posts.  You can write them online, directly inside whatever platform you’re using, be it WordPress, Blogger, TypePad, etc.  If you prefer to write posts offline, you can use a text editor like Word or WordPad… Read more

0 comments, 944 reads

Posted in Cleveland DBA on 30 April 2012

Newer posts

Older posts