Explicit Measures Podcast 401: SQL Databases in Fabric - What, When, How?
Feb 26, 2025
The hosts dive into the world of SQL databases, sharing insights from a thought-provoking article. They discuss the evolution of data management from traditional systems to the innovative Microsoft Fabric. Listeners will love hearing about the importance of user-friendly tools and the integration of Git for source control. The conversation also touches on the frustrations faced with coding platforms, emphasizing the need for better experiences. Overall, it's a captivating exploration of how modern technology is transforming data solutions.
AI Snips
Chapters
Transcript
Episode notes
SQL Servers: A Backroom Necessity
- Tommy remembers SQL servers in warm, IT-only backrooms.
- Companies relied on these servers, even before Power BI.
Fabric SQL: Software as a Service
- Fabric SQL databases mark a shift to software as a service.
- This simplifies management, removing hardware concerns.
Open Storage in Fabric SQL
- Fabric SQL databases use Parquet or Delta tables for storage.
- This open standard facilitates data exchange with the lakehouse.