1. Designing a SQL Server Instance and a Database Solution
Design for CPU, memory, and storage capacity requirements
Design SQL Server instances
Design physical database and object placement
Design a migration, consolidation, and upgrade strategy
2. Designing a Database Server Security Solution
Design instance authentication
Design instance-level security configurations
Design database, schema, and object security parameters
Design a security policy and an audit plan
Design an encryption strategy
3. Designing a Database Solution for High Availability
Design a failover clustering solution
Design database mirroring
Design a high-availability solution that is based on replication
Design a high-availability solution that is based on log shipping
Select high-availability technologies based on business requirements
4. Designing a Backup and Recovery Solution
Design a backup strategy
Design a recovery strategy
Design a recovery test plan
5. Designing a Monitoring Strategy
Design a monitoring solution at the operating-system level
Design a monitoring solution at the instance level
Design a solution to monitor performance and concurrency
6. Designing a Strategy to Maintain and Manage Databases
Design a maintenance strategy for database servers
Design a solution to govern resources
Design policies by using Policy-Based Management
Design a data compression strategy
Design a management automation strategy
7. Designing a Strategy for Data Distribution
Administer SQL Server Integration Services (SSIS) packages
Design a strategy to use linked servers
Design a replication strategy for data distribution
