Click here to monitor SSC
SQLServerCentral is supported by Redgate
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.

Archives: February 2012

RYO Maintenance Plan – Update Statistics

Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose the best execution plan for your queries. Let your stats get too far out of date, and watch your query performance tank.

For me, the biggest shortcoming of the update… Read more

2 comments, 1,953 reads

Posted in Cleveland DBA on 21 February 2012

Using Powershell to Deploy Performance Monitor

As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight into what’s changed when performance is suddenly in the toilet. They can also provide a basis for determining what systems can be consolidated, downsized, or virtualized, which has become quite… Read more

4 comments, 1,809 reads

Posted in Cleveland DBA on 13 February 2012

RYO Maintenance Plan – Enhancement Request

In response to my last post, I got a very interesting comment from Philip:

“I would love to see a way to add logic that will verify at least X backup files for a given DB remain. Specifically, in my organization, I would like to delete all but the most…

Read more

0 comments, 1,078 reads

Posted in Cleveland DBA on 9 February 2012

RYO Maintenance Plan – Database Backups, Part 3

4 out of 5 DBAs agree

I’ve covered creating my backup directories and the actual backup of the database(s). The last thing I want to do in my process is clean up any old backup files. Once again, I want to allow for some flexibility in my procedure. Much… Read more

5 comments, 1,656 reads

Posted in Cleveland DBA on 6 February 2012