Brad M. McGehee is the Director of DBA Education for Red Gate Software and is an accomplished Microsoft SQL Server MVP with over 16 years SQL Server experience. Brad is a frequent speaker at SQL PASS, European PASS, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, and SQL Server user groups, where he shares his 16 years’ cumulative knowledge and experience.
Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance. In this session, you will learn the key things all DBAs need to know in order to maintain their databases at peak performance.
You will learn about a comprehensive checklist you can use to verify a SQL Server’s health, which you can use to help you determine if the instance is running optimally and is highly available.
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
|
Reprinted from my Database Weekly editorial. Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned the SQL Server 2012 certification program, making is more difficult, costly, and time-consuming to attain. In addition, whether you like it or not, ...
|
|
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections (a part of the greater DevConnections event) in Las Vegas, NV, October 29 – November 1, 2012, at the Bellagio Hotel. This is in addition to the SQL Server tracks that are being ...
|
|
I was just at SQLRally in Dallas, and I was speaking to a DBA friend of mine over lunch. He made the comment that his manager thought he spent too much time at work taking care of the organization’s data. He told me that he spent so much time at his job because he wanted [...]
|
|
In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have compiled the results, and below are the most popular books my blog’s readers picked. If you are looking for a good SQL Server book to learn from, then you might want to consider reading one [...]
|
|
Now that SQL Server 2012 has been released, this month’s question is “How soon will you begin implementing SQL Server 2012?” If you have done so already, share with us your experience. If you will be waiting to implement 2012, tell us why. Post your responses to the SQL Server ...
|