episode-header-image

Jun 8

29m 33s

Episode 188 - Virtualization pitfalls an...

Guy Glantser, Eitan Blumin

About this episode

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
Hyper-V and SQL Server Best Practices: What We Wish You Knew - SQL Server Consulting - Straight Path Solutions
Announcing the SSMS StatisticsParser Extension - Brent Ozar Unlimited®
SSMS Extension List
Statistics are not collected when creating new table and indexes and loading data after. · Issue #990 · olahallengren/sql-server-maintenance-solution

Up next

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

Episode 187 - Transactional Replication Between Availability Groups

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 Se ... Show More

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

Recommended Episodes

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

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.

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

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

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

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