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 ...عرض المزيد
Episode 181 - The new SSMS is still blue
Guy and Eitan talk about the new preview version of SSMS, application locks, and stupid troubles with TempDB shrinkage. Relevant links: Announcing the Release of SQL Server Management Studio 22 Preview 3 | Microsoft Community Hub Release Notes for SQL Server Management Studio (SS ...عرض المزيد
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 ...عرض المزيد
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 ...عرض المزيد
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 ...عرض المزيد