New SQL Server 2022 commands

Abstract:

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.

Speakers:

Mike Burek

16 Recordings

Mike Burek has worked with SQL Server for 25 years. Throughout his career, he has often worked with marketing data. From this, he has experience with various tools for ETL as the industry and programming has changed and matured over time. On the SQL Server side, he has held senior positions in database administration and database programming, focusing on optimization, automation, and increasing the value of data. Outside of work, he also runs the Austin SQL Server user group and makes a big effort to train others to help them grow in their careers.

Recorded At:

Capitol Area Central Texas Users of SQL Server 87 Recordings

Recorded on:

Jul 19, 2022

More Info:

https://www.meetup.com/austin-sql-server-user-group/events/spswrsydckbzb/