PowerBI.tips

Tag

#SQL

5 posts

Lets Talk SQL and New Features: The Future? – Ep. 451

August 20, 2025

Lets Talk SQL and New Features: The Future? – Ep. 451

Mike and Tommy discuss the evolving role of SQL in Fabric—what's new and coming soon in the SQL analytics endpoint, connecting Fabric SQL to Desktop, and whether SQL is gaining or losing ground in the modern data stack.

Dataflows Gen 1 vs Fabric SQL for Reference Tables – Ep. 399

February 19, 2025

Dataflows Gen 1 vs Fabric SQL for Reference Tables – Ep. 399

Mike and Tommy compare two practical ways to manage small-but-critical reference tables: Power BI Dataflows Gen1 versus a Fabric SQL database. They break down tradeoffs around refresh, governance, CI/CD, and downstream consumption so you can pick the simplest option that still scales.

SQL in Fabric – Ep. 254

September 29, 2023

SQL in Fabric – Ep. 254

Ep. 254 explores what ‘SQL in Fabric’ really means—from querying Delta tables in OneLake to the practical gotchas of building lakehouse-style pipelines. You’ll hear why the storage/compute split matters, what it changes compared to Synapse-era patterns, and where Excel-first teams still hit friction.

SQL or OneLake – Ep. 236

July 28, 2023

SQL or OneLake – Ep. 236

Ep. 236 breaks down the Fabric ‘SQL vs OneLake’ decision: what’s just different interfaces over the same Delta storage, where governance and permissions still matter, and how to keep architectures understandable as the platform converges.

← All Tags