Erik Darling and Kendra Little talk AI, ...

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

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

<p>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.</p> <p>Check out Michael's art and blog posts at <a href= "https://michaeljswart.c ... Show More

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

<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

In this show, we talk about: SQLBits 2019 Guy is Bragging about Tel Aviv Marathon Microsoft Helps You Transform Your 2008 Server Applications with Azure MongoDB Database Skills - Sia Cheap Thrills Parody Matan is Bragging about Azure Data Explorer SQL Saturday Israel 2019 Beware ... Show More

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

<p>!!WARNING!!</p> <p>Due to some technical issues the volume is not always constant during the show. I sincerely apologise for any inconvenience Francesco </p> <p> </p> <p> </p> <p>In this episode, I speak with Richie Cotton, Data Evangelist at DataCamp, as he delves into the d ... Show More

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

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

In this episode, Simon is joined by Shrey Luthra and Jacob Sullivan, Product Managers for Amazon RDS and Amazon DevOps Guru, to talk about a new capability through which customers can detect and diagnose performance issues for their Amazon RDS databases and get recommendations on ... Show More