SQL Data Partners Podcast

Latest Episodes:

Episode 206: .NET Core Interactions with SQL Server Sep 17, 2020

Show notes

There are many programming languages available to the modern developer and there are even more options for connecting to the database. In this episode, we talk with Taurius Litvinavicius about his Manning course on connecting .NET Core to SQL Server.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/16/episode-206-net-core-interactions-with-sql-server. Have fun on the SQL Trail!

Episode 205: Data Modeling for Power BI Sep 03, 2020

Show notes

Power BI is founded on the idea of self-service BI and Excel is the most common data source in the world. While Power BI can import that information with ease, the data may not be in the best format. In this episode, we discuss areas report creators should consider when building Power BI reports so their reports can perform to their satisfaction and maintenance of the reports will be easier over the long run.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/03/episode-205-data-modeling-for-power-bi. Have fun on the SQL Trail!

Episode 204: IoT in Azure Aug 19, 2020

Show notes

A variety of devices now have the ability to report metrics about status, performance, or other sensor information. Collecting this information and making it useful in business operations can be difficult and the Internet of Things (IoT) provides options for consuming, processing, and reporting. Microsoft has introduced a number of different offerings, and in this episode, we touch on a couple of them and discuss scenarios where one may serve you better than another.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/08/19/episode-204-iot-in-azure. Have fun on the SQL Trail!

Episode 203: Spark in Action Aug 07, 2020

Show notes

As we stretch the technology stack in this episode, I rely on my trusty co-hosts to get us through. Kevin and Jean-Georges Perrin do a great job giving us their thoughts on Spark. I hope you will enjoy the episode.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/08/06/episode-203-spark-in-action. Have fun on the SQL Trail!

Episode 202: Virtual Conferences Jul 23, 2020

Show notes

As COVID-19 prevents us from gathering in the same place, how do organizers continue to put on compelling events? This strikes home as SQL Data Partners consider whether to have our SQL Trail event this fall. Matt Gordon put on an event in April and I was interested to get his take on how things went and how he accomplished his goals for the event. I have also participated in several online events and in the episode we discuss the pros and cons of virtual events and we give our take on how to make them better.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/07/22/episode-202-virtual-conferences. Have fun on the SQL Trail!

Episode 201: Common Data Model Jul 09, 2020

Show notes

After we recorded Episode 189, we knew we lacked some of the business reasons behind the Common Data Model. Luckily, we reached out Tricia Wilcox-Almas and she has helped us fill in some of the gaps and also present how the Common Data Model is implemented in the new versions of Azure Data Lake.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/07/08/episode-201-common-data-model. Have fun on the SQL Trail!

Episode 200: Anything but the Cowboys . . . Jun 25, 2020

Show notes

To celebrate our 200th episode, we reached out to Bob Ward to come and celebrate this milestone with us. I have to plead the 5th on why it took us 200 episodes to finally invite him; however, we finally wised up and Bob walks us through some of the changes SQL Server has experienced over the years and what is in store (Spoiler—no big scoops) for the relational engine. We also have a several copies of Bob's SQL Server 2019 Revealed book to give away and he was gracious enough to sign them. We appreciate Bob joining us and look forward to another 200 episodes.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/06/24/episode-200-anything-but-the-cowboys. Have fun on the SQL Trail!

Episode 199: Technical Debt Apr 30, 2020

Show notes

We can incur technical debt in several ways—aging technology, choosing delivery speed over scale architecture, or implementing new technology the entire team cannot yet support. I don't know that I've ever worked at a place that hasn't talked about technical debt. It wasn't until I stumbled on a talk by Adam Lenda that make me think about the ways I might contribute to technical debt. He also gave some ideas of how I can help pay it off.

In this episode, we talk with Adam about what technical debt is, why we might be okay incurring some, and situations we might put ourselves into when trying to do 'the right thing'. Adam also suggests some ways to pay off some of this burden and like most debt, there is no easy fix and he suggests running a pretty tight ship; however, I found his ideas insightful and I think you will, too.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/05/06/episode-199-technical-debt. Have fun on the SQL Trail!

Episode 198: Cloud Infrastructure Apr 23, 2020

Show notes

In a previous episode (175) we discussed migrating to the cloud, and we had a few comments from our compañeros which mentioned we should include more details around cloud infrastructure—the pieces or processes you want or DON'T want to administer. In this episode, we dive into cloud infrastructure and discuss some scenarios on when you might choose one over the other.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/04/22/episode-198-cloud-infrastructure. Have fun on the SQL Trail!

Episode 197: Power Query in Power BI Apr 15, 2020

Show notes

In 1990, the group Snap! release a song called "The Power". It would take Microsoft more than 20 years, but they eventually came up with a series of 'power' tools they built into Excel. Those tools later grew into Power BI--which is kinda like Voltron if you are old enough to remember. In this episode we discuss one of the first data manipulation tools in the set: Power Query. Before you start manipulating all those fun visualizations, you might need to get your data in shape. If you have a data warehouse, you are probably in good shape; however, for the rest of us, there is Power Query. This episode takes us through an overview and discusses in what cases you might have to dive into the code, or M language, when the GUI doesn't cut it.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/04/15/episode-197-power-query-in-power-bi. Have fun on the SQL Trail!

Our TOPPODCAST Picks

Follow Us

Stay Connected

Related Podcasts

Links

Stay Connected