Data Mozart - Make music from your data

Article

FabCon Europe 2026: 4 announcements that may change how we work with data and AI

Barcelona is done. Nearly 5,000 people, 130+ sessions, and a very long list of announcements. This is my cut of the ones that matter, why they...

Data Mozart - Make music from your data 12 days ago 7

Article

The query finished…Why is my Fabric SQL database still consuming CUs?

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 ...

Data Mozart - Make music from your data 1 month ago 10

Article

Implementing SCD Type 2 in Microsoft Fabric – The Definitive Guide!

Slowly Changing Dimensions (SCD) are one of the fundamental concepts in dimensional modeling. If you are not sure what dimensional modeling is...

Data Mozart - Make music from your data 1 month ago 12

Article

How to check table sizes in a Microsoft Fabric warehouse

If you've tried to check how much storage your Fabric warehouse tables consume, you've probably discovered that the usual SQL Server approache...

Data Mozart - Make music from your data 2 months ago 23

Article

(Don’t) Stop materializing your silver layer!

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

Data Mozart - Make music from your data 2 months ago 14

Article

Liar, liar! What to do when AI writes your pipelines confidently wrong?

Should we let AI write our pipelines? YES...But not the way you probably think. The post Liar, liar! What to do when AI writes your pipelines ...

Data Mozart - Make music from your data 3 months ago 17

Article

One-minute trap! How new Fabric Warehouse CU metering affect your workloads

Microsoft is moving Fabric Warehouse CU metering from per-query CPU time to per-workspace virtual-node time. That brings Fabric closer to Snow...

Data Mozart - Make music from your data 3 months ago 22

Article

Variable libraries in Microsoft Fabric: One value to rule them all!

Hardcoded values are the cockroaches of a data platform: you think you got them all, then Test starts reading from Prod and nobody notices for...

Data Mozart - Make music from your data 4 months ago 24

Article

CLUSTER BY in Fabric Warehouse: when the magic shows up and when it doesn’t!

Microsoft's announcement post for data clustering in Fabric Warehouse promised 24x speedups. So I built a 100-million-row clickstream table an...

Data Mozart - Make music from your data 5 months ago 21

Article

Hot, Cold, Gone: Caching and Retention in Microsoft Fabric Eventhouse

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

Data Mozart - Make music from your data 5 months ago 29