This course will teach you all about SQL Server's maintenance plans and what they can (and can't) do. The course starts out briefly covering SQL Server Agent and Database Mail, two components of SQL Server that work in concert with Maintenance Plans. Next, you'll learn about every option available in maintenance plans and how to configure each option. You'll then see video demonstrations that will walk you through every step in the process of creating a maintenance plan using two different methods. And finally, you'll learn the limitations of maintenance plans and where to go next when your systems grow to the point of requiring a more complex maintenance solution. The course is taught using SQL Server 2012, but the content is applicable to SQL 2008 R2, SQL 2008, and SQL 2005. The entire course is over 1.5 hours.
Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.