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

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:

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 since 2011, serving the technical community worldwide as a consultant, trainer, author, and highly-rated speaker. He regularly presents at local usergroup meetups, VSLive, SQL PASS, and other industry conferences. Lenni has also written several MS Press books, including Programming Microsoft SQL Server 2012 and Windows Azure SQL Database Step-By-Step, and authored numerous Pluralsight courses on SQL Server and Azure Cosmos DB.

About MVPs:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer

[MeenakshiSundaraSanthosh]

Yes. Generate series and windowed functions enhancements are the real game changers

[tonoso]

I wish Microsoft would choose international standards of measurement to be default, and not US-specific start of the week 😂

8:40 Adding extra syntax instead of functions is one of the worst types of language design because it makes things less abstracted and reusable.
How about adding an implicit join of foreign keys, that would be the best and most useful feature ever. You could just access sub fields without specifying a join. It's insane that no SQL dialect has this.