SQL Data Partners Podcast cover image

SQL Data Partners Podcast

Latest episodes

undefined
Apr 14, 2021 • 9min

Episode 223: Podcast Update

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episodes going back to being published every other Wednesday. If you have a subject that you’d like to chat about on the podcast with us, we’d love to schedule a time with you…go to sqldatapartners.com/podcast to sign up. We invite you to submit to our Call for Speakers for SQL Trail June 2021, starting April 15th, and whether you speak or not, to attend SQL Trail on June 15th. Carlos also discusses how you can join the SQL Data Partners team as an independent contractor. The show notes for today's episode can be found at https://sqldatapartners.com/2021/04/14/episode-223-podcast-update. Have fun on the SQL Trail!
undefined
Mar 24, 2021 • 1h 4min

Episode 222: Azure Arc-enabled Data Services

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. Since Eugene suggested our previous attempt at Azure Arc was insufficient, we invited Ben Weissman and Anthony Nocentino, authors of the book Azure Arc-Enabled Data Services Revealed, to the podcast to discuss how this technology came about and why the future looks very exciting. The show notes and video can be found at https://sqldatapartners.com/2021/03/24/episode-222-azure-arc-enabled-data-services. Have fun on the SQL Trail!
undefined
Mar 22, 2021 • 39min

Episode 221: SQL Trail March 2021 Retrospective

Virtual conferences are  just not the same as the conferences we are used to, but we’re still determined to provide a good learning and networking environment for our friends. We very much miss having conferences in person and look forward to that happening again. In the meantime, we have discovered Airmeet and we had a great event: our first of the year. We are doing another data platform conference in June similar to this one and a bigger event in October. Carlos and Kevin sit down and dissect the good, the bad and the indifferent that was SQL Trail March 2021. The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/03/22/episode-221-sql-trail-march-2021-retrospective. Have fun on the SQL Trail!
undefined
Mar 10, 2021 • 45min

Episode 220: Microsoft Ignite Recap

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss something you think we should talk about? Let us know! The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/03/10/episode-220-microsoft-ignite-recap. Have fun on the SQL Trail!
undefined
Feb 24, 2021 • 48min

Episode 219: SQL Server Inventory

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!
undefined
Feb 17, 2021 • 31min

Episode 218: File Growths

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!
undefined
Feb 10, 2021 • 34min

Episode 217: A Little Something About A Few Things

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!
undefined
Feb 3, 2021 • 33min

Episode 216: EDI vs ETL

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!
undefined
Jan 27, 2021 • 1h 7min

Episode 215: Azure Data Factory

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!
undefined
Jan 13, 2021 • 32min

Episode 213: New Goals for 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!

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode