Listen "SQL Server: The Good, the Bad, and the Ugly - Data and Confused ep 5 with Randy Knight"
Episode Synopsis
In this episode, Glen is joined by Randy Knight of SQL Solutions Group — a Microsoft Certified Master with decades of experience in the SQL Server world.Together, they dive deep into:The hidden pitfalls that trip up developers and accidental DBAsHow poor query design and misunderstood features (like scalar functions) cripple performanceWhy tools like Query Store matter — and why they’re still underusedCloud vs. On-Prem SQL: What you really need to know about Azure, AWS, IaaS, and PaaSWhat sets SQL Server apart from Postgres and OracleAnd the hard lessons you only learn through hands-on experience (or painful outages)Whether you're a seasoned dev, new to SQL, or managing a growing SaaS platform — this episode will help you avoid costly mistakes and rethink how you manage data at scale.Subscribe for more unfiltered conversations about data, performance, and what actually works in the real world.
More episodes of the podcast Data and Confused
The AI Mistakes That Could Cost Your Company Millions with AI governance expert Rock Lambros - Ep16
01/12/2025
STEM, AI, and the Next Generation with Retired NASA Astronaut Dottie Metcalf-Lindenburger - Ep12
06/10/2025
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.