SQL Server 2008 Administration (70-432): Part 2
Pluralsight
Course Summary
Part 2 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system.
-
+
Course Description
Part 2 of 2 in the SQL Server 2008 Administration (70-432) series. This SQL Server 2008 Administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, replication, and optimized use of SQL server FileGroups. Whether you're a beginner or experienced in SQL Server administration, you will benefit from this in-depth course.
-
+
Course Syllabus
Performance- 38m 34s
—Introduction 1m 14s
—SQL Profiler/SQL Trace (T-SQL) 10m 10s
—Windows System Monitor 4m 6s
—Activity Monitor 3m 42s
—Transact-SQL 4m 32s
—Windows Logs 3m 4s
—Default Trace 5m 2s
—Dynamic Management Views 3m 38s
—Monitoring Tools Comparison 1m 21s
—What We Covered and Terminology 1m 45sAutomating Administrative Tasks- 37m 49s
—Introduction 0m 52s
—SQL Server Agent 4m 58s
—Configuring SQL Server Agent 9m 50s
—Key Fixed Database Roles 5m 27s
—Creating and Running Jobs 8m 27s
—Subsystem 1m 47s
—Proxy 1m 31s
—Security Guidelines 4m 57sHigh Availability- 28m 32sReplication- 1h 5mResource Governor- 27m 54sPerforming Data Management Tasks- 32m 54sData Compression- 25m 51sSQL Server 2008 Common Commands- 24m 23sDatabase Mail- 23m 0sSQL Server 2008 Certification 101- 5m 26sRunning SQL Server 2008 in Hyper-V- 45m 47s