SQL Clone
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, 2,313 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,735 reads

Posted in SQL Aloha on 16 November 2010

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

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

0 comments, 831 reads

Posted in SQL Aloha on 6 November 2010

SQLServerCentral.com Track at SQL Server Has Record Attendance

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

0 comments, 597 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, 1,356 reads

Posted in SQL Aloha on 1 November 2010

SQLServerCentral.com 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 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

0 comments, 592 reads

Posted in SQL Aloha on 1 November 2010