In this year's first episode of the new year, Guy and Eitan discuss the new Next-gen General Purpose tier of Azure SQL Managed Instance, which is now GA. They also discuss a few interesting customer stories, how they were resolved, and how they're not actually SQL Server's fault. ...Show more
Episode 182 - Matan Yungman's Show-and-Tell of Rapido
Matan Yungman is our special host for today, who came especially to talk about his special project called "Rapido", which is capable of automatically tuning SQL queries at scale. Perhaps there is some inspiration in it for us? Relevant links: Matan Yungman | LinkedIn Matan Yungma ...Show more
Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath) Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality ...Show more
164: Choosing a Database For Your Project With Kris Zyp
<ul><li>Speed & Latency</li><li>Consistency, ACID Compliance</li><li>Scalability</li><li>Language support & Developer Experience</li><li>Relational vs. Non-relational (SQL vs. NoSQL)</li><li>Data types</li><li>Security</li ...Show more
Table Clustering (Clustered Index) - The pros and cons
In this episode of the backend engineering show, I discuss database clustering. This is also known as table clustering, clustered index or Index organized table all names represents the same thing. I will talk about the benefits of clustering and also the disadvantages of impleme ...Show more