Part 2 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

• Server-Level Configurations
  29mins
• Database Console Commands (DBCC)
  39mins
• Server-Level Security
  24mins
• Database-Level Security
  34mins
• Transaction Logs and Recovery Models
  28mins
• Instance Configuration and Management
  31mins
• Working with Concurrency Problems
  39mins
• Collecting Troubleshooting Data
  36mins
• Auditing SQL Server
  38mins