Legacy Schemas Are Sediment, Not Design
Section
44 pages
Posts
Non-SARGable Predicates: How a Function in WHERE Kills Your Index
The Bare `id` Primary Key: When Every Table Joins to Every Other Table
Polymorphic References Are Not Foreign Keys
ORMs Are a Coupling, Not an Abstraction
Schema Conventions Don't Survive Without Automation
Where Business Logic Lives - Database vs. Application
Database Deadlocks, Part 2: Diagnosis, Retries, and Prevention
Database Deadlocks, Part 1: The Patterns
NULL in SQL: Three-Valued Logic and the Silent Bug Factory
