SQL Data Partners Podcast

SQL Data Partners Podcast

Carlos L Chacon
Country USA
Language EN
Episodes 287
Latest 25.09.2025

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss.

Episodes

  • Thanks for the memories
    Thanks for the memories 25.09.2025 4m
    Companeros, all good things must come to an end. While the details of what is next is uncertain, my time with the podcast is coming to an end. A quick thank you and a glimpse of what is next.
  • Episode 286: Data Governance and Security In Microsoft Fabric
    Episode 286: Data Governance and Security In Microsoft Fabric 28.07.2025 33m
    In this episode of the SQL Data Partners Podcast, host Carlos L. Chacón is joined by Kevin Feasel and Eugene Meidinger for a deep dive into data governance and security within Microsoft Fabric. As part of Season 8's focus on Fabric, the trio explores how governance tools and practices are evolving with Microsoft's platform, including the use of domains, Purview integration, and the challenges that arise from pricing and tool fragmentation. With their usual banter and insights, the hosts lay out foundational concepts around organizational data governance and highlight some key components Fabric...
  • Episode 285: Who Is Using Microsoft Fabric
    Episode 285: Who Is Using Microsoft Fabric 29.05.2025 34m
    Fabric personas were originally designed to break down the various functional roles within Microsoft Fabric—such as Power BI, Data Factory, Data Activator, Data Engineering, Data Science, Data Warehouse, and Real-time Analytics—into more manageable, bite-sized sections. The goal was to prevent users from feeling overwhelmed by the platform's breadth. However, this feature has since been discontinued, as it did not effectively communicate the seamless integration between these roles. Still, the underlying concepts can be useful when thinking about how you might approach Fabric from a functional...
  • Episode 284: The Four-Letter Word ETL - Data Movement
    Episode 284: The Four-Letter Word ETL - Data Movement 04.02.2025 58m
    Once you have your data stored in OneLake, you'll be ready to start transforming it to improve it's usability, accuracy, and efficiency. In this episode of the podcast, Belinda Allen takes us on a delightful journey through Data Flows, Power Query, Azure Data Factory (Pipelines), and discusses the merits of shortcuts. We also learn about a handy way to manually upload a table if you have some static data you need to update. There are many tools and techniques that can be used for data ingestion and transformations. And while some of these options we discuss will be up to individual preference,...
  • Episode 283: Data Lakehouse vs Data Warehouse vs My House
    Episode 283: Data Lakehouse vs Data Warehouse vs My House 02.01.2025 48m
    Microsoft Fabric offers two enterprise-scale, open-standard format workloads for data storage: Warehouse and Lakehouse. Which service should you choose? In this episode, we dive into the technical components of OneLake, along with some of the decisions you'll be asked to make as you start to build out your data infrastructure. These are two good articles we mention in the podcast that could help inform your decision on the services to implement in your OneLake. Microsoft Fabric Decision Guide: Choose between Warehouse and Lakehouse - Microsoft Fabric | Microsoft Learn Lakehouse vs Data Warehou...
  • Episode 282: OneLake - A Deep Dive
    Episode 282: OneLake - A Deep Dive 26.11.2024 34m
    In Episode 281, we introduced Microsoft OneLake with a high-level overview. Now we're going deeper with a discussion on the Parquet format, why Microsoft went with the Delta Lake variation, and what Delta Lake format brings to the table (no pun intended). We'll also examine some "behind the scenes" aspects of file management, and why you'll still be using the GUI to create most of your objects. Onelake is Microsoft's solution to the demand for centralizing all data in one location, eliminating the need to transfer it across multiple systems. We expect this to play out further however, when we...
  • Episode 281: OneLake - The OneDrive for Data
    Episode 281: OneLake - The OneDrive for Data 22.10.2024 31m
    As you start using Fabric, having a central location for your data is crucial. OneLake acts as this unified destination, offering a single, consolidated repository for all your data. In this podcast episode, we explore the core features of OneLake and its benefits with our guest, Mariano Kovo, and discuss how it efficiently handles large amounts of data from diverse sources. We'll also dive into the importance of how your data is presented to Azure services, focusing on the Delta Parquet format. Did you know you can explore OneLake data directly through Windows Explorer? Microsoft aims to make...
  • Episode 280: A Focus on Microsoft Fabric
    Episode 280: A Focus on Microsoft Fabric 08.10.2024 18m
    At the Microsoft Build Conference in May 2023, Microsoft announced the new Fabric, where you could slice and dice all your data harmoniously within the environment. A few months later, Kevin, Eugene, and I discussed this evolution of the Azure Data platform in episode 267, and our thoughts on the vision for it's future, our expectations, and predictions. Now, more than a year later, we decided it's a good time to take an in-depth look at the platform to see what goals have come to fruition, what predictions have come true, and what may have changed. In this introduction to Season 8, we'll get...
  • Episode 279: SQL Server Migrations Demystified
    Episode 279: SQL Server Migrations Demystified 20.09.2024 1h 3m
    If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we know there are risks and many things that can go wrong, the "new" Microsoft continues to put time and effort towards making successful SQL Server migrations attainable for everyone. In this episode of the podcast, we chat with Tejas Shah and Sudhir R...
  • Episode 278: Running SQL Server on Azure VMs
    Episode 278: Running SQL Server on Azure VMs 30.07.2024 1h 4m
    Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Server services now offered in Microsoft Azure, it can be difficult to know how you want to run your environment. Sometimes, the old ways are the best ways for an organization, and running SQL Server on a VM in Azure is the right fit. In this episode of the SQL Data Partners Podcast, we chat with Anders Pedersen about his experience moving their systems to Azure VMs. We discuss some of the tiering iss...
  • Episode 277: PostgreSQL for the SQL Server Crowd
    Episode 277: PostgreSQL for the SQL Server Crowd 15.07.2024 1h 2m
    Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into PostgreSQL, one of the most popular open source databases in the world. Ryan came from a career background in SQL Server, but after experiencing his accidental "jump-into-the-deep-end" PostgreSQL moment, he hasn't looked back. Naturally, open source presents DBAs and their organizations with many desirable features, but there are certain drawbacks as well. Ryan shares how he navigated his transition into...
  • Episode 276: Dynamic SQL and Testing in Isolation
    Episode 276: Dynamic SQL and Testing in Isolation 21.05.2024 41m
    Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQL can open the door to many undesirable results - SQL Injection attacks being the most frightening of these. It can also be difficult to read, making maintenance problematic; however, in this episode one brave soul - Marathon's own Laura Moss - explains how she uses Dynamic SQL to help refresh a subset of production data to be used in their development environments. You know we are always suckers...
  • Episode 275: Machine Learning and Power BI
    Episode 275: Machine Learning and Power BI 16.04.2024 44m
    What kinds of problems are organizations solving with Machine Learning? In this episode, we explore a situation where a public works department was looking for more accurate information to predict future water levels based on rainfall to maintain water tank storage for balancing pressure and to prevent overflow flooding. Marathon data solutions consultants Brian Knox and Andy Yao, built a custom machine learning model and made the results available through Power BI reporting. We talk through some of the data hurdles the project presented, the tools they used, and how their work provided result...
  • Episode 274: A CMM Case Study
    Episode 274: A CMM Case Study 22.02.2024 51m
    After discussing the Capabilities Maturity Model in our last episode, it was fate when Andy Levy reached out and suggested a topic which sounds like a case study about his experience with CMM. As the only data professional in his organization at the time of his hiring, Andy went from fixing problems to slowing increasing his role in the organization and participating in the planning meetings—being in the room where decisions are made and change happens. We think this episode will be an interesting perspective for those who might be on the fence about the model, and looking for ways to increase...
  • Episode 273: The Capability Maturity Model for Data Professionals
    Episode 273: The Capability Maturity Model for Data Professionals 02.02.2024 55m
    Have you ever felt stuck in a rut, repeating the same tasks, while knowing there is room for improvement? The Capability Maturity Model may be a way for you to start contributing to those improvements. In this podcast episode, Kevin Kline from SolarWinds walks us through how we might go from simply dealing with issues as they come, to being a contributor in decisions about the future of our organization. Listen in and learn about the levels of CMM, how they relate to those of us in data professions, and how you can apply the methodologies to become a leader who drives positive change, while do...
  • Episode 272: Performance Tuning Scripts
    Episode 272: Performance Tuning Scripts 10.01.2024 50m
    Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce wonderful folks like Erik Darling who contribute their knowledge to make your life a bit easier. In this episode of the SQL Data Partners podcast, we sit down with Erik and discuss the scripts he built to gather performance metrics. While every potential issue is not captured in these scripts, they'll help you start gathering information so you can decide on the next step to take. Get the scripts...
  • Episode 271: Pass Summit 2023 Wrap-Up
    Episode 271: Pass Summit 2023 Wrap-Up 29.12.2023 38m
    This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no remote option this year was fine for us, as it was great to reconnect with our friends and colleagues in the data community, as well as get updates live and in-person from Microsoft on all the new features rolling out. The focus of both conferences was eerily similar and in this episode we discuss our experiences along with a picture of what 2024 will look like. Azure services continue to be a focu...
  • Episode 270: Medallion Architecture
    Episode 270: Medallion Architecture 21.11.2023 39m
    Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win over Milorad Cavic has there been so much controversy around bronze, silver, and gold. This episode of the podcast has a genesis with Databricks and the methodology of getting data into a workable form for all the reporting pieces businesses love so much. We discuss our thoughts on the various layers of a medallion architecture and the implementation in Azure delta lake environments. Have a diffe...
  • Episode 269: Why Do I Need a Managed Service Provider?
    Episode 269: Why Do I Need a Managed Service Provider? 19.10.2023 16m
    In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons. The term manage services refers to the practice of outsourcing business administration or management responsibilities to the third party. Why would you ever want to outsource these pieces? Listen in to learn more and see if hiring an MSP would be a good decision for your company. The show notes for today's episode can be found at Episode 269: Why Do I Need a Managed Service Provider? Have fun on the SQL Trail!
  • Episode 268: AI and the Future of the Database
    Episode 268: AI and the Future of the Database 28.09.2023 53m
    We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been including Artificial Intelligence or AI in more and more of its marketing material. In this episode we'll dive into the definition of AI, what features are currently available, how we can leverage those technologies, and where we think this might go in the future. One of the challenges we currently face is all the buzz and excitement around AI. From a data platform vantage point, we started with a...

Popular in

The podcast also appears in the podcast charts of these countries.