Part 1 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You’ll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you’re new to SQL Server administration, you’ll benefit from this introduction as it introduces you to a broad range of topics.
Author Name: Sean McCown
Author Description:
Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 15 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs at Midnight. He is also the Lead Database Administrator for a large healthcare organization and oversees all aspects of development and administration for over 800 servers. Sean is a Contributing Editor… more

Table of Contents

• Course Introduction
  3mins
• Planning
  31mins
• Installing SQL Server 2012
  37mins
• Advanced Installation
  39mins
• Basic Database Objects
  37mins
• Using SQL Server Management Studio
  31mins
• Database File Management
  39mins
• Database Configuration Options
  26mins
• Special Database Space Considerations
  38mins