PASSMN Meeting 2023-04-18 (Virtual Meeting Only)

Important Note: This meeting is online only and will not be held at the Microsoft Technology Center

Agenda:
📅 Tuesday, April 18, 2023 📅
🕜 3:30-4:00 Kickoff / Announcements
🕜 4:00-5:00 Dennes Torres - SQL Server 2022: Parameter Sensitive Plan Optimization
🕜 5:00-5:10 Break
🕜 5:10-6:10 Jeff Iannucci - Faster Transactions: Query Tuning for Data Manipulation
🕜 6:10-6:15 Closing

Sessions

🕜 4:00 pm
⭐️SQL Server 2022: Parameter Sensitive Plan Optimization
🙂 Dennes Torres
SQL Server 2022 brings a very interesting new feature to solve parameter sniffing: The query plan cache can hold multiple query plans for each query
Let's discover how this feature works

🕜 5:10 pm
⭐️ Faster Transactions: Query Tuning for Data Manipulation
🙂 Jeff Iannucci
Your server has dozens of CPUs, terabytes of RAM, and uses solid-state drives…and yet your UPDATE statement still takes hours. Why?
In this demo-filled session, we examine common pitfalls for any SQL Server professional who manipulates large sets of data with INSERT, UPDATE, and DELETE statements, and explore techniques you can use to improve performance.

Speakers

🙂 Dennes Torres
⚡️ Azure Data Engineer at DTower Software
Dennes is a DBA and Data Platform MVP living in Malta who loves SQL Server and software development and has more than 20 years of experience. He moved to Malta after more than 10 years leading devSQL PASS Chapter in Rio de Janeiro and now is a member of the leadership team of MMDPUG PASS Chapter in Malta organizing meetings, events, and webcasts about SQL Server. He is an MCT, MCSE in Data Platforms and BI, with more titles in software development. He can be found working for DTower Software and speaking in SQL Saturdays around Europe.
[dennes@bufaloinfo.com.br](mailto:dennes@bufaloinfo.com.br)
linkedin.com/in/dennestorres/
@dennes
dennestorres.com (blog)
dtowersoftware.com (company)
Dennes Torres's Speaker Profile
(public speaker profile)

🙂 Jeff Iannucci
⚡️ Data Engineer
Jeff Iannucci is a Senior Consultant with Straight Path Solutions. With over 20 years of experience with SQL Server development and administration, he enjoys sharing what he's learned by speaking, blogging, and creating video content. He is a speaker at PASS Data Community Summit 2022, a content author for Pluralsight, and author of the upcoming book "Learn SQL in a Month of Lunches".
[jeff_iannucci@hotmail.com](mailto:jeff_iannucci@hotmail.com)
@desertdba
linkedin.com/in/jeff-iannucci/
desertdba.com (blog)
Jeff Iannucci's Speaker Profile
(public speaker profile)