Guy and Eitan discuss security-related best practice scripts, and several interesting AI topics.

Relevant links:

• microsoft-dbas-club/Security and Compliance/Check_Passwords_SQL_Server_Generated.sql
• microsoft-dbas-club/Security and Compliance/Best Practice Checks/Invalid_owner_for_system_schema_role_or_database.sql
• microsoft-dbas-club/Security and Compliance/Windows Group Members.sql
• Microsoft Introduced AI Integrations for SQL Server. - Brent Ozar Unlimited®
• What’s New in MSSQL Extension for VS Code v1.34
• AI coding platform goes rogue during code freeze and deletes entire company database
• EitanBlumin/sqlcmd-gui: a simple graphical user interface based on SQLCMD for executing parameterized TSQL scripts

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