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

Video Description

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 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: Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔴 To watch other MVP Edition episodes, see our playlist: https://aka.ms/dataexposedmvps To check out even more Data Exposed episodes, see our playlist: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer