Data Modeling by Angela Henry & SQL Server 2022 & Azure SQL by Itzhak David

Session #1
Abstract
You want to analyze your data, but you are not sure where to start. If you are using any of the Microsoft BI stack of products, then you will need to start by modeling your data. In this session, we will talk about what data modeling is, explain why we should do it, and finally show you how to do it with a very simple example.

Speaker Bio
Angela is a Principal Consultant, living in High Point, NC, and loves what she does. She’s worked with all versions of SQL Server & worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect, and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she’s an avid US Masters Swimmer, Coach, Instructor, and Official.

Session #2 -SQL Server 2022 & Azure SQL DB Wait Statistics from zero to a hero! by Yitzhak David

Abstract
earn how the database engine processes a query and how to query wait statistics information through various SQL Server dynamic management views (DMVs). I will show you how Query Store (QS) create and gather metrics to build your own baselines. Next, I will talk about Wait Types, dives into specific waits, the causes, some examples, and resolutions. I will break down waits into categories by CPU, IO, backups, locks, latches, high-availability and disaster-recovery, preemptive, background and miscellaneous, and In-Memory OLTP. I will show you how QS can find it in minutes! This is a maximum demo session with minimum theory but it based on 25 years of experience and hundreds of lectures in tuning area including latest's version SQL Server 2022!

Speaker Bio
Yitzhak David 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 …