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: March 2012

Backup script skipping databases – and the fix!

A real head-scratcher

I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost. One day I noticed that the backup script hadn’t backed up all of the databases on my instance. I checked the job history, no errors. I checked the SQL… Read more

5 comments, 1,606 reads

Posted in Cleveland DBA on 26 March 2012

RYO Maintenance Plan – History Cleanup

The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step. I know. Cleanup is never the sexiest of jobs, but just like the dishes or the laundry, it still needs to be done occasionally.

If you were to create an… Read more

0 comments, 720 reads

Posted in Cleveland DBA on 22 March 2012

RYO Maintenance Plan – Integrity Checks

Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it was here in Cleveland.

Today’s piece of RYO Maintenance Plan deals with database integrity checks; a critical component second only to backups in my book.  The procedure I’ve written is… Read more

0 comments, 684 reads

Posted in Cleveland DBA on 19 March 2012

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

Every month the folks of the SQL Server community get together for a virtual block party of sorts called T-SQL Tuesday.  This month’s party is being hosted by Argenis Fernandez (b|t).  The topic: specialization.  Some folks wear many hats within an organization, others wear only one… Read more

1 comments, 446 reads

Posted in Cleveland DBA on 13 March 2012

March Madness – SQL Server style

Bodypaint not required

It seems that March is another great month for getting your geek on without having to leave the comforts of your desk. Here are some of the SQL Server events still coming up this month:

March 14

Read more

0 comments, 468 reads

Posted in Cleveland DBA on 8 March 2012

RYO Maintenance Plan – Index Maintenance

It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been busily working on a separate writing project, but I’m back now and ready to continue rolling my own maintenance plan. To recap, so far I’ve covered backups, backup cleanup Read more

1 comments, 1,071 reads

Posted in Cleveland DBA on 5 March 2012