Jugal Sheth  ·  The Data Factory

Blog

Practical lessons from production data systems — what breaks, why it breaks, and how to check your own.


Production lessons

One Approval, Two Writes

Nov 9, 2026  ·  6 min read

An approver clicked approve once. The system triggered the write function twice. A 90-day audit found about one in four approved requisitions triggered the ERP write twice — because a deduplication ID built from the current time deduplicates nothing, and the worker had no gate before the write.

Read the article →

Production lessons

The Approval Queue Was Lying

Nov 9, 2026  ·  6 min read

Every job was green. Every pipeline run succeeded. And about 15% of the purchase orders waiting for approval were invisible to the people supposed to approve them — because an INNER JOIN on a cross-system ID silently drops the rows that don't match.

Read the article →

The idea

Green Jobs Lie

Nov 17, 2026

A job can succeed while the data is wrong. Every dashboard green, every check passed — and the numbers still wrong. What the phrase means, and the four failures that prove it.

Read the idea →

More lessons from production systems are on the way — one principle, one real failure, one checklist at a time.