Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2010

How Often Do You Run CHECKDB Against Your Databases?

I recently ran a poll, asking DBAs how often they ran DBCC CHECKDB against their databases. Compared to some of the polls I have run recently, I was somewhat pleasantly surprised by the results.

My first pleasant surprise was that at least 90% of those polled knew what DBCC CHECKDB… Read more

1 comments, 919 reads

Posted in SQL Aloha on 21 October 2010

When Times are Tough, Do You Rise to the Occasion?

This is a reprint of my editorial in Database Weekly.

Scenario One: The new third-party application, purchased by your company without your involvement, is performing poorly on SQL Server. As the DBA, you are getting a lot of flak from users and management, but your hands are severely tied… Read more

0 comments, 136 reads

Posted in SQL Aloha on 17 October 2010

SQL Server Database Maintenance Checklist

In this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new book I am writing. The focus of this checklist is database maintenance.

Database maintenance includes a defined set of proactive tasks that a DBA needs to perform on a periodic… Read more

2 comments, 1,065 reads

Posted in SQL Aloha on 4 October 2010

October Question: Tell us about your favorite experience as a participant in the SQL Server community.

There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to share your knowledge. Based on your personal experience, tell us about your favorite experience as a participant in the SQL Server community. For example, tell us about meeting someone new,… Read more

6 comments, 654 reads

Posted in SQL Aloha on 1 October 2010