Build modern data applications with SQL Server 2025

Post Content

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.

Chapters:
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-match/overview
DATEADD – https://learn.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql
SUBSTRING – https://learn.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql
CURRENT_DATE – https://learn.microsoft.com/en-us/sql/t-sql/functions/current-date-transact-sql
PRODUCT() – https://learn.microsoft.com/en-us/sql/t-sql/functions/product-aggregate-transact-sql
BASE64 –
https://learn.microsoft.com/en-us/sql/t-sql/functions/base64-encode-transact-sql
https://learn.microsoft.com/en-us/sql/t-sql/functions/base64-decode-transact-sql

Let’s connect:
Twitter – Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter – AzureSQL, https://aka.ms/azuresqltw

Watch even more Data Exposed episodes: 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