How to Get the Most Out of the Maintenance Plan Wizard
Many non-DBAs and novice DBAs take advantage of SQL Server’s Maintenance Plan Wizard in order to create SQL Server database maintenance plans. If used properly, the Maintenance Plan Wizard can be an easy way for less experienced DBAs to help maintain their SQL Server databases. On the other hand, if the Wizard is used improperly (and unfortunately, the Wizard doesn’t prevent DBAs from making mistakes), database performance and uptime can be put at risk. In this session, attendees will learn, step-by-step, exactly how to use the Wizard in order to create a maintenance plan that will enhance the performance and uptime of their SQL Server databases. Every step, and every option, will be thoroughly explained in detail, providing the DBA with the information they need to create a maintenance plan that will work well for their environment. This session is filled with demonstrations, and assumes attendees have little or no practical experience with the Maintenance Plan Wizard.
Red Gate Software
Director of DBA Education
Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelor’s degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 15 years SQL Server experience, over 6 years training experience, and has been involved in the industry since 1982. Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 15 years’ cumulative knowledge. In 2009, Brad made 33 public presentations to a total of 1,853 attendees, in six different countries. Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 250 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans. He blogs at www.bradmcgehee.com.
Register Now for PASS Summit 2010!