Episode 187 - Transactional Replication Betwe...

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

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

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?

Bharani Subramaniam and Madhu Podil ...

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. 

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

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