SQL Server 2025: Engine performance and scale delighters | Data Exposed

From the creator

****Update 2025-09-02: During public preview of SQL Server 2025, we have identified a potential data integrity issue that might occur if optimized Halloween protection is enabled. While the probability of encountering this issue is very low, we take data integrity seriously. Therefore, we decided to temporarily remove optimized Halloween protection from SQL Server 2025, starting with the RC0 release. The fix for this issue is in progress. In the coming months, we plan to make optimized Halloween protection available in Azure SQL. Enabling optimized Halloween protection in a future SQL Server 2025 update is under consideration as well.**** In this episode of Data Exposed, we'll focus on the performance and scale enhancements of the SQL Server 2025 engine. It delves into the intricacies of query processing and storage engine improvements, highlighting key features and optimizations that contribute to the overall efficiency and scalability of the SQL Server. Out of the 15 features that we have in SQL Server 2025, this session will focus on three: Optimized Halloween Protection Batch mode optimizations for built-in functions Optimized sp_executesql 0:00 Introduction 1:16 Architecture 1:55 Engine delighters and features 3:50 Optimized Halloween Protection Demo 7:35 Batch mode optimizations for built-in functions 11:05 Optimized sp_executesql 17:15 Getting started ✅ Resources: Optimized Halloween Protection - https://learn.microsoft.com/sql/relational-databases/performance/in

Published 2025-06-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.