Tag Archives: sql server

Operational Edge Projection + CDC Write-Back: A Minimal Pattern for Low-Latency Authority Without Breaking Temporal Truth

This article introduces a practical operational extension to the UK FS SCD2 Bronze/Silver architecture. Rather than forcing operational applications to interact directly with the lakehouse, governed Silver current-state views are projected into a low-latency SQL database for operational consumption. Business decisions are made and stored locally, captured through SQL Change Data Capture (CDC), landed append-only into Bronze, and subsequently reconciled into governed Silver. The pattern preserves temporal correctness, auditability, replayability, and regulatory defensibility while providing the transactional performance and simplicity required by operational systems. It separates operational authority from institutional memory, allowing each layer to optimise for its intended purpose without compromising governance.

Continue reading

Data Is a Symptom of Function: Migrating RDBMS Estates Is Not Transformation

Migrating legacy RDBMS estates to the cloud is often framed as a transformation, but relocating data rarely modernises systems. Data is a symptom of underlying business function, encoded behaviour, and dense integration. Without upstream redesign (defining capabilities, decomposing behaviour, clarifying boundaries, and extracting embedded logic) cloud migration preserves complexity, creating “re-legacy” at scale rather than true modernisation.

Continue reading