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.