SQL Server 2008 Advanced Database Administration: Part 3

Pluralsight
Course Summary
Part 3 of 3 in the SQL Server 2008 Advanced Database Administration series will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security.
-
+
Course Description
Part 3 of 3 in the SQL Server 2008 Advanced Database Administration series will teach database administrators and developers advanced database infrastructure design, optimization, maintenance, troubleshooting and security. To get the most out of this course, you should have at least one year of experience working with SQL Server 2008 and have a strong grasp of database administration fundamentals.
-
+
Course Syllabus
SQL Server 2008 Resource Governor- 1h 3m
—Introduction 2m 35s
—Activity Monitor 8m 4s
—Trace Flags 3m 39s
—SQL Server 2008 Reports 5m 46s
—Job Activity Monitor 2m 46s
—SQL Server 2008 Logs 3m 43s
—Dynamic Management Views and Functions 6m 31s
—Using Dynamic Management Views 9m 41s
—SQL Server Audits 8m 56s
—Dedicated Administrator Connection (DAC) 9m 30s
—What We Covered 2m 1sMonitoring SQL Server 2008- 28m 11s
—Introduction 1m 9s
—SQL Server Profiler 2m 50s
—Database Engine Tuning Advisor 3m 23s
—Using the SQL Server Profiler and Database Engine Tuning Advisor 11m 11s
—Query Analysis and Execution Plans 1m 1s
—Using Execution Plans for Query Analysis 5m 45s
—Other Performance Tuning Tools 0m 41s
—What We Covered 2m 11sSQL Server 2008 Performance Tuning- 21m 44sSQL Server 2008 PowerShell- 27m 38sSQL Server 2008 Integration Services- 32m 32sPreparing for Your MCITP: 70-450 Certification Exam- 8m 57sNext Steps- 3m 43s