Episode 114 - Lots of catching up to do

Guy and Eitan discuss several very interesting new features recently announced by Microsoft. Relevant links for more info: Stop defragmenting and start living: introducing auto index compaction | Microsoft Community Hub Automatic Index Compaction - SQL Server | Microsoft Learn Da ...  Show more

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

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at:  https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/ 

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

Things to consider when choosing a database Speed & Latency Consistency, ACID Compliance Scalability Language support & Developer Experience Relational vs. NoSQL) Data types Security Database environment Client vs Server access Info on Kris & Harper: Website: harperdb.io Twitter: ...  Show more

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