Installing and Configuring SQL Server
- Install and configure SQL Server instances and related services.
- Configure SQL Server instances and services.
- Configure additional SQL Server components.
- Implement database mail.
Maintaining SQL Server Instances
- Manage SQL Server Agent jobs, alerts and operators
- Implement the declarative management frame
- Manage logins and server roles.
- Manage users and database roles.
- Manage SQL Server instance permissions.
- Manage database permissions.
- Manage schema permissions and object permissions.
- Audit SQL Server instances.
- Manage transparent data encryption.
Maintaining a SQL Server Database
- Back up databases.
- Restore databases.
- Manage and configure files, file groups, and related options; database options; recovery model; attach/detach data
- Manage database snapshots.
- Maintain database integrity.
Performing Data Management Tasks
- Import and export data.
- Manage data partitions.
- Implement data compression.
- Maintain indexes.
Monitoring and Troubleshooting SQL Server
- Identify SQL Server service problems.
- Identify concurrency problems.
- Identify SQL Agent job execution problems.
- Locate error information.
Optimizing SQL Server Performance
- Implement Resource Governor.
- Use the Database Engine Tuning Advisor.
- Collect trace data by using SQL Server Profiler.
- Collect performance data by using Dynamic Management Views (DMVs).
- Collect performance data by using System Monitor.
- Use Performance Studio.
Implementing High Availability
- Implement and configure database mirroring and failover
- Implement a SQL Server clustered instance.
- Implement log shipping.Implement replication.
