Collections

Hidden Architecture

The parts of a system you never think about until one of them breaks. B-trees, write-ahead logs, change data capture, columnar formats, query planners, and what gets built on top of them.

• Exploring Graph Relationships with SQL Server

  22 October 2021 · 7 min

  SQL schemas often contain graph-like structures, and with the right queries you can ask a whole new set of questions of them. One approach to walking those tables the way you'd walk a graph.

• Code Walkthroughs

  5 September 2021 · 1 min

  A few source-code walkthroughs on the way. Reading real systems line by line, the way you would with a colleague over a shared screen.