Ola Hallengren

In this cutting-edge session, we will explore the latest performance improvements in Azure SQL Database, Azure SQL Managed Instance, and SQL Server 2025. We’ll dive into advancements in the optimizer (including intelligent query processing), locking, storage engine, availability groups, and more. I will share my experiences of the features from early preview testing and demonstrate these features in action. Finally, we’ll address the questions: What problems do these features solve, how do they work, and in which scenarios will you benefit from upgrading?

In this session we are going to look at the performance enhancements in SQL Server 2022. We will cover the most important enhancements in the optimizer (intelligent query processing), storage engine, Accelerated Database Recovery, availability groups, Query Store, stack dumps and some more. Which problems are the features solving? How are they doing it? I will share some real-world experiences of the features, from running SQL Server 2022 on mission-critical databases.

Come and see to some of our amazing speakers on one of these topics: 1. SQL and Databases: 2. Microsoft Fabric and Related Technologies: 3. Power BI and Data Visualization: 4. Azure and Cloud Technologies:

In this session we will look at how you can use Query Store for troubleshooting performance problems, and PowerBI and PowerPivot for analyzing and visualizing the data

Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.

In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.

In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.

How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.