Roadmap

Below is the planned expansion to make this a professional-grade reference. Links are placeholders so you can add pages later.

Core Querying

• DISTINCT & Deduping
• Subqueries (scalar/table)
• EXISTS vs IN
• CTEs (basic & recursive)
• Set Operators
• CROSS JOIN & Self Join

Joins & APPLY

• Join Strategies
• Anti-join Patterns

Aggregation & Windowing

• HAVING vs WHERE
• Window Basics
• Window Aggregates
• Window Frames
• Grouping Sets

Data Modification

• INSERT Patterns
• UPDATE with JOIN & OUTPUT
• DELETE Patterns
• MERGE (safe upserts)
• Identity & Sequences

Programmability

• Variables & Expressions
• Stored Procedures
• Functions: Scalar vs TVF
• TVPs (Table-Valued Params)
• TRY…CATCH & XACT_STATE()

Transactions & Concurrency

• Transactions & Savepoints
• Isolation Levels
• Deadlock Basics
• Locking Hints

Performance & Indexing

• Sargability Deep Dive
• Index Basics
• Covering & Filtered Indexes
• Statistics & Sniffing
• Execution Plans 101
• Temp vs Table Variables

Strings, Dates, Types

• STRING_SPLIT & STRING_AGG
• Collations & Case
• Date/Time Essentials
• Sargable Date Ranges
• Conversions & Precision

JSON & XML

• JSON Read
• JSON Write
• XML Basics

Modern SQL Server

• Temporal Tables
• Columnstore Basics
• In-Memory OLTP

Admin & Metadata

• Schema & Schemabinding
• Security Basics
• Useful DMVs
• System Catalogs