Path 1
Practical reference
Keywords, operators, and functions explained.
- 41 reference topics
- 10 applied examples
- Syntax and checks
The SQL Booklet
SQL Server
SQL Server for every day
Find syntax, examples, and queries for exploring real databases and diagnosing problems.
- 126
- topics
- 41
- references
- 85
- cases and articles
SQL Server in practice
SQL Server for every day.
Syntax, examples, and queries for development, database exploration, and real-world problem solving. Each topic explains the code, shows its result, and highlights what matters when interpreting it.
SQL Server
Look up, explore, and troubleshoot.
Development and exploration
View the SQL Server catalog Search for text inside stored procedures, views, and functions
Read article →ReferenceINNER JOIN
Read article →Troubleshooting and optimizationIdentify blocking and blocked sessions
Read article →ReferenceCTE
Read article →Development and explorationFind duplicate rows by business key
Read article →Execution plansWhat an execution plan is for
Read article →The library
Paths for working with SQL Server.
The catalog groups each topic by the task at hand: looking up syntax, understanding a database, investigating a signal, or learning to read a plan.
Path 2
Development and exploration
Queries for understanding structures, relationships, dependencies, and data.
- 22 queries
- Controlled exploration
- Everyday working cases
Path 3
Troubleshooting and optimization
Queries for reviewing sessions, blocking, indexes, memory, and performance.
- 23 queries
- Operational investigation
- Reading evidence
Path 4
Execution plans
A progressive path for reading operators, properties, and signals in SQL Server.
- 30 articles
- Reading the tree and its operators
- Evidence before optimization