Expanded

SQL Server 2008 Advanced Database Administration: Part 3

By Mel Haynes
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 info
Rating
(36)
Level
Advanced
Updated
Mar 2, 2010
Duration
3h 5m
Table of contents
SQL Server 2008 Resource Governor
Introduction 3m Activity Monitor 8m Trace Flags 4m SQL Server 2008 Reports 6m Job Activity Monitor 3m SQL Server 2008 Logs 4m Dynamic Management Views and Functions 7m Using Dynamic Management Views 10m SQL Server Audits 9m Dedicated Administrator Connection (DAC) 10m What We Covered 2m
Monitoring SQL Server 2008
Introduction 1m SQL Server Profiler 3m Database Engine Tuning Advisor 3m Using the SQL Server Profiler and Database Engine Tuning Advisor 11m Query Analysis and Execution Plans 1m Using Execution Plans for Query Analysis 6m Other Performance Tuning Tools 1m What We Covered 2m
SQL Server 2008 Performance Tuning
Introduction 1m Managing Resource Utilization 1m Grouping Server Resources and Classification 2m Classifier Functions 2m Creating a Classifier Function 6m Security for Resource Governor 1m Resource Pools 2m Creating a Resource Pool 1m Creating the Resource Pool and Workload Group 5m Vocabulary Review 1m What We Covered 1m
SQL Server 2008 PowerShell
Introduction 2m Introduction to PowerShell 2m Running PowerShell 1.0 with SQL Server 2008 3m Launching PowerShell 2m Execution Policy Setting 3m Using Execution Policy Cmdlets 1m The SQL Server PowerShell Virtual Drive SQLSERVER 3m Foundational PowerShell Commands 4m SQL Server Specific Cmdlets 5m What We Covered 2m
SQL Server 2008 Integration Services
Introduction 1m Introduction to Integration Services (SSIS) 5m Installation and Configuration 2m SSIS Service Account and Firewall 4m Modifying MsDtsSrvr.ini.xml and the Windows Registry 2m SSIS Configuration File 5m Running an Integration Services Package 1m Using the 'Integration Services' (Import/Export) Wizard 7m Rerunning a Package Via SSMS 1m Other Methods of Running a Package 2m What We Covered 1m
Preparing for Your MCITP: 70-450 Certification Exam
Introduction 1m Three SQL Server 2008 Certification Levels 1m Three SQL Server 2008 Certification Tracks 1m Microsoft Certified IT Professional (MCITP) 1m MCITP 2005 Upgrade Exams 1m Microsoft Certified Master (MCM) 1m SQL Server 2008 Certifications 1m Preparing for Your 70-450 Certification Exam 3m What We Covered 0m
Next Steps
Course Recap 1m Steps for Follow Up 2m We'd Like Your Opinion 1m
Description
Course info
Rating
(36)
Level
Advanced
Updated
Mar 2, 2010
Duration
3h 5m
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.

About the author
Mel Haynes
About the author

Mel has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK.

More from the author
SQL Server 2008 Advanced Database Administration: Part 1
Advanced
3h 22m
Mar 2, 2010
SQL Server 2008 Advanced Database Administration: Part 2
Advanced
5h 3m
Mar 2, 2010
More courses by Mel Haynes

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT