275 episodes

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. We’ll see YOU on the SQL Trail.

SQL Data Partners Podcast Carlos L Chacon

    • Technology
    • 4.7 • 26 Ratings

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. We’ll see YOU on the SQL Trail.

    Episode 275: Machine Learning and Power BI

    Episode 275: Machine Learning and Power BI

    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 results the client could rely on. We touch on Azure ML environment and future integrations that will come with Power BI and ML. 
    Have you done any work in ML or predictive modeling? Did you get any good take-aways from today's podcast? Leave us some love ❤️ on LinkedIn, Twitter/X, Facebook, or Instagram. 
    The show notes for today's episode can be found at Episode 275: Machine Learning and Power BI. Have fun on the SQL Trail!

    • 44 min
    Episode 274: A CMM Case Study

    Episode 274: A CMM Case Study

    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 their own visibility in an organization.
    Let us know what you think! What do you think of CMM? Did you get any good take-aways from today's podcast? Leave us some love ❤️ on LinkedIn, Twitter/X, Facebook, or Instagram. 
    The show notes for today's episode can be found at Episode 274: A CMM Case Study. Have fun on the SQL Trail!

    • 51 min
    Episode 273: The Capability Maturity Model for Data Professionals

    Episode 273: The Capability Maturity Model for Data Professionals

    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 doing what you love.
    Let us know what you think! What CMM level are you in presently? Did you get any good take-aways from today's podcast? Leave us some love ❤️ on LinkedIn, Twitter/X, Facebook, or Instagram. 
    The show notes for today's episode can be found at Episode 273: The Capability Maturity Model for Data Professionals. Have fun on the SQL Trail!
     

    • 55 min
    Episode 272: Performance Tuning Scripts

    Episode 272: Performance Tuning Scripts

    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
    Have you used Erik’s scripts before? Let us know!
    The show notes for today's episode can be found at Episode 272: Performance Tuning Scripts. Have fun on the SQL Trail!

    • 50 min
    Episode 271: Pass Summit 2023 Wrap-Up

    Episode 271: Pass Summit 2023 Wrap-Up

    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 focus and Fabric is included in that space; however, I was surprised at the number of Postgres sessions. In fact, PostGres got a whopping 30 minutes out the 90-minute Microsoft keynote.
    AI continued to be peppered in the conversation and Kevin gives us his take on where some of this is going. As a side reference, if you are interested in learning more about large language models, check out this video by Andrej Karpathy.
    The show notes for today's episode can be found at Episode 271: PASS Summit 2023 Wrap-Up. Have fun on the SQL Trail!

    • 38 min
    Episode 270: Medallion Architecture

    Episode 270: Medallion Architecture

    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 different take? Let us know!
    The show notes for today's episode can be found at Episode 270: Medallion Architecture. Have fun on the SQL Trail!

    • 39 min

Customer Reviews

4.7 out of 5
26 Ratings

26 Ratings

Mike Saff ,

So good!

Very informative and funny - makes for great teaching! Thanks guys

Cbgb01 ,

Great

I am downloading all episodes

uyadava ,

Very helpful

Thank you Carlos & team. I subscribed and started listening podcast few months back; listen to new and old ones. Podcasts have helped me better understand many topics e.g. index, isolation, statistics, locking-blocking and many new features like - always encrypted, power bi, azure database etc.

Thank you !!
Umesh

Top Podcasts In Technology

Lex Fridman Podcast
Lex Fridman
All-In with Chamath, Jason, Sacks & Friedberg
All-In Podcast, LLC
Acquired
Ben Gilbert and David Rosenthal
TED Radio Hour
NPR
Dwarkesh Podcast
Dwarkesh Patel
Hard Fork
The New York Times

You Might Also Like

SQL Server Radio
Guy Glantser, Eitan Blumin
Dear SQL DBA
Kendra Little
Talk Python To Me
Michael Kennedy (@mkennedy)
Planet Money
NPR
All-In with Chamath, Jason, Sacks & Friedberg
All-In Podcast, LLC
SQL Down Under
Dr Greg Low