SQL Database in Fabric — When OLTP Meets Your CU Budget episode artwork

EPISODE · Mar 13, 2026 · 9 MIN

SQL Database in Fabric — When OLTP Meets Your CU Budget

from Fabric Architecture Podcast · host Matthias Falland

SQL Database in Fabric — When OLTP Meets Your CU Budget Episode 11 • 2026-03-13 Duration: 9:50 SQL Database in Fabric promises zero-ETL translytical architecture — OLTP writes mirrored to OneLake automatically. But the 15-minute billing window and interactive CU consumption change the math. We break down when it makes sense and when Azure SQL Database plus mirroring is the smarter play. What we discuss A real-world mistake from a pre-Fabric era The one question that reframes the architectural debate How we got here — predecessor products and evolution Why the "obvious" answer is often wrong A real Reddit/Microsoft Q&A question unpacked The concrete recommended architecture F-SKU realism — what this actually costs When the rejected approach is actually right Risks of the recommended path What Microsoft is shipping that changes the calculus The architectural principle to take home Key takeaways That's... a genuinely good architecture. For a lot of teams, that's the right call. You lose zero-config mirroring — you set it up manually — and you lose Git integration and the GraphQL API. But you gain VNet support, CDC, Always... Every. Single. Time. Plus the engine startup needs a two-gig minimum memory allocation. On an F2 capacity, that's... roughly your entire capacity eaten by one database. Technically — yes, that works. But the failure mode I asked about? It's cost. When you create a SQL Database in Fabric, two items appear — the database and a SQL analytics endpoint. Both consume interactive CUs. Not background —... Resources SQL database in Microsoft Fabric — Overview Mirroring Fabric SQL database Translytical applications with SQL database SQL database in Fabric tutorial — End-to-end architecture Data Factory SQL database connector GraphQL API for SQL database Mirroring limitations SQL analytics endpoint Automatic Tuning AI functions Fabric's CI/CD framework Limitations in SQL database in Fabric Feature comparison: Azure SQL Database and Fabric SQL database Billing and utilization reporting for SQL database Mirroring Azure SQL Database to Fabric About the show Built on ElevenLabs voice synthesis. Matthias — cloned voice. Fabia — designed AI co-host. See Matthias live on YouTube (Fabric Friday), at his meetups, and at conferences like FabCon. Hosted by Matthias Falland — Microsoft Data Platform MVP and community architect behind the Fabric Periodic Table. New episodes every Friday. Submit your case Have an architecture decision you are wrestling with? DM Matthias on LinkedIn — find him as Matthias Falland. Three to five sentences about the decision, your team size, and your current stack. We anonymize before airing. Built on ElevenLabs voice synthesis. Brand design based on fabricperiodictable.com.

Episode metadata supplied by the publisher feed · Published Mar 13, 2026

Embed this episode

SQL Database in Fabric promises zero-ETL translytical architecture — OLTP writes mirrored to OneLake automatically. But the 15-minute billing window and interactive CU consumption change the math. We break down when it makes sense and when Azure SQL Database plus mirroring is the smarter play.

Distinct summary based on available episode metadata or transcript content.

NOW PLAYING

SQL Database in Fabric — When OLTP Meets Your CU Budget

0:00 9:51

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

No similar episodes found.

No similar podcasts found.

Frequently Asked Questions

How long is this episode of Fabric Architecture Podcast?

This episode is 9 minutes long.

When was this Fabric Architecture Podcast episode published?

This episode was published on March 13, 2026.

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this Fabric Architecture Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.
URL copied to clipboard!