SQL Clone
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: June 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, 1,011 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, 990 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, 3,038 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

5 comments, 9,333 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, 627 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, 1,417 reads

Posted in Cleveland DBA on 4 June 2012