This course will provide the non-DBA with everything they need to effectively manage SQL Server - an overview of Microsoft SQL Server 2012, basic database concepts, and suggested maintenance jobs to keep your SQL Server running smoothly. The course includes videos, demos, sample T-SQL scripts, and suggested resources for more in-depth study. Total time is slightly over 4.5 hours. This course is designed for new or junior Database Administrators or non-database professionals who need to maintain the SQL Server systems in their environment.
In this section, you will learn about the growth settings for files and their performance implications.
The different database recovery models are presented in this section, as well as how they relate to backup methods. (Note: There is a slight error at the 7:24 mark in the video. In the example, I say "...restore the Sunday night full backup, the Thursday night full backup..." It should be "...restore the Sunday night full backup, the Thursday night DIFFERENTIAL backup...")
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.