Every article

Newest first, grouped by year. Search or filter by topic.

388 articles
·
2 matching

Filter by topic All .NET AI Engineering Architecture Azure & DevOps Data Warehousing Engineering Practice Microservices Web APIs triggers × View Cards List

Data Warehousing 24 Dec 2025

The Update That Recalculated Nothing

The most satisfying demonstration of KC Star V8 is an UPDATE that does no work. Change PaymentMethod, a dimension nothing depends on, and the selective trigger recalculates zero measures. Here is the trigger that pulls it off - and a tautological bug sitting right beside it.

Data Warehousing 18 Nov 2025

Two Triggers Run the Whole Warehouse

KC Star V1 has no ETL job and no application code. Two PostgreSQL triggers explode sales into dimension rows and version them on change - and the gaps between what they do and what I claimed they do are the most instructive part of V1.