Guy and Eitan talk about Erik Darling's new monitoring app, which reminds us of similar tools we had experience with long ago. And, again, it's time to talk about AI. Specifically, a side-effect of it called "The Liar's Dividend". Relevant links for more information: Free SQL Ser ...Show more
Episode 184 - The Role of the DBA is Dead (Again)
Looks like it's that time of the year again, to face the impending death of the DBA role! Or... Is it? Guy and Eitan discuss the topic and raise several interesting points you should listen to. Relevant links: sqlfingers.com: Death of the DBA (Again) (Reddit thread)
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