logo
episode-header-image
Dec 2023
41m 41s

Episode 158 - Reverse Engineering Table ...

Guy Glantser, Eitan Blumin
About this episode

Guy and Eitan talk about some great things about SQL Server, and mostly Guy's experience in digging into execution plans and generating synthetic IO workloads.

Relevant links:

 

Up next
Sep 8
Episode 191 - High CPU in SQL Server 2025
Guy and Eitan discuss an interesting case study where crazy high CPU was detected after an upgrade to SQL Server 2025. Relevant links: SQL 2025 showing crazy-high CPU | LobsterPot Solutions Enable Automatic Tuning - Azure SQL Database & Azure SQL Managed Instance | Microsoft Lear ... Show More
29m 4s
Aug 10
Episode 190 - SQL Server 2025 gains RDS but loses Web
Guy and Eitan discuss news regarding SQL Server 2025, specifically that it's now publicly available on Amazon RDS, but also that Web Edition is now gone. Also, Guy shares an interesting use case with troubleshooting disk IO latency issues. And finally, Guy and Eitan discuss the d ... Show More
30m 37s
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
Recommended Episodes
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
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
Jul 2025
Platform Engineering, GitOps and AI with Pierre-Gilles Mialon and Glen Yu
Guests are Pierre-Gilles Mialon and Glen Yu. Pierre-Gilles and Glen are Google Developer Experts. We had an opportunity to catch up with them at Next 2025 and we spoke about Platform Engineering, GitOps, Policy as code and AI. Do you have something cool to share? Some questions? ... Show More
21m 10s
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
Oct 2024
Revisiting Server-Driven UI: Scalable Approaches in Large Companies
In this episode of Front End Happy Hour, we explore the benefits and challenges of Server-Driven UI, especially in the context of large-scale applications. Join us as we discuss how this approach impacts front-end development, enhances flexibility, and scales effectively within b ... Show More
57m 35s
Aug 2024
803: The SQLite Takeover with Turso’s Glauber Costa
Scott and Wes chat with Glauber Costa from Turso about the evolution of databases and the fascinating technology behind Turso. They dive into topics like the benefits of massive multi-tenancy, vector search, and why Glauber made the switch from NoSQL to relational databases. Sho ... Show More
1 h
Feb 2024
Postgres Replication at speed with PeerDB's Sai Srirampur
<p>Join Scott Hanselman as he sits down with Sai Srirampur, as they explore the intricacies of Postgres Replication and how it can be turbocharged using PeerDB. In the realm of databases, Postgres Replication is like a well-choreographed dance between servers. Sai takes us behind ... Show More
27m 6s
Dec 2023
LLMs for Data Analysis
In this episode, we are joined by Amir Netz, a Technical Fellow at Microsoft and the CTO of Microsoft Fabric. He discusses how companies can use Microsoft's latest tools for business intelligence. Amir started by discussing how business intelligence has progressed in relevance ov ... Show More
29 m