Introduction This modular 12-hour clinic allows you to skip to the
tracks which are most relevant to you. This clinic will help DBAs
understand how to exploit the new SQL Server 2008 capabilities, how
to enable application scalability, and how to manage a database
that makes use of the new features in SQL Server 2008.
This clinic covers the following topics.
- Availability, Security, Scalability, and Resource Management
and Troubleshooting Enhancements
- Policy-Based Management and Multi-Server Administration
- Performance Data Collection
- Management Implications of New Features
The prerequisites for this clinic are as follows:
- Participants must have real-world SQL Server 2000 or SQL Server
2005 administration experience
- Participants must have basic operational familiarity with SQL
Server Management Studio
- Participants are encouraged to have real-world experience
designing and implementing database schemas
Objectives At the end of the course, students will be able to:
- Learn about the new features of SQL Server 2008 that developers
will use that have management implications
- Deep and intensive 200-300 level technical training
custom-designed for professional DBAs and IT-Pros
- Courseware developed by Paul S. Randal and Kimberly L. Tripp of
www.sqlskills.com, pre-eminent experts in SQL Server
administration
- Get hands-on experience with SQL Server 2008 administration
(not available in all locations)
Modules & Lessons Essential SQL Server 2008: Database
Infrastructure and Scalability Module Overview Essential SQL Server
2008: Database Infrastructure and Scalability Introduction Module
Objectives for each workshop Availability Enhancements Module
overview Demo: Database Mirroring automatic page repair Database
Mirroring enhancements continued, automatic page repair, log stream
Backup compression and using Transparent Data Encryption (TDE) to
encrypt data Hot-add CPU, DBCC CHECKDB enhancements, failover
clustering enhancements Peer-to-peer replication enhancements Demo:
Peer-to-peer replication Policy-Based Management and Multi-Server
Administration Module overview, central management server Demo:
Central management server Central management server metadata,
multi-server script execution Demo: Multi-server script execution
Policy-based management overview, conditions, facets and policies
Policy-based management demo: Facets and conditions Applying facets
and conditions to policies, policy enforcement Demo: Applying
facets and conditions to policies Policy based management
architecture and execution Demo: Applying policies to multiple
servers Policy based management advanced topics Performance Data
Collection Module overview, management data warehouse Demo:
Creating and configuring a management data warehouse Data
collection overview and architecture Demo: Configuring system data
collection on an instance Demo: Transact-SQL custom data collection
Data collection reports and module summary Resource Management and
Troubleshooting Enhancements Module Overview Demo: Resource
Governor Extended events, predicates, actions, targets, types,
maps, sessions Security Enhancements Module overview Transparent
data encryption Demo: Transparent data encryption Backups and
transparent data encryption, transparent data encryption
limitations Integrated authentication enhancements, SQL Server 2008
auditing improvements Demo: SQL Server 2008 all actions audited
Security Summary Management Implications of New Features Part 1
Module overview, spatial indexes, integrated full-text search
Problems addressed by sparse columns Demo: Sparse columns and
column sets Sparse columns and filtered indexes, best practices for
sparse columns Demo: Constructing tabular data sets with sparse
columns Limitations of sparse columns and interaction with other
features Overview of filtered indexes Demo: Using filtered indexes
with sparse columns Filtered statistics, monitoring filtered
indexes and statistics Demo: Using filtered indexes for improved
index coverage Management Implications of New Features Part 2
Filtered index best practices Demo: Filtered index system metadata
Filtered index limitations Change tracking overview, change
tracking best practices Change data capture (CDC) overview Demo:
Change Data Capture Blob storage with Filestream overview, enabling
Filestream Filestream security, filestream and transactions,
monitoring filestream storage Demo: Filestream manageability demo
Scalability Enhancements Data compression overview, data
compression trade-offs Demo: Estimating data compression space
savings Estimating data compressing space savings, choosing row
compression Demo: Enabling compression and comparing performance
Enabling and disabling compression, data compression options and
syntax Service broker improvements, Service Broker conversation
priority Query optimizer enhancements, MERGE overview Forcing query
optimizer plans with plan guides Demo: Using plan guides Star join
optimizer improvements Partitioning enhancements overview,
partition-aligned indexed views Partitioning and lock escalation
enhancements Demo: Improving concurrency with partition lock
escalation Module review System Requirements To view this course,
you need:
- A Pentium II, 256 MB RAM with a processor speed greater than or
equal to 400 MHZ
- Microsoft® Windows® 2000 or higher
- Microsoft Internet Explorer 6.0 or higher
- Adobe Flash 7.0 or higher (1MB disk space needed to
install)
- Microsoft Silverlight 4.0 or higher
- Microsoft Windows Media Player 7.0 or higher
- Microsoft XML Core Services 3.0 or higher
- A Super VGA monitor with minimum screen resolution 1024x768,
with 16-bit color.
- A sound card, and either speakers or headphones (for
multi-media audio).
- Internet bandwidth of 56K or faster. Broadband internet access
is recommended.
For courses containing Virtual Server-based labs (courses in the IT
Professional and Developer Catalog), you will need:
- Microsoft Virtual Server ActiveX control (1MB disk space needed
to install)
Test your computer's capabilities to see if it supports this
course. Accessibility Requirements The following software must be
running on your computer in order to access this course with Screen
Reader Software:
- Microsoft Internet Explorer 6.0 or higher
- Window-Eyes from GW Micro
- JAWS from Freedom Scientific
- MSAA enabled