Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2010

SQL Server 2008 R2 Best Practices Analyzer

A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are literally hundreds of different best practices, and as you might expect, not every best practice applies to every SQL Server environment. That means, that as a DBA, you must evaluate… Read more

2 comments, 1,836 reads

Posted in SQL Aloha on 27 November 2010

How Often Do You Backup Your Transaction Logs?

Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least once an hour. As is with most things DBA-related, there is no exact answer that will meet every SQL Server environment’s needs. The interval between transaction log backups depend… Read more

0 comments, 1,285 reads

Posted in SQL Aloha on 16 November 2010

2010 DBA of the Year Will be Awarded at PASS Opening Night Party

Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s PASS opening night party. If you are attending PASS, and the party, be sure to attend the short awards ceremony, which starts at 9:00PM. The ceremony will be hosted… Read more

0 comments, 652 reads

Posted in SQL Aloha on 6 November 2010 Track at SQL Server Has Record Attendance

This past week, November 3-4, the track at SQL Server Connections has a record 431 attendees. Below are some photos of the track speakers.

Above, I am speaking on “How to Perform a SQL Server Health Check”.

Buck Woody is speaking on “Database Design: The Answer to Life,… Read more

0 comments, 398 reads

Posted in SQL Aloha on 6 November 2010

November Question: What steps do you include in your database maintenance?

Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use to perform your database maintenance. Please be as specific as possible, including what steps you perform, in what order, and how often you typically perform them. By sharing your database… Read more

14 comments, 976 reads

Posted in SQL Aloha on 1 November 2010 Track at SQL Server Connections This Week

If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions at the track to be held on Wednesday, November 3 and Thursday, November 4.

The track includes four speakers presenting a total of nine different session. If you… Read more

0 comments, 458 reads

Posted in SQL Aloha on 1 November 2010