8 pages
Patterns
Higher-level engineering approaches and architectural patterns. Sync pipelines, audit logging, validation flows, processing stages.
-
Changing Large Volumes of Production Data Without an Outage
Planning backfills and clean-ups that touch millions of rows while the system stays live.
-
Designing a Reversible Data Fix in SQL Server
A repeatable approach for production-safe updates with verification and rollback.
-
Designing Audit Trails That Help Investigation
What to record about data changes, and how to store it so you can answer what happened when something goes wrong.
-
Designing Integration Jobs That Are Safe to Rerun
How to make jobs produce the same result whether they run once, twice, or restart halfway through.
-
Designing Integration Pipelines That Fail Safely
A practical approach to building integration pipelines that prevent bad data from reaching downstream systems.
-
Retry, Back Off, Give Up: Handling Unreliable External APIs
A system-level policy for which failures to retry, how long to keep trying, and what happens when retries run out.
-
Stopping Duplicates at the Source Instead of Cleaning Them Up
Where duplicate records come from, and how to design imports, constraints, and matching so they cannot be created.
-
Why Status Tables Fail Operations Teams
Why simple status fields rarely communicate system state clearly, and how staged models improve operational clarity.