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
Level
Advanced
Updated
Mar 2, 2010
Duration
3h 6m
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
Description
Course info
Level
Advanced
Updated
Mar 2, 2010
Duration
3h 6m
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
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
More courses by Mel Haynes