254 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 sqldatapartners.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 sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.

    Code Smell Checks with sp_Develop

    Code Smell Checks with sp_Develop

    Would you be interested in a tool to help you do code review checks and provide developers guidance on best practices? In this episode of the SQL Data Partners Podcast, we talk with Kevin Martin, the creator of sp_Develop, about how his procedure can help you review naming conventions, table conventions, data type conventions, SQL code conventions, data issues, and even configuration issues. Kevin was approached about writing a best practice document but ended up writing a stored procedure you and I can use to help our environment. We love sharing what community members have done and hope you enjoy this conversation with Kevin on the tool. He is looking for folks to help him build out items, so if you have a suggestion, be sure to include it in GitHub.
    The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/09/21/episode-254-code-smell-checks-with-sp_develop/. Have fun on the SQL Trail!

    • 29 min
    Go Mobile with Power Apps

    Go Mobile with Power Apps

    In this episode, we dive into the Power Apps offering and discuss the pros and cons of using this latest Microsoft offering. Some definitions are given and hopefully this episode can orient folks on how to position Power Apps in their organizations.
    The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/09/07/episode-253-go-mobile-with-power-apps. Have fun on the SQL Trail!

    • 35 min
    The Cumulative Update Dilemma

    The Cumulative Update Dilemma

    Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don’t suggest a zero-day install for most folks, setting up a regular cadence to check is a reasonable ask if you have to manage a system. In this episode of the SQL Data Partners Podcast, we discuss the need for patching and how you might go about it. Special shoutout to Episode 112 with the late Robert Davis on the same subject. We would also like to thank the fine folks at dbatools.io for some nifty PowerShell to help us install patches and Brent Ozar for keeping up sqlserverupdates.com. If you have some additional ideas on how to best meet your patching needs, let us know via social media!
    The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/08/24/episode-252-the-cumulative-update-dilemma. Have fun on the SQL Trail!

    • 29 min
    Azure Cognitive Services

    Azure Cognitive Services

    How can you begin to integrate AI models into your environment without spending months building everything out? As we continue our march to Episode 256, we bring back our friend Sam Nasr to talk about Azure Cognitive Services. Sam walks us through a few examples of how he was able to leverage some pre-packaged voice recognition services to assist customers get to the proper area for service. We discuss scenarios where Azure Cognitive Services really shines and where you may have to develop more custom solutions or look for extensions. If you are using Azure Cognitive Services, let us know your experience!
    The show notes and video for this episode can be found at https://sqldatapartners.com/2022/08/10/episode-251-azure-cognitive-services. Have fun on the SQL Trail!

    • 41 min
    What happens before... “COMPANEROS!”

    What happens before... “COMPANEROS!”

    This episode we are doing a bit of a look back and are going to air some previously buried content.  Some of the bloopers are pre-video and some of them have some physical comedy, which you’ll have to go to YouTube to see. While a few were cut out of the published episodes, they are mostly things you’ve never heard.
    The show notes and video for this episode can be found at https://sqldatapartners.com/2022/07/27/episode-250-what-happens-before-companeros/. Have fun on the SQL Trail!

    • 19 min
    Data Marts in Power BI

    Data Marts in Power BI

    Data marts in Power BI have arrived and the words “data mart” mean something to data professionals.  In this episode of the SQL Data Partners Podcast, we introduce the latest offering in Power BI and discuss the good, the bad, and the ugly for teams looking to arrive at self-service business intelligence.
    The show notes and video for this episode can be found at https://sqldatapartners.com/2022/07/12/episode-249-data-marts-in-power-bi/. Have fun on the SQL Trail!

    • 27 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

You Might Also Like

Guy Glantser, Eitan Blumin
Allen Underwood, Michael Outlaw, Joe Zack
Marketplace
NPR
Freakonomics Radio + Stitcher
CodeNewbie