SQL Server 2008 Advanced Database Administration: Part 3
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.
What you'll learn
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.
Table of contents
- 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
- 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
- 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
- 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
About the author
Mel has been delivering technical training since 1994. He has trained students across the USA, in Canada, Germany and the UK. As a Member of Technical Staff (MTS) at Bell Labs in Naperville he worked as a C/UNIX software developer and in Quality Assurance (QA) for 5ESS international switching. Mel first taught computer science while completing his Masters in Computer Science at Bradley University in Peoria, IL. He started working with Visual Basic in 1992 and began teaching VB as an MCT in... more