Note:  I decided not to add all the links like I did in Part 1. That took a crazy amount of time and I’m not feelin it while traveling. It’s easy enough to log on to the PASS Data Community Summit 2022 website and check out the info or go old school and google it. I will let this fall in the mom lesson #124 of “don’t do for them what they can do for themselves”. Call it tough love.

PASS Data Community Summit Part 2: The Thursday/Friday edition.

Originally I thought I was going to post this over the weekend, but we had some unexpected trip-ups of a environment promotion I had to tend to: Ahhh –  fun times of trying to get things done under the wire before you leave for a trip. You know not to do anything major, but the small emergencies can get ya too. And of course everyone wants THEIR thing done before you leave. Especially before the holidays kick in. I totally get it.

So while I’m sitting in the Chicago airport waiting for my [now] delayed flight, I wanted to get Part 2 in real quick. Well, at least before my battery goes kahpoot.  I wrote part of this at the airport, but had to finish after a day of hilarity ensued. This is a somewhat shortened version

Thursday: November 17th, 2022

Thursday I decided to do a little different than Wednesday. I’ll probably be exhausted from late travel on Monday catching up with me and then intense focus on Tuesday and Wednesday and thought shorter sessions may more be inline. Again, this could and will probably change by Thursday – I make no guarantees.

Breakfast event: Breakfast with the Microsoft team: SQL Futures and Strategy. You had to sign up for this event separately, and thankfully I did a few weeks back because I saw today that the registration is now closed. This is an early morning event, but since it won’t require much focus I think I’ll be ok.

8:00 AM – 9:15 AM – Keynote: Doing More with Less: The Challenges Ahead for Every Data Professional – Steve Jones, Jakub Lamik, Kathi Kellenberger, David Bick, and Arneh Eskandari

This should be an interesting keynote as it is always on my mind. Knowing what to plane for is pretty essential in our field.

9:30 AM – 10:00 AM: Architecture Options in Data Warehousing and Modeling – Leslie Weed

Alternate/On-demand options:

• Implementing Intelligent Edge Solutions with Azure IoT & AI – Mihail Mateev  (9:30 AM – 10:45 AM)
• Storytelling with Data in Power BI – Pragati Jain  (9:45 AM – 10:45 AM)
• Database DevOps in Azure: Prepare for Ludicrous Speed! – Pete Benbow  (9:30 AM – 10:45 AM)
• How to Maintain the Same Level of utilities in Cloud Deployments – Denny Cherry (9:30 AM – 10:45 AM)
• Use your Baseline to find Problem Queries – Allen White
• Moving an Availability Group to a New Environment without Downtime – Steve Hall (9:30 AM – 10:45 AM)
• Securing and Protecting Content in Power BI: Practical Tips – Melissa Coates  (9:30 AM – 12:30 PM)

10:15 AM – 10:45 AM: Getting Started with Database DevOps – Liz Baron

Alternate/On-demand options:

• How to Use PowerShell to Get Data From Any Power BI REST API – Gilbert Quevauvilliers
• Azure Data Factory Essentials for SSIS Developers – Tim Mitchell

11:15 Am – 11:45 AM: Modern Data Warehousing with Azure Synapse Analytics – Ginger Grant

Alternate/On-demand options:

• Monitoring SQL Server at No Cost – Danilo Dominici (11:30 AM – 12:30 PM)
• Performance Tuning for Azure Cosmos DB – Hasan Savran (11:15 AM – 12:30 PM)
• Women in Tech: Becoming the Ally – Deepthi Goguri (11:15 AM – 12:30 PM)
• Getting Started with Database Source Control – Kathi Kellenberger
• Kusto Query Language – The Next Query Language You Need to Learn – Hamish Watson (11:15 AM – 12:30 PM)
• Stabilize Query Performance without Changing Code – Erin Stellato
• Durable (non-technical) Strategies for Success with Analytics – Tom Huguelet (11:15 AM – 12:30 PM)
• Useful Insights into Azure Synapse Data Explorer –  Warren Rocchi (11:15 AM – 12:30 PM)
• Azure Data Factory ABCs – David Alzamendi (11:15 AM – 12:30 PM)

12:00 PM – 12:30 PM: Implementing a Datalake House in Azure Databricks – Jeff Renz

Alternate/On-demand options:

• Getting Started With Unit Testing in tSQLt – Sebastian Meine

12:30 PM – 2:15 PM: Women as Tech Leads – Tackling the Challenges – Shabnam Watson, Jen McCown, Anna Hoffman, Blythe Morrow, Leslie Andrews

2:30 PM – 3: 45 PM: I’m still undecided here. 2 great ones on completely different topics.

• Keeping your data fresh in Power BI – Patrick LeBlanc, Adam Saxton
• Data Driven Disease Damage Control – Helge Rege Gardsvoll

Alternate/On-demand options:

• Automate Development Database Refresh from Production – Andre Quitta (2:30 PM – 3:00 PM)
• Finding the Right Data Types – Kevin Wilkie
• Using Power BI with Lots of Data – Paul Turley
• Fold on Tight – What is a Query Folding and Why Should I Care? Nikola Ilic (3:30 PM – 4:00 PM)
• Getting Started Building Data Solutions on Azure – Hugo Barona (3:30 PM – 4:00 PM)
• Practical Data Engineering with Spark – John Miner (2:30 PM – 3:30 PM)
• Unit Testing T-SQL – Jay Robinson
• Coaching for Managers: An Introduction – Eduardo Gregorio
• Practical Experiences from Working with Synapse – Mathias Halkjær and Brian Bønk
• Choosing the Azure SQL DB Tier: Tales from the Trenches – Reitse Eskens  (2:30 PM – 3:00 PM)
• Better Data Governance with Purview – Kelly Broekstra  (2:30 PM – 3:30 PM)
• Better Together: Power BI and Azure Synapse Analytics – Bradley Schacht
• VLTs: Very Large Tables – Problems, Options, THE Solution! – Kimberly Tripp

4:15 PM – 5:30 PM: Deploy a Self-Service Analytics Sandbox in Azure Synapse Analytics – Oscar Zamora and Tahir Abdullah

Alternate/On-demand options:

• How to use Data Lineage in Azure Purview? – Erwin de Kreuk
• How to Tune a Multi-Terabyte Database for Optimum Performance – Jeff Taylor
• Migrating your Data to the Cloud? Look Out! Here’s What you Need to Know – Emanuele Meazzo
• Kusto Query Language – The Next Query Language You Need to Learn –  Hamish Watson (4:15 PM – 5:15 PM)
• From SQL Server to Cosmos DB in 75-Minutes – Martin Catherall

Friday November 18th, 2022

Sadly on Friday, my flight time was changed to 2 hours earlier. Meaning that I’ll really only have morning to grab some sessions. If I leave by about noon, then I should be ok – so after the keynote and first session, I’ll probably be only attending the hall-sessions I keep hearing about. A layover in Phoenix may be allow me an online session – but I also may be completely done by then.

8:00 AM – 9:15 AM Keynote: 30+ Years of Innovation: How Do We Keep Up with Technology? – Kimberly Tripp

Another pretty on-point keynote on a subject that I continue to hear people talk about through the years.

9:30 AM – 10:45 AM: Building a Regret-free Foundation for your Data Factory – Meagan Longoria

Alternate/On-demand options:

• GitHub + You + Microsoft Docs – William Assaf
• Power Up Your Data Warehouse with Pre-ETL Processing – Erin Dempster
• Power BI Composite and Hybrid Models – Alex Whittles
• Query Shaping – Advanced Query Tuning – Edward Haynes   9:30 AM – 12:30 PM
• Power BI: From Self-Service to Enterprise – Just Blindbæk  10:15 AM – 10:45 AM
• Data Transformation Magic with Power Query – Jackie Kiadii
• SSDT Methodologies for SQL Server DevOps – Eitan Blumin  9:45 AM – 10:45 AM
• Intro to SQL Server Tools – Deborah Melkin  10:15 AM – 10:45 AM
• Performance Monitoring, Tuning and Scaling Azure SQL Workloads – Deepthi Goguri and Surbhi Pokharna
• Introduction to SQL Audit and Audit Reports – Daniel Maenle 9:30 AM – 10:00 AM

The rest of these will have to be on-demand options for me, but I still wanted to list them since they were are part of my favorites group.

On-demand:

• Tracking History: Temporal Tables vs Ledger Tables – Ed Leighton-Dick 11:15 AM – 11:45 AM
• How to Fix a Report I didn’t Build – An Ugly Baby Story  – Reid Havens 11:15 AM – 12:30 PM
• Improve Performance by Automating the Query Store – Chad Crawford 11:15 AM – 12:30 PM
• Analyzing Azure Monitor Log Data for Azure SQL Database – Taiob Ali 11:15 AM – 12:30 PM
• Creating a career portfolio using GitHub – Joshua Higginbotham  11:15 AM – 12:30 PM
• Azure Synapse Analytics and the Power of Datamarts – Joanna Podgoetsky 11:15 AM – 12:30 PM
• Enterprise Semantic Models in Power BI Premium  – Christain Wade and Kay Unkroth 11:15 AM – 12:30 PM
• Power BI – Discover DAX Fundamentals Through Common Mistakes – Fowmy Abdulmuttalib – 11:30 AM – 12:30 PM
• Pro Tools for Performance Tuning: Baselines, Monitoring and Workload Tests – Martin Guth  11:30 AM – 12:30 PM
• Can Microsoft Purview Answer All your Data Governance Needs – Angela Henry 12:00 PM – 12:30 PM
• How to Run a Successful Proof of Concept (PoC) –John Martin   2:30 PM – 3:45 PM
• Data Lakehouse, Data Mesh, and Data Fabric (data architecture soup!) – James Serra 2:30 PM – 3:45 PM
• Handle Azure SQL Auditing With Ease – Josephine Bush 2:30 PM – 3:30 PM
• Architecting for High Performance SQL Server on Virtual Machines – Anthony Nocentino   2:30 PM – 3:00 PM
• Testing your Data Factory – Benjamin Kettner and Frank Geisler 2:30 PM – 3:45 PM
• The Autistic Data Professional’s Guide to the Job Search – Chris Voss  2:30 PM – 3:45 PM
• Migrate Your SSIS Skills to Azure Data Factory – Koen Verbeeck  3:30 PM – 4:00 PM
• When to Stop Tuning a Query – Milos Radivojevic 4:15 PM – 5:15 PM
• The Dream Team: Synapse Analytics Serverless SQL Pools and Pipelines – Andy Cutler 4:15 PM – 5:15 PM
• Power BI Model Development Best Practices in a Team – Mathias Thierbach 4:15 PM – 5:30 PM
• Performance Mythbusters – Paul Randal 4:15 PM – 5:30 PM

That’s it. That’s the full shabang. If you are at Summit and see me – feel free to say hello! I’ll be the short lady that looks kinda mom like.