Design Database Structure
Design for business requirements.
Design physical database and object placement.
Design a table and index partitioning strategy.
Design a migration, consolidation, and upgrade strategy.
Design SQL Server instances.
Design backup and recovery.
Design Databases and Database Objects
Design a database model.
Design tables.
Design for concurrency.
Design T-SQL stored procedures.
Design a management automation strategy.
Design for implicit and explicit transactions.
Design Database Security
Design an application strategy to support security.
Design database, schema, and object security parameters.
Design instance-level security configurations.
Design a Troubleshooting and Optimization Solution
Design a maintenance strategy for database servers.
Troubleshoot and resolve concurrency issues.
Design and implement a high availability solution.
Design a solution to monitor performance and concurrency.
Design a monitoring solution at the instance level.
