New T-SQL Enhancements in SQL Server 2022 | Data Exposed: MVP Edition

From the creator

Not yet up to speed on all the new T-SQL Enhancements available in SQL Server 2022 and Azure SQL Database? Want to learn nine new capabilities in just nine minutes? Join MVP Lenni Lobel on Data Exposed to learn about DATE_BUCKET, DATETRUNC, LEAST and GREATEST, STRING_SPLIT ordinal, GENERATE_SERIES, TRIM improvements, IS DISTINCT FROM, Windowing improvements, and bit functions… each with a live demo! 0:00 Introduction 1:15 T-SQL Enhancements 1:30 DATE_BUCKET 3:52 DATETRUNC 4:51 LEAST and GREATEST 5:55 STRING_SPLIT 7:02 GENERATE_SERIES 8:40 TRIM, LTRIM, RTRIM, 9:10 IS [NOT] DISTINCT FROM 10:09 Windowing enhancements 12:36 Bit Functions ✔️ Resources: Code: https://github.com/lennilobel/sql2022-workshop-hol/tree/main/Code/1.%20T-SQL%20Enhancements About Leonard Lobel: Leonard Lobel (Microsoft MVP, Data Platform) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a Microsoft consultant at Ernst & Young. Programming since 1979, Lenni is a master craftsman in the field of software engineering and development. He has been architecting and building systems for over forty years, and maintains the highest level of quality and dedication. His experience spans multiple industries, including publishing, finance, retail, healthcare, and e-commerce. Recognized by Microsoft for his technical expertise and leadership qualities, Lenni has been a Data Platform MVP

Published 2024-05-29 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.