SQL Data Partners Podcast

07/28/2025

🔐 How secure is your data in Microsoft Fabric? In this episode, we dive into evolving governance tools, domains, Purview integration, pricing issues & real-world gaps.

We're talking about evolving tools, domain use, Purview, built-in features, pricing gaps, and real-world vs. marketing challenges.

02/04/2025

There are many tools and techniques that can be used for data ingestion and transformations. Belinda Allen takes us on a delightful journey through Data Flows, Power Query, Azure Data Factory (Pipelines), and discusses the merits of shortcuts.

Working on data storage and transformation in OneLake? We talk with Belinda Allen about Data Flows, Power Query, ADF Pipelines and the merits of shortcuts.

01/02/2025

Trying to decide between Data Lakehouse and Data Warehouse? In this episode we dive into the technical components and nuances between these two services and some of the decisions you'll have to make as you build out your data infrastructure.

Trying to decide on which service to choose? In this podcast episode we dive into the technical components and nuances between the Lakehouse and the Warehouse.

11/26/2024

Dive deep into OneLake as we explore Delta Lake Parquet, scenarios when "one" OneLake might not do the trick, and get some perspective on Direct Lake Mode for Power BI.

We’re discussing the Delta Lake format in OneLake, when multiple OneLake instances may be needed, and the pros and cons of Direct Lake Mode for Power BI data imports.

10/22/2024

OneLake to rule them all? In this episode, we explore OneLake as Fabric's central data hub with guest Mariano Kovo. We cover its key features, efficient data handling, and Azure integration using the Delta Parquet format, plus how Windows Explorer and shortcuts enhance data access.

We discuss OneLake as Fabric's central data hub, its Azure integration with Delta Parquet, and how Windows Explorer and shortcuts simplify seamless data access.

10/04/2024

Happy Friday Compañeros! Season 8 of the podcast begins next week 🎉 We hope you'll join us for an entertaining and educational dive into the world of Microsoft Fabric.

09/20/2024

SQL Server migrations can be daunting. We talk with Tejas Shah and Sudhir Raparla, to get their practical perspectives on approaching your SQL Server migration with confidence, and the tools and features available to make your next migration process a success.

Take a practical approach to your next SQL Server migration and learn about the newest tools and features available to help with a successful migration.

07/30/2024

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right fit? Find out in this insightful episode, as Anders Pedersen talks about moving his SQL Server environment to Azure VMs, navigating the tiers and newest storage options, and how he manages upgrades.

Can you run SQL Server on Azure VM? Yes! We talk with Anders Pedersen about moving a SQL Server environment to Azure VMs, tiers, storage options, & upgrades.

07/15/2024

If you are a SQL Server DBA considering a switch to PostgreSQL, this podcast is for you. We talk with Ryan Booz, PostgreSQL Advocate at Redgate, about his experience making this transition, the terminology, tools, and tricks, as well as the community, and key aspects to consider if you are going to take a dive into the world's most popular open source database.

Switching from SQL Server to PostgreSQL? We talk with PostgreSQL Advocate Ryan Booz about the tools and tricks, the community, and key aspects to consider.

05/22/2024

Just getting started with Power BI? Join us tomorrow as Marathon's senior data solutions consultant Brian Knox presents a curated collection of practical tips and tricks designed to enhance your proficiency in Power BI and elevate your data storytelling capabilities.

https://www.meetup.com/rvapowerbiug/events/300922381/

05/21/2024

Dynamic SQL generally has a bad reputation due to it's propensity for errors and security risks such as SQL injection attacks. There are times however, when it can be used for good and that is what we are going to explore in this episode with our guest, Laura Moss.

Refreshing a subset of production data using Dynamic SQL. This use case outlines how the flexibility of this developers tool can be beneficial.

04/16/2024

What kinds of problems are organizations solving with Machine Learning? In this episode, we discuss the process of building a machine learning model designed to provide accurate rainfall data predictions for a public works department with two of Marathons data solution consultants.

We discuss the process of building a machine learning model designed to provide accurate rainfall data predictions for a public works department.