SQL Server 2012 Database Administration (70-462) Part 2
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Server-Level Configurations- 29m 28s
—sp_configure 23m 38s
—Authentication Modes 5m 50sDatabase Console Commands (DBCC)- 39m 4s
—Introduction 0m 53s
—DropCleanBuffers 4m 23s
—ShrinkDatabase and ShrinkFile 7m 28s
—FreeProcCache 4m 4s
—CheckDB and CheckTable 10m 58s
—SQLPerf 5m 50s
—InputBuffer 2m 56s
—Help 2m 32sServer-Level Security- 24m 4sDatabase-Level Security- 34m 51sTransaction Logs and Recovery Models- 28m 13sInstance Configuration and Management- 31m 34sWorking with Concurrency Problems- 39m 26sCollecting Troubleshooting Data- 36m 58sAuditing SQL Server- 38m 4s