Virtual - New SQL Server 2022 commands - Mike Burek

Virtual On Line
Teams: https://aka.ms/AustinSQLJuly2022
Meeting opens: 5:50 pm for chatting
Presentation: 6:00 pm - 7:00 pm

Title: New SQL Server 2022 commands
Presenter: Mike Burek

Topic:
Look at the new features in SQL Server 2022 specifically related to T-SQL:

• Updating statistics to add AUTO_DROP option.
• Updating FIRST_VALUE and LAST_VALUE to support IGNORE NULLS and RESPECT NULLS.
• Some new JSON functions.
• New named windows.
• Pausing and resuming an ALTER TABLE ADD CONSTRAINT.
• New commands GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET, GENERATE_SERIES.