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