The SQL Data Partners Podcast

An episodic conversation about solving problems with the Microsoft data platform, our podcast combines trending topics and professional development to keep you easily informed and entertained.


Have you ever wished you could be a part of
the SQL Data Partners Podcast?

Well, now you can! Starting with Season 5, the podcast is going LIVE! Subscribe on YouTube and Follow on Twitch to be notified as we go live so you can join in. Come and chat with Carlos, Eugene and Kevin!

Want to submit some feedback?

Did we miss something or not quite get it right? Want to suggest a guest for the podcast?

Founder + Managing Consultant, SQL Data Partners Organizer + Sponsor, SQL Trail

Carlos Chacon

Chief Technical Officer, fare.game; Chief Technical Officer, Envizage Technologies

Kevin Feasel

Independent Business Intelligence Consultant Pluralsight Author Owner, SQLGene Training

Eugene Meidinger

Episode 208: SQL Server and Graph Data 1025 601 Carlos L Chacon

Episode 208: SQL Server and Graph Data

There is a growing list of formats to store data and Graph is one of…

read more
Episode 207: SQL Trail 2020 Retrospective 1025 601 Carlos L Chacon

Episode 207: SQL Trail 2020 Retrospective

SQL Trail 2020 was a success! There was a time I was unconvinced this would…

read more
Episode 206: .NET Core Interactions with SQL Server 1025 601 Carlos L Chacon

Episode 206: .NET Core Interactions with SQL Server

There are many programming languages available to the modern developer and there are even more…

read more
Episode 205: Data Modeling for Power BI 1025 601 Carlos L Chacon

Episode 205: Data Modeling for Power BI

Power BI is founded on the idea of self-service BI and Excel is the most…

read more
Episode 204: IoT in Azure 1025 601 Carlos L Chacon

Episode 204: IoT in Azure

A variety of devices now have the ability to report metrics about status, performance, or…

read more
Episode 203: Spark in Action 1025 601 Carlos L Chacon

Episode 203: Spark in Action

I’ll have to be honest on this one—I don’t do anything with Spark, so I…

read more
Episode 202: Virtual Conferences 1025 601 Carlos L Chacon

Episode 202: Virtual Conferences

As COVID-19 prevents us from gathering in the same place and has us moving to…

read more
Episode 201: Common Data Model 1024 600 Carlos L Chacon

Episode 201: Common Data Model

After we recorded Episode 189, we knew we lacked some of the business reasons behind…

read more
Episode 199: Technical Debt 1024 512 Carlos L Chacon

Episode 199: Technical Debt

We can incur technical debt in several ways—aging technology, choosing delivery speed over scale architecture,…

read more
Episode 198: Cloud Infrastructure 1024 512 Carlos L Chacon

Episode 198: Cloud Infrastructure

In a previous episode (175) we discussed migrating to the cloud, and we had a…

read more
Episode 197: Power Query in Power BI 1024 512 Carlos L Chacon

Episode 197: Power Query in Power BI

​In 1990, the group Snap! release a song called “The Power”. It would take Microsoft…

read more
Episode 196: Teleworking 1024 512 Carlos L Chacon

Episode 196: Teleworking

This is a topic I have been interested in covering for some time and as…

read more
Episode 195: Understanding DAX 1024 512 Carlos L Chacon

Episode 195: Understanding DAX

The number of new programming languages never ceases to amaze me. Technology advances continue to…

read more
Episode 194: PolyBase Use Cases 1024 512 Carlos L Chacon

Episode 194: PolyBase Use Cases

After Episode 180 on PolyBase came out, we received a few questions on use cases for PolyBase. Compañeros, when you…

read more
Episode 193: Power BI Premium 1024 512 Carlos L Chacon

Episode 193: Power BI Premium

Our regular host is down for the count with the flu; however, the podcast must…

read more
Episode 191: Power BI Row-Level Security 1024 512 Carlos L Chacon

Episode 191: Power BI Row-Level Security

Wouldn’t it be nice if you could filter the rows a user sees in Power…

read more
Episode 190: SQL Server 2019 1024 512 Carlos L Chacon

Episode 190: SQL Server 2019

Getting released just before the end of the year, SQL Server 2019 is now available…

read more
Episode 189: Power BI Common Data Model 1024 512 Carlos L Chacon

Episode 189: Power BI Common Data Model

Moving data is fairly straightforward; however, mapping data from one source to another can be…

read more
Episode 188: Databricks 1024 512 Carlos L Chacon

Episode 188: Databricks

A couple of years ago, Netflix offered a reward for anyone who could improve the…

read more
Episode 187: Power BI Performance Tuning 1024 512 Carlos L Chacon

Episode 187: Power BI Performance Tuning

Make it go faster! Visualizations are great, but when users start complaining about the load…

read more
Episode 186: Analytics & Security: Find Pain Points, Make a Plan 150 150 Carlos L Chacon

Episode 186: Analytics & Security: Find Pain Points, Make a Plan

2020 dawns a first for our podcast. This episode is dedicated entirely to a listener…

read more
Episode 184: Where do people get stuck with Power BI? 1024 512 Carlos L Chacon

Episode 184: Where do people get stuck with Power BI?

​You’ve seen the visualizations and want to dive in–perhaps you were assigned the task. However…

read more
Episode 183: SQL Server Big Data Clusters 1024 512 Carlos L Chacon

Episode 183: SQL Server Big Data Clusters

SQL Server 2019 is out and one of the most interesting additions is SQL Server…

read more
Episode 182: XEvents 1024 512 Carlos L Chacon

Episode 182: XEvents

The very first podcast episode I recorded was about Extended Events. We’ve had several new…

read more
Episode 181: Paginated Reports in Power BI 560 288 Carlos L Chacon

Episode 181: Paginated Reports in Power BI

In the second quarter of 2019, it was announced that Power BI would support paginated…

read more
Episode 178: Database Design 560 288 Carlos L Chacon

Episode 178: Database Design

After 170 episodes, we bring Louis Davidson back to talk about database design and get…

read more
Episode 177: Lock Pages in Memory 560 288 Carlos L Chacon

Episode 177: Lock Pages in Memory

The Lock Pages in Memory policy came up in our internal discussions. I wanted to…

read more
Episode 176: Power BI Storage Options 709 600 Carlos L Chacon

Episode 176: Power BI Storage Options

Creating reports in Power BI is awesome, but once you are ready to publish the…

read more
Episode 175: Migrating to the Cloud 1200 1016 Carlos L Chacon

Episode 175: Migrating to the Cloud

Are you in the cloud? Lots of folks are talking about moving to the cloud;…

read more
Episode NULL: Summer Break 1200 1016 Carlos L Chacon

Episode NULL: Summer Break

Episode 171: SQL Server Encryption 709 600 Carlos L Chacon

Episode 171: SQL Server Encryption

You’ve got first name, last name, full name, birth date, address, email, phone, tax ID…

read more
Episode 170: Devops with Power BI 709 600 Carlos L Chacon

Episode 170: Devops with Power BI

Two years ago blogger Jay Killeen observed, “And with modern languages and modern applications such…

read more
Episode 169: Should you learn to code? 1300 1100 Carlos L Chacon

Episode 169: Should you learn to code?

These are dark times. Drastic measures must be taken. In this episode, we talk about–coding.…

read more
Episode 168: Data Privacy Settings 1300 1100 Carlos L Chacon

Episode 168: Data Privacy Settings

One of the great abilities we have with Power BI is connecting to multiple data…

read more
Episode 167: Azure SQL Data Sync 1300 1100 Carlos L Chacon

Episode 167: Azure SQL Data Sync

Azure SQL Data Sync has been generally available for almost a year now. Have you…

read more
Episode 166: Custom Visuals 1300 1100 Carlos L Chacon

Episode 166: Custom Visuals

The number one reason organizations choose Power BI is the ability to visualize data; however,…

read more
Episode 165: Artificial Intelligence 1300 1100 Carlos L Chacon

Episode 165: Artificial Intelligence

“Why should I care about this episode?” I know many of you are going to…

read more
Episode 164: The DAX Episode 1300 1100 Carlos L Chacon

Episode 164: The DAX Episode

DAX is the acronym for Data Analysis Expressions, and it is the formula language used…

read more
Episode 163: Very Large Databases 1300 1100 Carlos L Chacon

Episode 163: Very Large Databases

Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth?…

read more
Episode 162: Power Query vs DAX 1300 1100 Carlos L Chacon

Episode 162: Power Query vs DAX

In this corner, coming in with all its Excel glory we have Power Query! And…

read more
Episode 160: Power BI Embedded 1300 1100 Carlos L Chacon

Episode 160: Power BI Embedded

The traditional model for Power BI is to pay per user, but what if you…

read more
Episode 159: Power BI Dataflows 1300 1100 Carlos L Chacon

Episode 159: Power BI Dataflows

So what happens when you want to use data from two different sources, manipulate it…

read more
Episode 158: Gateways 1300 1100 Carlos L Chacon

Episode 158: Gateways

For only 10 bucks a month you can start visualizing your data and finally get…

read more
Episode 157: Windows Server Core 1300 1100 Carlos L Chacon

Episode 157: Windows Server Core

I can still remember working in high school when you had to ‘dial in’ to…

read more
Episode 156: Social Intelligence 1300 1100 Carlos L Chacon

Episode 156: Social Intelligence

How well do you connect with others? We generally think pretty good of ourselves and…

read more
Episode 155: Data Science 1300 1100 Carlos L Chacon

Episode 155: Data Science

Do you want to be a data scientist? Do you even know what data science…

read more
Episode 154: Test Driven Development 1300 1100 Carlos L Chacon

Episode 154: Test Driven Development

Who hasn’t had a deployment go a bit sideways?  For all the talk of DevOps…

read more
Episode 153: SQL Trail 2018 Retrospective 1300 1100 Carlos L Chacon

Episode 153: SQL Trail 2018 Retrospective

Year Two of our beautiful idea–gather together with a group of podcast listeners in a…

read more
Episode 150: The SQL Data Partners Team 1300 1100 Carlos L Chacon

Episode 150: The SQL Data Partners Team

Today we, the SQL Data Partners team, celebrate our 150th podcast episode! We introduce ourselves,…

read more
Episode 149: Managing lots of databases 1300 1100 Carlos L Chacon

Episode 149: Managing lots of databases

Do you ever feel like you have too many databases to manage?  Managing lot of…

read more
Episode 148: High Performance SSRS 1300 1100 Carlos L Chacon

Episode 148: High Performance SSRS

SSRS is great — it comes with SQL Server, provides quite a bit of functionality,…

read more
Episode 147: Always Encrypted 1300 1100 Carlos L Chacon

Episode 147: Always Encrypted

Security is always important to data folks and when a new feature like Always Encrypted…

read more
Episode 146: SQL Trail Speakers 1300 1100 Carlos L Chacon

Episode 146: SQL Trail Speakers

So what is SQL Trail all about?  In this episode we invite our MVPs to…

read more
Episode 143: Transitioning from DBA to Data Warehouse Architect 1300 1100 Carlos L Chacon

Episode 143: Transitioning from DBA to Data Warehouse Architect

We frequently talk about how many DBAs are concerned our job may be phased out…

read more
SQL Data Partners now certified as Small/Micro SWaM Business in Virginia 150 150 Carlos L Chacon

SQL Data Partners now certified as Small/Micro SWaM Business in Virginia

Exciting new announcement! SQL Data Partners has received its certifications as a “Small/Micro” business under…

read more
Episode 141: Wait, Wait, What? 1300 1100 Carlos L Chacon

Episode 141: Wait, Wait, What?

In this episode, we chat with David Maxwell about wait stats, what they are and…

read more
Episode 140: Why data types matter 1300 1100 Carlos L Chacon

Episode 140: Why data types matter

They’re just numbers, right?  A date’s a date.  It’s just string data, who cares?  I…

read more
Episode 139: Getting Started with SQL Server in Azure 1300 1100 Carlos L Chacon

Episode 139: Getting Started with SQL Server in Azure

“The move to the cloud is inevitable.”  Listening to Microsoft marketing and all the MVPs…

read more
Episode 138: Meeting of the Minds 1300 1100 Carlos L Chacon

Episode 138: Meeting of the Minds

I invited our fearless panelists Kevin Feasel and Eugene Meidinger to join me for a…

read more
Episode 137: You want to work with Analytics? 150 150 Carlos L Chacon

Episode 137: You want to work with Analytics?

What’s in a name? That which we call a rose, by Any Other Name would…

read more
Episode 136: DevOps with Visual Studio 1300 1100 Carlos L Chacon

Episode 136: DevOps with Visual Studio

Everybody does things a little differently and this is one of the things I LOVE…

read more
Episode 135: Seinfeld Episode 1300 1100 Carlos L Chacon

Episode 135: Seinfeld Episode

Normally we have one specific topic we focus on each episode.  This episode is a…

read more
Episode 134: CosmosDB 1300 1100 Carlos L Chacon

Episode 134: CosmosDB

It is not very often the internal codename is used when a product is launched;…

read more
Episode 133: Shrinking Files 1300 1100 Carlos L Chacon

Episode 133: Shrinking Files

While the ability to shrink data files is available in SSMS, the conventional wisdom is…

read more
Episode 132: What technologists can learn from superheroes 1300 1100 Carlos L Chacon

Episode 132: What technologists can learn from superheroes

Bang! Pow! Crash!  Besides just awesome fighting techniques, are there things we can learn from…

read more
Episode 129: Graph Databases Carlos L Chacon

Episode 129: Graph Databases

Books online state: “There is nothing a graph database can achieve, which cannot be achieved…

read more
Episode 128: Database Doing DevOps 1300 1100 Carlos L Chacon

Episode 128: Database Doing DevOps

To Devops or not to Devops, that is the question.  We’ve talked before about how…

read more
Episode 127: Developing in the database 1300 1100 Carlos L Chacon

Episode 127: Developing in the database

There has been a remarkable shift introduced in the new features of SQL Server–programming languages…

read more
Episode 126: SQLSaturday Edition 1300 1100 Carlos L Chacon

Episode 126: SQLSaturday Edition

Have you attended a SQLSaturday event? They are great events and in this episode we…

read more
Episode 125: You must be an engineer 1024 512 Carlos L Chacon

Episode 125: You must be an engineer

Have you ever found it difficult to explain how something works to a co-worker?  What…

read more
Episode 123: Top 5 things to know when getting admin access 1024 512 Carlos L Chacon

Episode 123: Top 5 things to know when getting admin access

Listener Eduardo Cervantes wanted to get our take on what developers should do when they…

read more
Episode 122: Isolation Levels Carlos L Chacon

Episode 122: Isolation Levels

Does not play well with others. Is this description appropriate for some of the queries…

read more
Episode 121: What makes a good manager? 1024 512 Carlos L Chacon

Episode 121: What makes a good manager?

I have heard it said “People don’t quit jobs–they quit managers”.  At a recent event,…

read more
Episode 120: SQL Injection 1024 512 Carlos L Chacon

Episode 120: SQL Injection

Shouldn’t they have fixed that instead of putting out all these new features?  That might…

read more
Episode 117: PASS Summit Retrospective 1024 512 Carlos L Chacon

Episode 117: PASS Summit Retrospective

Have you ever had a week without a Wednesday?  Me neither, so for this episode,…

read more
Episode 115: The Companero Conference Retrospective 1024 512 Carlos L Chacon

Episode 115: The Companero Conference Retrospective

It was a beautiful idea.  Gather together with a group of our podcast listeners in a conference…

read more
Episode 114: How do you start consulting? 1024 512 Carlos L Chacon

Episode 114: How do you start consulting?

One of the advantages to a small conference is the ability to take attendee feedback…

read more
Episode 112: Keeping up with patching 1652 827 Carlos L Chacon

Episode 112: Keeping up with patching

When listener Mel Vargas first suggested the topic of patching, I was not sure this…

read more
Episode 106: Temporal Tables Carlos L Chacon

Episode 106: Temporal Tables

User: What was that record before it was updated? Me: I don’t know.  Maybe I…

read more
Episode 103: Plan Reuse 516 150 Carlos L Chacon

Episode 103: Plan Reuse

When we write our queries to the database, SQL Server has to go and figure…

read more
Episode 100: Role Reversal 1024 512 Carlos L Chacon

Episode 100: Role Reversal

Something a bit strange happened in episode 100–almost like something out of the twilight zone,…

read more