SQL Server 2022 adds new syntax, T-SQL functions, and improvements to existing syntax. This session provides a walkthrough of these new and updated features, including:
• New filter predicates
• Approximate query processing functions
• Date manipulation functions
• Series generation
• New window function syntax
• Bit manipulation additions
• And more!
This is a fast-paced, demo-filled parade of new features that will save time, resources and make for cleaner and happier code!
A discussion of compatibility levels and upgrading SQL Server will accompany the demonstration of new features, ensuring that we are ready for the newest features in current and future versions of SQL Server.