Info

SQL Data Partners Podcast

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.
RSS Feed Subscribe in Apple Podcasts
2021
February
January


2020
December
October
September
August
July
June
April
March
February
January


2019
December
November
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: 2021

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.

Feb 24, 2021

How do you document your SQL Server environments? I can remember walking through Brent Ozar’s takeover script back in the day and how cumbersome it was to put all that information together. We have a few more options available to us now. In this episode, we discuss a listener question along with some options for doing server inventories. SQL Trail is coming on March 18th. Will we see you there?

The show notes (and video) for today's episode can be found at https://sqldatapartners.com/2021/02/24/episode-219-sql-server-inventory. Have fun on the SQL Trail!

Feb 17, 2021

In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown.

The show notes for today's episode (including the video with the demonstration) can be found at https://sqldatapartners.com/2021/02/17/episode-218-file-growths. Have fun on the SQL Trail!

Feb 10, 2021

The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about various topics.

The show notes for today's episode can be found at https://sqldatapartners.com/2021/02/10/episode-217-a-little-something-about-a-few-things. Have fun on the SQL Trail!

Feb 3, 2021

When working on a customer on an import process, she made the comment—if we were doing true EDI, we’d  [Do X]. The comment got me thinking—Aren’t we working on an EDI process? As someone who frequently has multiple roles on projects, I perhaps had lumped all the various 3 letter acronyms into the same spaghetti salad. In this episode of the podcast, Eugene and I chat about the differences—and how thy might impact your team. Data projects can get complex with lots of moving pieces and understanding the different pieces can be helpful as you work to solve your specific pieces of the puzzle.

The show notes for this episode and the video to watch Eugene's Query Folding demo in action can be found at https://sqldatapartners.com/2021/02/03/episode-216-edi-vs-etl. Have fun on the SQL Trail!

Jan 27, 2021

We have been moving data for years with technologies like DTS and SSIS; however, these were very much designed for on-premises moves in mind. As more cloud services were being offered Microsoft needed a service to help customers using those services move data around. Azure Data Factory was born with the initial premise of moving data between cloud services; however, it has added the ability to connect with on-premises systems and continues to add a variety of connectors it can now natively support.

In this episode, we chat with our friend Andy Leonard about Azure Data Factory, his experience working with the product team, and how customers can leverage the cloud to get business done faster.

The show notes for today's episode can be found at https://sqldatapartners.com/2021/01/27/episode-215-azure-data-factory/. Have fun on the SQL Trail!

Jan 13, 2021

We open this year with a few updates on the podcast, a change to SQL Trail, and we invite you to give us some feedback on writing a book for 2021.

The show notes for today's episode can be found at https://sqldatapartners.com/2021/01/13/episode-213-new-goals-for-2021/. Have fun on the SQL Trail!

1