Archives
- 13 Sep SCD type 2 in dbt with window functions only
- 13 Sep One licence-plate range, three datasets: reproducible sampling for a warehouse
- 13 Sep A human-in-the-loop agent with LangGraph interrupt()
- 13 Sep Cosine similarity is not a relevance score
- 13 Sep No source, no answer: enforcing citations in code, not in the prompt
- 13 Sep Turning a full snapshot feed into a change stream (and why you still need a heartbeat)
- 13 Sep The bug that made 169,000 good events "late"
- 13 Sep The offset ledger: never commit past an open window
- 11 Sep A digital twin that only says what it can prove
- 18 Aug Every department reports a different revenue figure: why, and what to do
- 10 Aug Real-time transit delays on Kafka: a streaming pipeline that runs 24 hours unattended
- 08 Aug RAG over Dutch court rulings: every answer with a source, or no answer
- 03 Aug Dutch public holidays in SQL: a date dimension that's right even on 5 May 2016
- 03 Aug CI for a dbt project: every pull request builds the whole warehouse
- 26 Jul An open-data warehouse done properly: dbt, tests and a Kimball star schema