Two minutes of database activity can mean 17 minutes of compute billing. And a CPU chart doesn't tell the whole story. Let's work through SQL database in Fabric billing with examples from application ...

Slowly Changing Dimensions (SCD) are one of the fundamental concepts in dimensional modeling. If you are not sure what dimensional modeling is, I suggest you first check the series of articles I wrote...

Analytics Engineering with Microsoft Fabric and Power BI: The Definitive Guide for Building Enterprise-Grade Analytics Solutions [Watson, Shabnam, Ilic, Nikola] on Amazon.com. *FREE* shipping on qualifying offers. Analytics Engineering with Microsoft Fabric and Power BI: The Definitive Guide for Building Enterprise-Grade Analytics Solutions

If you've tried to check how much storage your Fabric warehouse tables consume, you've probably discovered that the usual SQL Server approaches don't work. This post explains why, what else doesn't wo...

Why is your silver layer a set of tables? Challenging the fully materialized medallion pattern - with benchmark numbers and reproducible demo scripts.

Learn in-demand skills and become a certified Fabric data engineer

A live 4-hour, code-first workshop on Fabric implementation, agentic scaffolding, metadata-driven ingestion, validation, cost, and production trust.

Should we let AI write our pipelines? YES...But not the way you probably think.

Microsoft is moving Fabric Warehouse CU metering from per-query CPU time to per-workspace virtual-node time. That brings Fabric closer to Snowflake and Databricks, but it also changes the cost equatio...

Five surfaces collapsed into one declarative layer. Here's the full story of Materialized Lake Views in Microsoft Fabric - from syntax to the new GA capabilities

Join our Microsoft Fabric - UK User Group for our latest webinar. This session we are excited to announce our host Microsoft MVP Leon Gordon and co-host Microsoft MVP Prag

Five surfaces collapsed into one declarative layer. Here's the full story of Materialized Lake Views in Microsoft Fabric - from syntax to the new GA capabilities

A true life story about the gap between available data and a trusted number.

Learn the fundamental skills to work with Microsoft Fabric

The story I wasn't ready to tell two years ago. AI changed that...

Microsoft's announcement post for data clustering in Fabric Warehouse promised 24x speedups. So I built a 100-million-row clickstream table and tested it myself. The result is more nuanced than the ma...

"Should we process our data in batches or in real-time?" It's not batch vs. stream: it's "when does the answer matter?"

Two policies, three storage states, one rule connecting them. A newcomer's guide to caching, retention, and tiered storage in Microsoft Fabric Eventhouse.

If I had a euro for every time someone asked me "should I use the Warehouse or the Lakehouse?" - I'd have enough to fund a month of exclusive vacation...

Five surfaces collapsed into one declarative layer. Here's the full story of Materialized Lake Views in Microsoft Fabric - from syntax to the new GA capabilities announced at FabCon Atlanta

A reference framework for naming everything in Microsoft Fabric - from capacities down to gold-layer fact tables. Patterns, examples, and strong opinions.

Five surfaces collapsed into one declarative layer. Here's the full story of Materialized Lake Views in Microsoft Fabric - from syntax to the new GA capabilities announced at FabCon Atlanta

The best data models make it hard to ask bad questions and easy to answer good ones.

YouTube video by Data Mozart

You’ve probably spent the last year hearing about Lakehouses and Warehouses until your ears are ringing. This article helps you understand in which scenarios you might need an eventhouse

Learn in-demand skills and become a certified Fabric data engineer

Everyone keeps asking me the same question: what now for Power BI? With Microsoft Fabric reshaping its identity and AI-generated dashboards challenging its visual layer, the answer isn't as comfortabl...

"Should we process our data in batches or in real-time?" It's not batch vs. stream: it's "when does the answer matter?"

Build, govern, and automate your data platform

Update policies are one of those features that don't get enough spotlight, but once you start using them, you'll wonder how you ever lived without them.

Get the data architecture right, and everything else becomes easier. I know it sounds simple, but in reality, little nuances in designing your data architecture may have costly implications. This…