SQL Data Partners Podcast
SQL Data Partners Podcast
Episodes
SQL Data Partners Podcast
Episodes of SQL Data Partners Podcast
Mark All
Once you have your data stored in OneLake, you'll be ready to start transforming it to improve it's usability, accuracy, and efficiency. In this episode of the podcast, Belinda Allen takes us on a delightful journey through Data Flows, Power
Microsoft Fabric offers two enterprise-scale, open-standard format workloads for data storage: Warehouse and Lakehouse. Which service should you choose? In this episode, we dive into the technical components of OneLake, along with some of the d
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 brings to the table (no pun
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 the core features of OneL
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 this evolution of the Azure
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 Server. No matter which way
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 offered in Microsoft Azure,
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 most popular open source dat
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 to many undesirable resu
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 based on rainfall to mainta
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 professional in his organization a
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 episode, Kevin Kline from
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 like Erik Darling who contr
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 year was fine for us, as i
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 has there been so much c
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 administration or management respon
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 Artificial Intelligence or AI in m
All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that time, we were talking about getting your email, v
We're kicking off Season 7 with containers! Spinning up a VM may not be such a big deal anymore; however, most of us still have to request from another group one and wait. Even waiting on an Azure VM can be somewhat painful. Wouldn't it be nice
Compañeros! In May, SQL Data Partners was acquired by Marathon Consulting. There were many moving parts to get this done and we are excited to finally bring this news to the podcast. In this episode we introduce the principles of Marathon Co
A backup is only helpful when you can restore the backup. This should not prove to be overly shocking; however, normally we get the satisfaction of taking a backup and feel like all is well. Ideally, we should be testing our backups on some ca
When we couldn’t confirm a guest speaker by recording time, Eugene, Kevin, Amanda, and I decided the show must go on, so we went into the ideas vault and pulled out a couple of listener questions we hadn’t answered. In this episode, we talk a
Learning new technology can be difficult—especially when it’s a technology in an area you are not familiar with. In this episode, Eugene walks us through some of the challenges he has faced getting started with Azure Synapse. We hope that thi
It would appear Microsoft has run out of words to use for new features/products, so they are just going to recycle existing words for a bit of fun at our expense. In this episode we explore the Azure Data Lakehouse—which is not a data lake, no
We’re back with another SQL Server 2022 feature—Contained Availability Groups. Have you ever failed over to a secondary node and then found a job or login missing? This new Enterprise-only feature aims to solve this problem by ‘containing’ al
Unlock more with Podchaser Pro
- Audience Insights
- Contact Information
- Demographics
- Charts
- Sponsor History
- and More!
- Account
- Register
- Log In
- Find Friends
- Resources
- Help Center
- Blog
- API
Podchaser is the ultimate destination for podcast data, search, and discovery. Learn More
- © 2025 Podchaser, Inc.
- Privacy Policy
- Terms of Service
- Contact Us