SQL Server
Indexes, partitions, query plans, and the day-to-day reality of running T-SQL at scale.
-
Reading an execution plan without crying
How SQL Server decides to run your query, how to read the plan it shows you, and the three operators that explain 90% of slow queries.
-
Clustered and non-clustered indexes, the way I wish someone had explained them
Why every table wants a clustered index, how to pick the column, what fragmentation actually costs, and the hidden write-amplification of getting it wrong.
-
How partitioning actually works in SQL Server
A walkthrough of partition functions, partition schemes, the sliding-window pattern, and the gotchas nobody warns you about until your overnight job is on fire.