https://www.mememaker.net/static/images/memes/4791280.jpg |
I mean...NOVEMBER!
https://tinyurl.com/33hezsje |
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg |
https://s3.memeshappen.com/memes/still-scared--you-should-be-meme-31789.jpg |
Tuesday brought the pre-con I was most excited for (sorry Ed) - the SQL Server 2022 Workshop presented by Bob Ward (@bobwardms) and an all-star team of Microsoft team members. Bob's presentations are always "brain melting" and today's did not disappoint.
The main focus of the workshop is what Bob called the SQL 2022 "Wheel of Power" - five grouping of cool new features and improvements in the new product:
courtesy Bob Ward |
The presentation ran through a wide variety of items, including:
- Linking Azure SQL Managed Instance to your traditional SQL Server instance for DR or to migrate to MI
- Parameter Sensitive Plan Optimization with multiple query plans for a single stored procedure
- Cardinality Estimation Feedback that leverages Query Store to determine which Cardinality Estimator is better for your high impact queries
- Degree of Parallelism Feedback which similarly uses Query Store to discern if a lower DoP would be "good enough" for your query at lesser CPU cost
- Contained Availability Groups to duplicate instance level objects (including SQL Agent jobs!) as part of the AG
- Ledger to track data changes to document attempts to fraudulently change your data
- Improved T-SQL
- Major Intelligent Query Processing enhancements
...and so much more!
https://i.imgflip.com/4710a3.jpg |
The evening closed with the Welcome Reception, which as always was a fun opportunity to reconnect with #sqlfamily that I haven't seen since before the pandemic started.
I am looking forward to the rest of the week - it's going to be great!
--
An aside - this is my first blog post in over a year; I haven't written much since COVID and have not presented at all - I hope to correct both of these going forward, although opportunities for in-person speaking are still greatly diminished after the demise of PASS SQL Saturdays; there are the "new" SQL Saturdays underwritten by the new covering organization, but there simply aren't that many events yet.
Thanks for reading everyone and hope to see you soon!