Post Content
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
✅ Chapters:
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/intelligent-query-processing-details#optimized-halloween-protection
Batch mode optimizations for built-in functions – https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2025#developer
Math functions – https://learn.microsoft.com/sql/t-sql/functions/mathematical-functions-transact-sql
DATETRUNC – https://learn.microsoft.com/sql/t-sql/functions/datetrunc-transact-sql
Optimized sp_executesql – https://learn.microsoft.com/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sq#optimized_sp_executesql
📌 Let’s connect:
Twitter – Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter – AzureSQL, https://aka.ms/azuresqltw
🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #SQL #LearnSQL Read More Microsoft Developer
