Monthly Archives: March 2012


Backup script skipping databases – and the fix!

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 Server log, no errors. I checked the Windows […]

A real head-scratcher

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 really just a wrapper for […]


Work it, girl.

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 (off to the side a bit, in a jaunty […]