SQL Data Partners Podcast

In Episode 281, we introduced Microsoft OneLake with a high-level overview. Now we're going deeper with a discussion on the Parquet format, why Microsoft went with the Delta Lake variation, and what Delta Lake format...

As you start using Fabric, having a central location for your data is crucial. OneLake acts as this unified destination, offering a single, consolidated repository for all your data. In this podcast episode, we explore...

At the Microsoft Build Conference in May 2023, Microsoft announced the new Fabric, where you could slice and dice all your data harmoniously within the environment. A few months later, Kevin, Eugene, and I discussed...

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL...

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Server services now...

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into PostgreSQL, one of the...

Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQL can open the door...

What kinds of problems are organizations solving with Machine Learning? In this episode, we explore a situation where a public works department was looking for more accurate information to predict future water levels...

After discussing the Capabilities Maturity Model in our last episode, it was fate when Andy Levy reached out and suggested a topic which sounds like a case study about his experience with CMM. As the only data...

Have you ever felt stuck in a rut, repeating the same tasks, while knowing there is room for improvement? The Capability Maturity Model may be a way for you to start contributing to those improvements. In this podcast...

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce wonderful folks...

This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no remote option this...

Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win over Milorad Cavic...

In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons. The term manage services refers to the practice of outsourcing business...

We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been including...