Note: Sessions listed here are ones I am specifically interested in for one reason or another at the time of this writing. It’s a mix of one part stuff I think will be helpful to my company, one part things I’m SUPER interested in, and one part sitting in sessions with a group of speakers that I know and want to hear. Sessions that were in-person had a higher priority when I had to choose between different sessions, which is perhaps unfair, but with traveling I want to be in-person as much as possible. Sessions not listed have zero baring on their quality – there are simply only so many hours in a day – even with the on-demand option.
Inspired by Louis Davidson‘s post: The PASS Data Community Sessions I am Most Excited For, I decided to write my own. Because all that time I’ve obsessed spent looking at the schedule should be put to some use AND I’m hoping it will help me get over my writers block. That said, after looking at the schedule I created with the Favorites I tagged, I realized that this post would probably be best in multi-parts. Part 1 will focus on Tuesday and Wednesday activities.

There is a lot of sessions in this post, but basically I’m trying to plan for next week and the next 12 months. Also with 489 sessions, obviously my choice can and will change over time. But I like to have a plan. LIKE REALLY REALLY like to have a plan. An initial one and one I can pivot to quickly if needed.
I’m not going to rehash what PASS DCS 2022 is, you can get all the info here: https://passdatacommunitysummit.com/. If you can’t attend in-person for any reason but still want to attend – there is a great online option and an option for on-demand recordings. I attended online last year (which was the only option) and was pretty impressed with the ability to interact with others, even outside the sessions. This year I will be in Seattle for the event, (thanks awesome company that I work for!) but they also purchased the 12 month on-demand recordings option. That way I don’t have to always choose between sessions: just which ones I see during the summit. (Note: links to sessions probably require you register for the site. You are on your own for that.)
I’m guessing that a lot of people choose the All-In-One Bundle, but I did a more ala-carte registration. 3-day conference + One Day Pre-Con + On-demand recordings for 12 months. My company saved a whole 7 dollars going this route – but I really wanted the on-demand recordings and I wasn’t sure how great I’d be at pre-cons. <insert record scratch>
I’ll be honest – pre-cons kinda scare me. I’m neuro-diverse and 8 hours is a long time to hold my attention and I get big anxiety about it. That said, I made it through grad school with a 3.93 (dangit worldwide pandemic) learning Python/R, analytics, statistics, AI, etc., so I realize that it may be all in my head. [so’s everything 1:49]. I signed up for one pre-con, and if that goes well, than I may go for 2 next time.
Tuesday
Choosing between Pre-cons was pretty difficult. Like SUPER DUPER difficult. Ones that particularly interested me were:
- Race + Gender Equity Toolkit – Cindy Gross
- The Hitchhiker’s Guide to Adopting Power BI in Your Organization – Matthew Roche and Melissa Coates
- Azure Infrastructure – Denny Cherry
- Become a Hybrid Architect – Anthony Nocentino and Ben Weissman.
Ultimately I went with Denny’s Azure Infrastructure pre-con as it aligns best with key initiatives for my company. I’m on a small Cloud CoE team and we are planning some complicated moves to the cloud; I want to make sure I have my ducks in row – particularly with best practices. I’ve been privileged to see many of Denny’s presentations back when I was an organizer for SQL Sat in Atlanta, and I’m super excited to get to attend one of his pre-cons. Also, I’m studying for several certification exams (which one depends on the day), and this will reinforce topics that may be outside some of my current experience.
Just by happenstance, I have also signed up for Denny’s PASS Karaoke Party 2022. I’ve only been to Karaoke once in my life, and even then I was just a backup dancer (if you can really even be a backup dancer to Gangsta’s Paradise“), so this should be interesting. Truth be told, haven’t been out-out since about 4 years ago, so I’m game. Just don’t expect me to sing or stay out too late (I’ve got a big next day!)
Wednesday
Here is where it gets super complicated. Mostly because I keep changing my mind. Some sessions I initially planed on, I saw later were online and I went back and changed them for in-person sessions. I have some internal conflict doing this for multiple reasons (another post for another day) , and I may go and change things 10x by Wednesday (or there may be times that my “overwhelmedness” kicks in), so nothing is really set in stone.
Luckily I purchased the 12 month on-demand option (I get nothing for writing this in case you are wondering), thus I have a pretty sizeable list of alternates. For any of the times listed below, you will sometimes see a different time listed in the alternates section. This is because the session has a slightly different time than the original. I will spare you the different colored highlights in my original OneNote doc, because I don’t need to expose all the crazy.
Drum role please….Here is my current schedule.
8:00 AM – 9:15 AM: Transform your Data Estate with Microsoft’s Intelligent Data Platform. Keynote – Rohan Kumar
Keynotes are always good for “big picture” info and this one is right in line with my company’s needs: integrating databases, analytics, and governance.
9:30 AM – 10:45 AM: Confession – I still haven’t made up my mind on this one yet. Here are my 2 main choices. I have some experience in both, but I feel like I need a reset.
- Introduction to Data Factory – Andy Leonard
- DAX Demystified: Using the Lego Blocks Approach –
Avi Singh
Alternate/on-demand options
- Intelligent Data through Data Intelligence – Chris Unwin
- To Be a Data Engineer – Kevin Feasel
- (9:30 AM – 10:00 AM)
- Designing a Modern Data Platform – Jean Joseph (10:15 AM – 10:45 AM)
- Azure DevOps Pipelines for BI Deployments – Mike Diehl
- Business Benefits of Good Governance – Dr. Victoria Holt (9:30-10:00)
- Leverage Azure Synapse APIs to Accelerate Migration to Lakehouse – Abderrahmane Filali
11:15 AM – 12:30 PM: Tips and Tricks for Azure Migrations – Melody Zacharias
Alternate/On-demand options
- Data Ingestion – Practical Data Loading with Azure – Dustin Vannoy (11:15 AM – 11:45 AM)
- I Can’t Come to MI. MI will Come to Me. Arc-enabled SQL Managed Instance – Ben Weissman
- Getting started with Power BI Deployment Pipelines – Akshata Revankar
- Services and Tools to Migrate SQL Server to Azure – Warner Chaves (12:00-12:30PM)
- How to Architect a Personal Disaster Recovery Plan – Bob Pusateri
- Hybrid Tables in Power BI – Shabnam Watson (11:15-12:30)
- How to Write a Kickass Anything – Blythe Morrow
- High Availability Alphabet Soup – FCI, AG, DAG, & RSAG – Brandon Tucker
2:30 PM – 3:00 PM: Another one I still haven’t fully decided on. So sue me.
- Data Platform Best Practices – John Milner
- Building a Global Health Data Repository – Thomas Pagel (2:30-3:45)
Alternate/On-demand options
- The SQL Server Performance Tasting Menu – Erik Darling (2:30-3:45 PM)
- Machine Learning in Power BI – Leon Gordon
- Empowering Non-Technical BI End Users – Thomas Carnevale (2:30-3:45 PM)
- Databricks for the SQL Developer – Gerhard Brueckl (2:30-3:30 PM)
- Hello My Friends, Welcome to CosmosDB – Peter Shore (2:30-3:45PM)
- The Accidental Administrator’s Guide to Power BI – Michael Johnson (2:30-3:45)
- Working with OAuth 2.0 APIs in Azure Data Factory – Martin Schoombee (2:30-3:45)
- Baselining your SQL Server Workload for an Azure SQL Migration – Tim Radney
- Figuring Out Your Data Certification Path – Kevin Chant (2:30-3:45)
- The Ultimate Jigsaw – Architecting Azure Synapse Analytics – Heini Ilmarinen (2:30-3:45)
- Building Trust in your Data – Why Data Governance is the Key to Success – Johan Brattas and Marthe Moengen (2:30-3:45)
- Adaptive Leadership in Tech Workplaces – Cindy Gross (2:30-3:45)
3:15 PM – 3:45 PM: AMA with the Azure Data Community Advisory Board – Deborah Melkin, Rie Merritt, Monica Rathbun, Tillmann Eitelberg, Wolfgang Strasser, Gaston Cruz, and Javier Villegas
Alternate/On-demand options
- (See above time slot due to overlap of times)
- How to migrate SQL Server databases to Azure – Carlos Robies
4:15 PM – 5:30 PM: Lightning Talks 1 – Andy Yun, Blythe Morrow, David Bojsen, Meagan Longoria, John Morehouse, Randy Knight
Alternate/On-demand options
- Bringing DataOps to Power BI – John Kerski
- Topic Modeling Made Easy – Sanil Mhatre
- Time Intelligence in Power BI – Alberto Ferrari
- Serverless Infrastructure With Azure Containers – Magnus Ahlkvist
- Maximizing Performance with Memory-Optimized Table Variables – Jared Poche
- DataOps in Practice – Niels Magie and Vincent Goris
- Becoming a Master by Giving it All Away – Michael Wall
- The Fundamentals of Building a Lakehouse with Synapse – Luke Moloney
- Deep Dive in Upgrading SQLServer Cluster with Distributed AlwaysOn Group – Stacey Kyrylova
- Snapshot your CRM with Azure Synapse – Justin Mannhardt
- Prepping for Database DevOps: Resolving Key Blockers to Increase Agility – Andrew Pierce (4:00-4:30)
- Which SQL Tool is the RIGHT Tool for You? Jes Schultz, Drew Skwiers-Koballa, and Erin Stellato
- From Bare Metal to the SQL Managed Instance PaaS – Uros Milanovic (4:00-4:30)
Congrats! You’ve made it to the end of Part 1. Excuse me while I go do some *very serious computer schtuff* while listening to Coolio. Or something.
What are some of the favorite sessions you are looking forward to?
