Topics

Query Optimization and Execution Plans

How SQL Server compiles, optimizes, and executes individual queries.

573 associated292 primary

• Execution Plan Interpretation 92 associated86 primary
• Cardinality Estimation and Row Estimates 60 associated57 primary
• Parameter Sensitivity and Plan Reuse 62 associated60 primary
• Execution Strategies and Runtime Behavior 93 associated89 primary

Indexing and Statistics

Designing, evaluating, maintaining, and troubleshooting indexes and statistics.

568 associated270 primary

• Index Design and Access Paths 113 associated109 primary
• Index Evaluation and Specialized Indexes 62 associated59 primary
• Statistics Management 40 associated37 primary
• Index Maintenance and Fragmentation 44 associated43 primary
• Table Partitioning 26 associated22 primary

Plan Cache, Query Store, and Query Analysis

Using query history, cached plans, and runtime data to investigate performance.

200 associated60 primary

• Plan Cache and Query History Analysis 38 associated37 primary
• Active Query Diagnosis and Runtime Profiling 25 associated23 primary

Performance Monitoring and Server Tuning

Diagnosing instance performance through waits, resources, monitoring, and baselines.

405 associated180 primary

• Wait Statistics 56 associated51 primary
• Monitoring, Baselines, and Health Signals 81 associated78 primary
• Instance Resource Pressure and Tempdb 53 associated51 primary

T-SQL and Database Development

Writing, reviewing, debugging, and maintaining T-SQL and database code.

478 associated232 primary

• T-SQL Code Quality and Query Patterns 106 associated102 primary
• Stored Procedures and Dynamic SQL 34 associated33 primary
• Error Handling and Transaction Control 19 associated18 primary
• Data Modification, Triggers, and Constraints 39 associated33 primary
• Temporary Query Objects 17 associated15 primary
• Query Exercises and Answer Keys 31 associated31 primary

Concurrency and Transaction Isolation

Locks, isolation, blocking, deadlocks, and simultaneous database work.

213 associated75 primary

• Locking, Isolation, and Read Consistency 36 associated36 primary
• Blocking and Deadlock Troubleshooting 40 associated39 primary

Backup, Restore, and Database Integrity

Backup design, restore testing, integrity checks, and corruption response.

292 associated117 primary

• Backup Strategy and Verification 68 associated67 primary
• Restore and Recovery Operations 25 associated24 primary
• CHECKDB, Corruption, and Data Integrity 29 associated26 primary

High Availability and Disaster Recovery

Replicas, failover, recovery objectives, and disaster-recovery planning.

319 associated131 primary

• Availability Groups, Clustering, and Replicas 92 associated90 primary
• Disaster Recovery Architecture and Testing 41 associated41 primary

SQL Server Administration and Maintenance

Installation, configuration, automation, health checks, and governance controls.

301 associated140 primary

• Installation and Configuration 64 associated63 primary
• Operational Health Checks 42 associated42 primary
• SQL Agent, Alerts, and Operational Automation 16 associated16 primary
• Access and Nonproduction Data Practices 22 associated19 primary

SQL Server Infrastructure, Storage, and Capacity Planning

Compute, memory, storage, virtualization, and deployment foundations.

309 associated101 primary

• Storage Architecture and I/O Testing 43 associated42 primary
• Server Sizing and Capacity Planning 41 associated41 primary
• Virtualization and Deployment Foundations 19 associated18 primary

Cloud and Managed Database Platforms

Cloud architecture, managed databases, migrations, and cloud operating tradeoffs.

131 associated50 primary

• Cloud SQL Server and Hybrid Architecture 22 associated22 primary
• Managed Database Services, Migration, and Cost 28 associated28 primary

SQL Server Versions, Editions, and Licensing

Selecting versions and editions, understanding licensing, and modernizing platforms.

99 associated37 primary

• SQL Server Editions and Licensing 22 associated22 primary
• Version Lifecycle and Modernization 15 associated15 primary

DBA Careers and Professional Practice

DBA work, career development, hiring, role expectations, and team practices.

210 associated133 primary

• DBA Roles and Operational Responsibilities 36 associated33 primary
• DBA Career Planning and Job Search 65 associated65 primary
• Hiring, Teams, and Workplace Practice 36 associated35 primary

Technical Communication, Presenting, and Writing

Presentations, teaching, blogging, writing, and public professional practice.

67 associated45 primary

• Technical Presentations and Teaching 26 associated26 primary
• Technical Blogging and Writing 20 associated19 primary