An Overview of SQL Server

• New Features
• Database Roles
• Client Tools

Installing SQL Server

• Preparing For Installation
• Setup User Interface
• Installing Express Edition
• Configuring an New Instance

SQL Server Notification Services (SSNS)

• Overview
• Subscription Management
• Event Collection
• Subscription Processing
• Formatting and Delivery

Data Availability

• Disaster Recovery
• High Availability
• Backup
• Restore

Security

• Overview
• Catalog Views
• Security Functions
• Cryptographic Functions
• CLR Integration
• Native XML Web Services
• Integration Services
• Analysis Services
• Replication
• Reports
• Notifications
• Service Broker

SQL Server Integration Services (SSIS)

• What Happened To DTS?
• What is ETL?
• Integration Services Projects
• SSIS Objects
• Expressions

SQL Server Service Broker

• Overview
• Conversations
• Message Ordering and Coordination
• Transactional Asynchronous Programming
• Loosely Coupled Applications
• Components

SQL Server Replication

• Overview
• Replication Types
• Agents
• Implementing
• Administering
• Enhancements

Monitoring and Performance

• Windows Performance Monitor
• SQL Server Profiler
• Database Engine Tuning Advisor (DTA)
• Federated Database Servers
• Partitioned Tables
• Partitioned Indexes
• Query Performance Issues
• Transactions and Locks
• Best Practices for Native XML Web Services