Build modern data applications with SQL Server 2025 | Data Exposed

From the creator

In this episode of Data Exposed, we dive into the powerful new T-SQL capabilities introduced in SQL Server 2025. From JSON type, Index and built-in REGEX functions to fuzzy string matching and enhanced string and date operations, these features will help simplify complex data manipulation and pattern matching scenarios. Join us as we explore how these additions/ enhancements —like the JSON data type, REGEX functions, UNISTR, || operator, DATEADD, CURRENT_DATE, SUBSTRING, PRODUCT(), and BASE64 functions—empower developers and data professionals to write more expressive, efficient, and readable queries. 0:00 Introduction 1:15 JSON support - where we are today? 2:45 JSON type 3:12 Demo 6:50 Regex support 8:20 Regex functions 8:55 Demo 13:13 Fuzzy string matching 14:56 UNISTR and II Operator 15:30 DATEADD (BIGINT support) 15:56 CURRENT_DATE & SUBSTRING 16:23 PRODUCT () & BASE64 17:00 Getting started ✅ Resources: JSON – https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server Regex – https://aka.ms/sql-regex-blog https://learn.microsoft.com/en-us/sql/relational-databases/regular-expressions/overview UNISTR & ANSI SQL concatenation operator (||) – https://aka.ms/unistr-strconcat-blog https://learn.microsoft.com/en-us/sql/t-sql/functions/unistr-transact-sql https://learn.microsoft.com/en-us/sql/t-sql/language-elements/string-concatenation-pipes-transact-sql Fuzzy string-match- https://learn.microsoft.com/en-us/sql/relational-databases/fuzzy-string-matc

Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.