Dec 2025

Erik Darling and Kendra Little talk AI, SQL Server 2025, and the Future Is Text Files

45m 48s

Jan 2024

Power BI Performance Tuning with Eugene Meidinger

Eugene Meidinger stops by to chat about Power BI Performance Tuning with Kendra. We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that ... Show More

53m 54s

Sep 2023

Automated Deployments and the Art of the Database with Database Michael J Swart

In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he's come to illustrate some of the coolest blog posts ever to be written about data. Check out Michael's art and blog posts at <a href= "https://michaeljswart.c ... Show More

1h 5m

Dec 2023

Episode 158 - Reverse Engineering Table Relations based on SQL Plans

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: <ul class="ak-ul"> <li> <a href= "https://techcommunity.microsof ... Show More

41m 41s

Jul 2023

Episode 154 - Beavers and very loud farts

Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about! Relevant links: Trigram Wildcard String Search in SQL Server The Story of DBeaver, PostgreSQL, and the silly data engineer SQL Server Error Log Management High VLF Counts Got Yo ... Show More

37m 14s

Jan 2024

Episode 159 - Select * Wastes Money

Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance ... Show More

37m 55s

Mar 2022

Understanding Aggregate Functions Performance | The Backend Engineering Show

Aggregate functions like Count, max, min, avg performance really depends on how did you tune your database for that kind of workload. Let us discuss this. 0:00 Intro 1:22 SELECT COUNT(*) 4:30 SELECT AVG(A) 5:15 SELECT MAX(A) 8:00 Best case sc ... Show More

23m 39s

Sep 2023

Exploring SQL and ETL

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

31m 57s

Apr 2016

Show 44 - SSMS Can Beep

Did you know SSMS can make sounds? We start the show with some interesting things you might do with it. In addition, we talk about: <ul> <li>SQL Server on Linux</li> <li>Hadoop fundamentals</li> <li>SQL Server 2016 eBook</li> <li>Changes to au ... Show More

37m 3s

Apr 2023

Episode 151 - Tales from the SQL Bits of 2023

Guy and Eitan share their experience from SQLBits 2023 and some of their favorite sessions. Relevant links: Official SQLBits Website SQLBits Content Library SQLBits YouTube Channel SQL Server Debugging with WinDbg – an Introduction Join #TeamHugo and Help Fight Leukemia Parameter ... Show More

31m 57s

Aug 2024

Episode 166 - DR Planning for SQL Server and Loading Large CSV Files

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible. Relevant links: 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub bcp utility - SQL Server | M ... Show More

35m 32s

Jul 2024

Episode 165 - News in Azure SQL and Woes of Excel

Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correct ... Show More

38m 44s

Sep 2023

164: Choosing a Database For Your Project With Kris Zyp

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

1h 31m

Erik Darling and Kendra Little Rate SQL ...