Field notes

Short guides we share with clients during engagements—published here for your team’s lunch-and-learn stash.

When partial indexes never fire

Predicate mismatch and statistics quirks that keep PostgreSQL scanning full tables.

How SaveChanges batching hides row-by-row updates until you trace SQL.

Volume, collation, and missing replicas that make staging plans lie.