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

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

Tracy Hamlin, selected as the 2010 DBA of the Year, will be awarded her trophy at this year’s SQLServerCentral.com 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

This past week, November 3-4, the SQLServerCentral.com track at SQL Server Connections has a record 431 attendees. Below are some photos of the SQLServerCentral.com 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

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

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

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