Every article

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

556 articles
·
2 matching

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

21 Aug 2025

Data Warehousing 21 Aug 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 · 4 min

28 Jul 2025

Data Warehousing 28 Jul 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.

Data Warehousing · 4 min