Microsoft SQL Server Upgrading Admin Skills
from
2005 to 2008
Length: 3 Days
Prerequisites:
Prior knowledge of SQL, Basic Knowledge, Relational
Database Theory
OverviewLearn the
enhancements and how to use them effectively
in
Microsoft SQL Server Version 2008
.
Key
Benefits: When you complete this course you will
be able to use the new transact SQL, security and data
collection enhancements.
Outline
Chapter 1. Transact SQL Enhancements
- New Data Types
- Group by Changes
- Merge
- New Management Objects
Chapter 2. Data Collector
- Getting Started
- Data Collector Security
- Configure the Management Data Warehouse
- Enable Data Collection
- Disk Usage
- Server Activity
- Collection Set Definitions
Chapter 3. SSRS and SSIS
Enhancements
- SQL Server Reporting Services
- SQL Server Integration Services
- Data Profiler
- New Debug Dump Files
Chapter 4. Performance and Tuning
Enhancements
- Table and Query Hints
- Query Performance and Processing
- Plan Freezing
- Assigning the Plan to the Guide
Chapter 5. Storage Enhancements
- Filtered Indexes
- Sparse Columns
- Column Sets
- Data Compression
- Backup Compression
Chapter 6. Filestream
- Understand When and How to Use Filestream
- Filestream Requirements
- Integrated Security
- Transact SQL Access
- Isolation Semantics
- Write-Through From Remote Clients
- The Filestream Database
Chapter 7. Resource Governor
- Installation
- Resource Pools
- Workload Groups
- SQL Server Views
- Classifier
- Configuring the Resource Governor
Chapter 8.Security Enhancements
- Auditing
- Encryption Functions
- Policy Based Management
Chapter 9. Database
Mirroring Automatic Page Repair
- Performance Enhancements
- Automatic Page Repair
Chapter 10 Replication
Enhancements
- Peer-to Peer Replication
- Conflict Types
- Enabling Conflict Detection
- Handling Conflicts
- Topology Management
- Support for Partitioned Tables
Chapter 11. Change Data Capture and Change
Tracking
- Change Data Capture
- Change Tracking
- The Change Table
- SQL Agent Jobs
Back to Course Listing
