SQL Server 2025 introduces a set of focused performance enhancements aimed at improving execution speed, concurrency, and resource efficiency. In this session, we’ll dive into the latest capabilities in the Database Engine, including Intelligent Query Processing improvements (adaptive joins, memory grant feedback), better TempDB scalability, and optimizations for columnstore indexes and Batch Mode on Rowstore. We’ll also look at support for persistent memory and how these changes impact both OLTP and analytical workloads. This session is designed for DBAs and developers who want to understand not just what’s new, but how to apply these features effectively in production scenarios.