SQL Server Radio
Many announcements and interesting releases came out this past month, so we got a lot to talk about in this episode! Relevant links:
info_outlineSQL Server Radio
Guy talks about a recent migration project he was working on to move an on-prem SQL Server to AWS RDS. Eitan talks about a new AI-related feature in Azure SQL Databases. And we also discuss the new SNAPSHOT backup T-SQL command in SQL Server 2022. Relevant links:
info_outlineSQL Server Radio
Guy and Eitan worry about the decline in SQL Server feature quality. But maybe there's something else behind it? Relevant links:
info_outlineSQL Server Radio
Guy and Eitan discuss a few interesting topics. Including a fun new game called "SQL Noir", how to implement statistical clustering model in SQL, about surrogate and natural keys, and the recently announced deprecation of Azure Data Studio. Relevant links:
info_outlineSQL Server Radio
Guy and Eitan answer an interesting question from the forum regarding the logic of NOT BETWEEN. And also, checking out the SQL Squid Game, discussing SQL Audit, and sharing some tips for SSMS. Relevant links: Tell us how you did and whether you survived the SQL Squid Game! 😉
info_outlineSQL Server Radio
Guy and Eitan talk about SQL Server 2025 (well, they try to, at least), and its various interesting upcoming features. Relevant links:
info_outlineSQL Server Radio
Guy and Eitan go over the most popular sessions released from the SQL PASS archive of 2023, and discuss some other topics. Relevant links:
info_outlineSQL Server Radio
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:
info_outlineSQL Server Radio
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: Index fragmentation: Index fragmentation scripts: Upcoming webinar at the Cloud Data Driven Meetup:
info_outlineSQL Server Radio
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: (sorry in advance!) Additional relevant links:
info_outlineMany announcements and interesting releases came out this past month, so we got a lot to talk about in this episode!
Relevant links:
- What's New in SQL Server 2025 - SQL Server | Microsoft Learn
- SQL Server 2025 - AI ready enterprise database from ground to cloud | Microsoft Community Hub
- Announcing Public Preview of DiskANN in SQL Server 2025 | Microsoft Community Hub
- SQL Server 2025: introducing optimized Halloween protection | Microsoft Community Hub
- SQL Server 2025: introducing tempdb space resource governance | Microsoft Community Hub
- Unlocking the Power of Regex in SQL Server - Azure SQL Devs’ Corner
- Announcing the General Availability (GA) of JSON data type and JSON aggregates | Microsoft Community Hub
- Announcing the Public Preview of JSON index in SQL Server 2025 | Microsoft Community Hub
- ZSTD compression in SQL Server 2025 | Microsoft Community Hub
- MSSQL Extension for VS Code: GitHub Copilot Preview + UI GA
- MSSQL Extension for VS Code: Introducing Schema Compare (Preview) - Azure SQL Devs’ Corner
- SQL Server Management Studio (SSMS) 21 is now generally available (GA) | Microsoft Community Hub
- Copilot in SSMS preview
- Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub
- Visual Studio 2022 Release Notes | Microsoft Learn
- Free SQL Managed Instance offer is now generally available
- Avoid T-SQL anti-patterns with the free T-SQL analysis tool - Azure SQL Devs’ Corner