|
Analysis Services
|
|
|
|
Auditing and Compliance
|
|
|
|
Backup and Recovery
|
|
|
|
Common Language Runtime (CLR)
|
|
|
|
Data Management
|
|
|
|
Data Transformation Services
|
|
|
|
Database Administration
|
|
|
|
Database Configurations
|
|
|
|
Database Consistency Checks (DBCCs)
|
|
|
|
Database Design
|
|
|
|
Database Mail
|
|
|
|
Database Mirroring
|
|
|
|
DBA Best Practices
|
|
|
|
DDL Trigger
|
|
|
|
Disaster Recovery
|
|
|
|
Dynamic Management Views\Functions
|
|
|
|
Dynamic SQL
|
|
|
|
Encryption
|
|
|
|
Error Handling
|
|
|
|
Fragmentation and Index Maintenance
|
|
|
|
Functions
|
|
|
|
Identities
|
|
|
|
Indexing
|
|
|
|
JOINing Tables
|
|
|
|
Locking / Blocking
|
|
|
|
Maintenance
|
|
|
|
Monitoring
|
|
|
|
Partitioning
|
|
|
|
Performance Tuning
|
|
|
|
Professional Development
|
|
|
|
Profiler / Trace
|
|
|
|
Query Optimization
|
|
|
|
Query Plans
|
|
|
|
Referential Integrity
|
|
|
|
Replication
|
|
|
|
Reporting Services
|
|
|
|
Scripts
|
|
|
|
Security
|
|
|
|
Service Packs / Patches
|
|
|
|
SQL Server 2008
|
|
|
|
SQL Server Agent
|
|
|
|
SQL Server Configurations
|
|
|
|
SQL Server Integration Services
|
|
|
|
SQL Server Management Studio
|
|
|
|
Stored Procedures
|
|
|
|
T-SQL
|
|
|
|
Testing
|
|
|
|
Tools
|
|
|
|
Upgrades
|
|
|
|
Views
|
|
|
|
XML
|
|
|