PASSMN Monthly Meeting - 2022-11

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

Agenda:
📅 Tuesday, November 15, 2022 📅
🕜 3:30-4:00 Kickoff / Announcements
🕜 4:00-5:00 Query Store hints in SQL Server 2022 and parameter sniffing Problem (David Yitzhak)
🕜 5:00-5:10 Break
🕜 5:10-6:10 Modern Digital Experience Platform Analytics & Composable Enterprise (Boris Brodsky)
🕜 6:10-6:15 Closing

Sessions

🕜 4:00 pm
⭐️ QUERY STORE HINTS IN SQL SERVER 2022 AND PARAMETER SNIFFING PROBLEM
Query Store hints leverage Query Store to provide a method to shape query plans without changing application code. Now are available in SQL Server 2022
You already know you have parameter sniffing issues, and now you need to figure out how to fix it. Learn how we resolve bad Parameter Sniffing with Query Store in SQL 2016/17/19 and how it can be resolved more efficiently and easy with Query Store hints in SQL 2022, to reduce the blast radius with index changes, query tuning, and database-level settings. I will discuss whether you should use Query Store hint or Parameter sensitive plan optimization, also new in SQL 2020 and it is also based on Query Store.
🙂 Yitzhak David

🕜 5:10 pm
⭐️ MODERN DIGITAL EXPERIENCE PLATFORM ANALYTICS & COMPOSABLE ENTERPRISE
Composable Enterprise and Data Mesh concepts are on the rise, and there is an excellent reason for that. Organizations strive to deliver innovation quicker and adapt applications more dynamically - to do so efficiently, organizations need to rely on composable principles. A domain-driven analytical data architecture such as data mesh would supplement composable enterprise design principles to deliver modern data analytics solutions at scale. This session will showcase how to start applying Composable principles with Azure Data tools using Sitecore Composable DXP.
🙂 Boris Brodsky

Speakers

🙂 BORIS BRODSKY
⚡️ Director of App Dev/Sitecore Architect at Avanade
Boris is a Vison-Driven, highly innovative Digital Architect and Director of App Development at Avanade. He blends a combination of innovative technology platforms together with deep industry expertise to deliver immersive omnichannel experiences for his clients.
🔗 https://sessionize.com/boris-brodsky

🙂 YITZHAK DAVID
⚡️ DBA BDA POWER BI NOSQL K8s
David Yitzhak, Team leader of Big Data and Nosql databases
David Yitzhak has over 24 years of experience with SQL Server, Oracle, Sybase and PostgreSQL. He is an applicative & infrastructure DBA for relational and Nosql solutions (MongoDB, Redis), Hadoop CDH and Spark. David is a specialist in HA and DRP solutions, tuning, Machine learning , security, High Performance Computing, replication (Oracle & SQL Server), BI infrastructure and system engineering. David Yitzhak holds 3 Degrees from Technicon (Israel Institute of Technology): BSC Information System , MBA and ME (System engineering) and research associate in one of the enterprise Organization. He presents in Oracle open world 2010, Organize Oracle ILOUG for 3 years , SQL Server forums, Microsoft BI forums, Sqlsaturday 2016/17/18/19/20 , DATA SATURDAY , Power Camps , GroupBy Europe , Future Data Driven , Data Platforms GlobalHebrew, Code PaLOUsa 2021\2, Pass summit 2021 and more …
🔗 https://sessionize.com/itzik-david