Notes

Technical notes

Working notes from production engineering: reverse-engineering legacy systems, designing safe integrations, and improving data-platform reliability. Each draft states its scope clearly while the full article is in progress.

Dry runs, scoped reconciliation, orphan policies, delete guardrails, and idempotent writes — the parts of a sync job that matter when the source misbehaves.

CHAR padding, packed CYYMMDD dates, multiple libraries, ODBC, and the service-account problem that breaks scheduled jobs.