logo
episode-header-image
May 13
30m 6s

Episode 187 - Transactional Replication ...

Guy Glantser, Eitan Blumin
About this episode

Guy and Eitan discuss a few new things in the latest SSMS update, and Eitan tells about a very peculiar use case involving transactional replication and AlwaysOn Availability Groups, and Guy talks about a use case involving deletion triggers.

Important note: The part about SQL Server 2025 CU4 adding automatic update was an April 1st joke :)

Relevant links:

Up next
Jul 6
Episode 189 - Top Ten SQL Server Performance Tuning Best Practices and More
Guy and Eitan go over Paul Randal's article of "Top Ten SQL Server Performance Tuning Best Practices" (published in last March), and add their own input. We also talk about considerations of upgrading SQL Server to 2025, and we also learn something new about Temp Table Caching. R ... Show More
39m 1s
Jun 8
Episode 188 - Virtualization pitfalls and best practices with SQL Server
Guy talks about an interesting incident involving performance problems in a virtual environment. And also, we talk about the SSMS StatisticsParser extension and the question of SSMS extensions in general. Relevant links: vmware.com/docs/sql-server-on-vmware-best-practices-guide H ... Show More
29m 33s
Apr 2026
Episode 186 - Automatic Index Compaction and New DB DevOps Tooling
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
31m 16s
Recommended Episodes
Sep 2023
Exploring SQL and ETL
<p>The evolution of SQL and the ease of access to ever larger sizes of computational power has made SQL and ETL a useful pairing for practitioners in the data space. But how do they work together exactly? And what challenges can it pose?</p> <p>Bharani Subramaniam and Madhu Podil ... Show More
31m 57s
Sep 2024
570: It's a Worm
Our preferred external storage solutions, favorite collaboration tools, motivations for smartphone upgrades, and thoughts on the potential for a Skynet-level AI scenario in our lifetime. 
29m 49s
Jul 2015
Shoutout to grandmas
There's lots of news this week, so there are lots of guests as well. Nilay and Dieter are joined by Sean O'Kane, Jake Kastrenakes, and Kaitlyn Tiffany to talk about the Pluto flyby, San Diego Comic-Con, Windows 10, Reddit, and further refinement of the hype scale. Learn more abou ... Show More
1h 7m
May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
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
1h 4m
Aug 2024
189 - LLMs and Data Science
Hilary and Roger discuss Hilary's Use R! keynote presentation, LLMs and R, and whether R (or any programming language) has a future. Also, a brief preview of Roger's JSM 2024 talk. Show notes: Support us on Patreon Roger Peng Hilary Parker List of NSSD Fellows Get the Not So Stan ... Show More
1h 7m
Dec 2023
565: Trickle-Up Concern
Pre-show: Cauterized pants Show administrivia 🎄🕎 NEW MEMBER’S SPECIAL!! 🕎🎄 🎅🏻 Give the gift of ATP! 🎅🏻 Follow-up: More on Apple’s Blue Ocean The 🇪🇺 is doing 🇪🇺 things …and Apple is doing Apple things 📟 Battle Yet more on ECC RAM from Jonathan Dietz Jr. Micron whitepa ... Show More
2h 4m
Listen to millions of songs and podcasts on Anghami