Guy and Eitan discuss Stephen Planck's blog post "Five SQL Server 2025 Enhancements DBAs Will Notice", and add some of their own insights.

Relevant links:

• Five SQL Server 2025 Enhancements DBAs Will Notice - SQL Table Talk
• Configure a flexible automatic failover policy for an availability group - SQL Server Always On | Microsoft Learn
• Accelerated Database Recovery (ADR) in TempDB | Microsoft Learn
• Enable and Run tempdb on tmpfs for SQL Server 2025 Preview on Linux - SQL Server | Microsoft Learn
• Optimized Locking - SQL Server | Microsoft Learn
• Standard Developer edition in SQL Server 2025 | Microsoft Learn
• ABORT_QUERY_EXECUTION query hint - public preview | Microsoft Community Hub

Many 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

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:

• Importing and exporting SQL Server databases using native backup and restore - Amazon Relational Database Service
• Learn about Amazon RDS maintenance window | AWS re:Post
• LLM Structured Output from Azure SQL Explained - Azure SQL Devs’ Corner
• Create a Transact-SQL snapshot backup - SQL Server | Microsoft Learn