SQL Server Radio

Nov 11 2024 159 ep. 37 mins 232
SQL Server Radio Podcast artwork

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.

  Technology  News
RSS feed Share
Copy RSS


Subscribe on Podcast Addict


Episode 169 - Resumable Incremental Database Integrity Checks

Nov 11 2024 32 mins  
Guy and Eitan discuss the common challenge of long-running database integrity checks (DBCC CHECKDB) and a solution to resolve it, and why do we need integrity checks at all? Relevant links: PASS Data Community Summit Incremental Integrity Check for Large Databases - Eitan Blumin's blog SQL Server Integrity Check - by Ola Hallengren tigertoolbox/MaintenanceSolution/5_job_Maintena

Episode 168 - New data types in SQL Server and a question about index fragmentation

Oct 14 2024 32 mins  
Guy and Eitan discuss some interesting news from Microsoft regarding SQL Server, and also about the right way to handle index fragmentation. Relevant links: Resources from Microsoft: Preview release of SDK-style SQL projects in Visual Studio 2022 - Microsoft Community Hub Native JSON support now in preview in Azure SQL Managed Instance - Microsoft Community Hub EAP for Vector

Episode 167 - Let's Troubleshoot SQL AG Synchronization Latency

Sep 09 2024 37 mins  
Fair warning for all listeners! Before starting to listen to this podcast, very strongly recommended: Have the diagram at the bottom of this page ready in front of you, so that it'll be easier for you to follow along: Common Causes and Troubleshooting Solutions for SQL AG Data Synchronization Latency - Microsoft Community Hub (sorry in advance!) Additional relevant links: Inde

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

Aug 12 2024 35 mins  
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 | Microsoft Learn Altering lock escalation for SQL Server tables (mssqltips.com) dbatools docs | Import

Episode 165 - News in Azure SQL and Woes of Excel

Jul 08 2024 38 mins  
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 correctly in AlwaysOn Availability Groups. Relevant links: SQLBits Free Videos - YouTube JSON data type (prev

Episode 164 - The Good the Bad and the Ugly Transactional Replication

Jun 10 2024 35 mins  
Guy and Eitan continue discussing HADR solutions. But this time focusing on Transactional Replication, its cons and pros and potential use cases. Also, some important announcements from Microsoft about Azure SQL! Relevant links: Data API builder General Availability (microsoft.com) Build REST API with Azure Data API Builder (DAB) (mssqltips.com) Zero ETL, Near-real time replicat

Episode 163 - When and Why to HADR

May 13 2024 34 mins  
Guy and Eitan discuss the various High Availability and Disaster Recovery options available to us in Microsoft SQL Server, their main advantages, limitations, and when it's most suitable to use or not to use them. Relevant links for further reading: AlwaysOn Basic Availability Groups / Database Mirroring AlwaysOn "Enterprize" Availability Groups Failover Cluster Instance Log Shipp

Episode 162 - Backups and Recovery, RTO, RPO, and RCO

Apr 08 2024 35 mins  
Guy and Eitan talk about some interesting news from Microsoft about SQL Server in Azure. And also discuss the topic of Backups and Recovery, RTO, RPO, RCO, and database Integrity Checks. Relevant links: Microsoft Copilot in Azure extends capabilities to Azure SQL Database (Private Preview) - Microsoft Community Hub Regex in SQL DB (microsoft.com) SQL Server Regular Expressions

Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes)

Mar 21 2024 41 mins  
Niko Neugebauer and Vladimir Ivanovic are our esteemed guests for today, and they have a HUGE announcement to make about Azure SQL Managed Instances. Extra! Extra! 🗞 Hear all about it on this exclusive scoop here at the SQL Server Radio podcast! Relevant links: Azure SQL Managed Instance Next-gen GP (microsoft.com) Use Next-gen General Purpose service tier - Azure SQL Managed

Episode 160 - OPTION RECOMPILE and the magical Turbo button

Feb 12 2024 32 mins  
Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info: OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Microsoft Learn Should I use option(recompile)? – SQLServerCentral SQL SERVER - Parameter Sniffing an