Designing an Administrative Solution for SQL Server 2008
o Overview of SQL Server 2008
o Designing an Administrative Solution
o Developing and Deploying an Administrative Solution for SQL Server 2008
o Implementing an Administrative Solution in SQL Server Management Studio (SSMS)
Deploying SQL Server 2008
o System Requirements for SQL Server 2008
o Upgrading and Migrating to SQL Server 2008
o Configuring Instances in SQL Server 2008
Designing the Physical Structure of SQL Server 2008
o Introduction to the Physical Structure of a Database
o Planning for Partitioning
o Planning for Full-Text Indexing
Designing a Strategy for Maintaining a Database in SQL Server 2008
o Designing a Strategy for Maintaining Statistics for a Database
o Designing a Strategy for Maintaining Indexes
o Designing a Strategy for Database Compression
Designing Solutions for Managing SQL Server 2008
o Designing a Policy-Based Management Strategy
o Controlling Resource Usage by using Resource Governor
o Auditing Database Changes
Automating the Database Management Strategy for SQL Server 2008
o Managing SQL Server Agent
o Automating Administrative Tasks in SQL Server
o Monitoring Events in SQL Server
Designing a Strategy for Securing SQL Server 2008
o Securing SQL Server 2008 Instances
o Planning Database Security
o Managing Certificate and Keys in SQL Server 2008
o Implementing Database Encryption
Designing a Strategy for Monitoring SQL Server 2008
o Overview of Monitoring SQL Server 2008
o Monitoring SQL Server Instances
o Monitoring SQL Server Databases
o Monitoring Multiple SQL Servers by Using Data Collection
Designing a Strategy for Content Distribution in SQL Server 2008
o Distributing Data in SQL Server 2008
o Working with Distributed Queries
o Managing Distributed Content by Using Distributed Transactions
o Managing SQL Server Integration Services (SSIS) Packages
o Setting Up Scalable Shared Databases
Designing a Strategy for Replication in SQL Server 2008
o Designing a Database Replication Strategy
o Implementing Content Distribution by using Replication
o Configuring a High-Availability Solution by Using Replication
Designing a High-Availability Solution for SQL Server 2008
o Introduction to High Availability
o Implementing Log Shipping
o Implementing Database Mirroring
o Implementing Failover Clustering
o Designing a High-Availability Strategy
Designing a Backup and Recovery Strategy for SQL Server 2008
o Planning a Backup Strategy
o Planning a Recovery strategy
o Designing a Backup and Recovery Strategy
o Implementing a Repair Strategy
