This session will introduce you to the most significant enhancements and improvements in SQL Server 2022, and, as the title suggests, it will focus on features from the Intelligent Query Processing package.

We'll look at new features from that package (CE & DOP Feedback, PSP Optimization and Optimized Plan Forcing), improvements to the existing ones (MGF Percentile & Persistence), but we'll also look at IQP best practices and discuss whether we still need to tune our queries or in the very near future this task will be taken over by SQL Server itself, enhanced with various AI tools and services.

The session is intended as an open discussion, exchange of opinions, skepticism, and expectations, and it would be nice if attendees take an active part in it.