SQL Server DBA
- Blockings and Deadlocks
- Partitioning Techniques
- DB Snapshots and usage
- Backup Strategies
- Restore Techniques
- Replication Techniques including RMO
- Securing Replication
- Log Shipping with Security
- DB Mirroring and Troubleshooting
- Security Enforcement Performance Tuning
- Import and Export using SSIS
- Cloning Databases and Objects
Advanced Administration
- Certificates and Signatures
- Query Troubleshooting
- SQL Server Profiler
- DB Engine Tuning Advisor
- Data Movement Procedures
- SMO and BCP
- Maintenance Plans
- Database Mail
- Clustering Configuration and Procedures