Choose one of the following seminars we have for you:

Alberto Ferrari - Advanced DAX

If you already know and use the DAX, in this precon, Alberto Ferrari will help you to move on the next level.

For more details and registrations please click here.

Miloš Radivojević - Intelligent Query Processing in SQL Server - Lessons Learned from Production

Introduced with SQL Server 2017, further developed and significantly extended in both SQL Server 2019 and 2022, the Intelligent Query Processing (IQP) is one of the most important investments Microsoft has made in SQL Server. It contains new functionalities and enhancements that can improve the performance of existing workloads (both OLTP and OLAP) without changing the code.

For more details and registrations please click here.

Dejan Sarka - SQL Database Internals, Query Optimization, and Transactions

Even the best logical model can’t help when the physical implementation is bad. Therefore, it is important to know how SQL Server, Azure SQL Database, and partially also Azure Synapse Analytics, store data in row and columnar format and how the engines access this data. You will learn about heaps, balanced trees, and columnar indexes. In addition, this course introduces query optimization for both, transactional and analytical queries.

For more details and registrations please click here.