SQL Server
- Category
- Databases and data
- Docs outline
- 13 sections
Official docs outline
learn.microsoft.com- What is SQL Server
SQL Server editions and components.
- Query Processing Architecture
Optimizer, execution plans and parallelism.
- Indexes
Clustered, nonclustered, columnstore and design guidance.
- Transactions, Locking and Row Versioning
Isolation levels, locks and snapshot isolation.
- Transact-SQL
T-SQL language reference.
- Query Store
Capturing query history and plan regressions.
- Intelligent Query Processing
Adaptive query processing features.
- Partitioned Tables and Indexes
Partition functions and schemes.
- In-Memory OLTP
Memory-optimized tables and natively compiled procedures.
- Temporal Tables
System-versioned tables.
- Security
Authentication, permissions, encryption and auditing.
- Backup and Restore
Recovery models and backup types.
- Availability Groups
High availability and disaster recovery.
Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.
