Table of Contents
1. Changes in the Database Paradigm: How SQL Server 2005 Redefines the Role of a DBA
SQL Server 2005 and Database Administrators
2. SQL Server 2005 Database Engine Architectural Changes
The SQL Server Operating System (SQLOS)
Non-Uniform Memory Access (NUMA) Architecture Support
Query Optimization and Execution
Statistics Management in SQL Server 2005
System Metadata Access and the Security Architecture
Metadata Access and Visibility
Storage Engine and I/O Changes
3. SQL Server 2005 Setup and Deployment
Hardware and Software Requirements for Installing SQL Server 2005
SQL Server 2005 Enterprise Edition 32-Bit Requirements
SQL Server 2005 Enterprise Edition 64-Bit Requirements
SQL Server 2005 Setup Enhancements
Deprecated and Discontinued Database Engine Functionality
Breaking and Behavior Changes to the Database Engine
SQL Server 2005 Upgrade Advisor
4. A Tour of New Features in SQL Server 2005
Database Administration and Management
Introducing SQL Server Management Studio
SQL Server Configuration Manager
SQLCMD and Dedicated Administrator Connection
DDL Triggers and Event Notifications
Management APIs: SMO, RMO, AMO, and WMI
Scalability, Performance, and Reliability Enhancements
SQL Server 2005 Express and Mobile Editions
Recursive and Non-recursive Common Table Expressions (CTEs)
Limiting a Result Set by Using TOP and TABLESAMPLE
Password Policy Enforcement and Strengthening of SQL Authentication
Module Execution Context and Impersonation
Performance Monitoring and Tuning Enhancements
Database Engine Tuning Advisor
The Blocked Process Threshold Setting
Database Mirroring and Snapshot
Online, Piecemeal, and Page Restore
Business Intelligence Redefined
Introducing Business Intelligence Development Studio
5. SQL Server 2005 Tools and Utilities
Business Intelligence Development Studio
Performance Monitoring, Tuning, and Optimization Tools
New Performance Monitor Counters
Database Engine Tuning Advisor
SQL Server Configuration Manager
SQL Server Management Objects (SMO)
Windows Management Instrumentation (WMI)
Common Table Expressions (CTEs)
Large Object Data Type Enhancements
The ROW_NUMBER Ranking Function
The RANK and DENSE_RANK Ranking Functions
New Relational Operators: PIVOT, UNPIVOT, and APPLY
New Declarative Referential Integrity Actions
Metadata Views and Dynamic Management Views
Miscellaneous T-SQL Enhancements
New Server Configuration Options
The EXCEPT and INTERSECT Operators
The SET SHOWPLAN_XML and SET STATISTICS XML Statements
An Introduction to Security in SQL Server 2005
SQL Browser Service and the New Security Model
Strengthening SQL Authentication
SQL Server 2005 Security Terminology
Surface Area Configuration (SAC)
SQL Server Agent Security Overview
Service Broker Security Overview
8. Reliability and High Availability in the Database Engine
Backup and Restore Media Checks
Online, Piecemeal, and Page Restorations
The EMERGENCY Database State Option
Failover Clustering Enhancements
Online and Parallel Index Operations
Enhanced Multi-instance Support
Dedicated Administrator Connection
9. Performance Analysis and Tuning
Physical Database Design, Analysis, and Tuning
Creating Indexes with Included Columns
Creating Indexes on Computed Columns
Optimizing Physical Design Structures by Using Database Engine Tuning Advisor
Troubleshooting Locking and Blocking
Using the Blocked Process Threshold Option
Row Versioning and Snapshot Isolation
Analyzing Deadlocks by Using SQL Profiler
Locking and Blocking Monitoring Tools
Designing Applications for Performance
Service Broker and Asynchronous Messaging
Performance Monitoring and Tuning Tools
10. XML and Web Services Support in SQL Server 2005
Validating XML Data by Using Typed XML
Native XML Web Services Support
Introduction to SOAP, Web Services, and WSDL
Administering HTTP SOAP Endpoints
11. SQL Server 2005 and .NET Integration
12. SQL Server Integration Services Overview
Business Intelligence Development Studio
SSIS Package to Import Flat Files into Tables
13. What’s New in SQL Server Analysis Services 2005
OLAP, Data Warehousing, Business Intelligence, and Data Mining
Analysis Services Fundamentals
Data Explosion and Data Sparsity Handling
Analysis Services 2005 Enhancements
Integrated Tools and the Enhanced User Interface Experience
Unified Dimension Model (UDM) and Proactive Caching
Analysis Management Objects (AMO)
Performance Tuning for Analysis Services
Usage-Based Optimization (UBO)
Administering Analysis Services
Analysis Services Database Backup
Cube and Mining Model Processing
Analysis Services Security Overview
Migrating from SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services
SQL Server 2005 Reporting Services (SSRS) Overview
Reporting Services Components and Tools
Reporting Services 2005 Enhancements
An Introduction to Asynchronous Messaging
Asynchronous Messaging in a Database
Service Broker and Other Messaging Technologies
Service Broker Operations and Troubleshooting
Service Broker Security Overview
15. SQL Sever 2005 Support for 64-Bit Processors
64-Bit Processor Usage Scenarios
Improving Performance of Memory-Constrained Applications
High-Performance Data Warehousing Applications