Session #1 – Intelligent Query Processing (IQP) by Ed Pollack
Abstract
Intelligent Query Processing (IQP) allows SQL Server to make dynamic, smarter decisions at runtime when processing queries. Moreover, these features are enabled by default when the SQL Server is upgraded to a compatible version! Even better, each version of SQL Server adds more components to this suite of performance enhancements.
SQL Server 2022 debuted many new features to Intelligent Query Processing, including:
Cardinality Estimation Feedback
Degree of Parallelism Feedback
Approximate Percentile Calculations
Feedback Persistence
Parameter Sensitive Plan Optimization
Optimization Replay
This session will dive into each new feature, how to use it, and demonstrate how it works. This is intended to provide the information needed to take full advantage of IQP when adopting SQL Server 2022.
As SQL Server evolves, the need to incorporate runtime metrics into execution plans will continue to grow. Taking advantage of Intelligent Query Processing in your current SQL Server versions will allow for easy adoption of new query processing enhancements in future versions.
Speaker Bio
Ed Pollack is a Microsoft Data Platform MVP passionate about learning how the Microsoft Data Platform works and sharing that knowledge with the community. His experiences in data architecture, database design, performance optimization, and data security are motivation for public speaking, writing, coding, and other community activities. Ed has spoken at SQL Saturday events, SQL Bits, PASS Summit, EightKB, and other regional and international events. Ed is organizing the Capital Area SQL Server Group and SQL Saturday Albany and is a co-organizer of SQL Saturday New York City and Future Data Driven. He has published several books, including “Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server”, “Expert Performance Indexing in Azure SQL and SQL Server 2022”, and “Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads”. Ed is also an active contributor to SimpleTalk content. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
Session #2 – Database Corruption – A Beginner’s Guide by Jeff Mlakar
Abstract
Every database professional should know about database corruption because it can be a resume-generating event. A corrupt database can impact system stability, slow performance, return incorrect data, and cause downtime. This beginner-level session will provide you with the essential knowledge and tools to identify, diagnose, and resolve database corruption effectively. In this session, we’ll cover the basics of database corruption, including its causes, symptoms, and methods for diagnosis. You’ll learn how to use built-in tools to detect corruption, troubleshoot common issues, and apply remediation techniques. Lastly, we explore some live demos where you will see firsthand how to intentionally corrupt a database, diagnose the problem, and restore it to a healthy state.
Speaker Bio
Jeff Mlakar is a seasoned database engineering professional with a deep focus on Microsoft SQL Server, having worked with every version since 2000. Throughout his career, Jeff has worn many hats: DBA, database developer, manager, and data analytics expert. His broad industry experience spans health insurance, investment banking, cybersecurity, big tech, and consulting, where he has led key initiatives to optimize database performance and drive business results. Currently, Jeff is a Senior Software Engineer on the Marketing Cloud Database Services Engineering team at Salesforce. He is passionate about data security, privacy, and ensuring databases are both high-performing and secure. In addition to his technical work, Jeff enjoys sharing his experiences through speaking engagements and blogging. Outside of work, he enjoys reading, chess, golf, and exploring the outdoors.
