
Abhiman Tiwari
Proposed Sessions for 2026
Modern apps need smarter text handling. This session dives into native Regex and Fuzzy Matching in Azure SQL, SQL DB in Fabric and SQL Server 2025—using REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, and fuzzy algorithms to validate, extract, cleanse, and handle typo‑tolerant scenarios. Includes real demos and performance tips.
JSON powers APIs, events, and configs. Azure SQL and SQL Server let you keep relational and JSON data together and work with payloads cleanly. Learn patterns to ingest, validate, query, transform, index, and model JSON—handling arrays, drift, and API sync with fast, maintainable T‑SQL.
Regex—one of the longest‑requested features in SQL—is now native and POSIX‑compliant in T‑SQL. This session shows how to migrate SQLCLR and app‑level regex into REGEXP functions, map validation/extraction patterns, handle edge cases, and apply performance tips to modernize text pipelines.
Text‑heavy workloads power search, sign‑ups, telemetry, and cleanup—and SQL Server 2025 brings huge upgrades to handle them. Learn how to replace app‑side regex and SQLCLR code with native REGEXP functions, apply Fuzzy Matching (Damerau–Levenshtein / Jaro‑Winkler) for dedupe and entity resolution, and use modern T‑SQL utilities like UNISTR, ANSI ||, SUBSTRING(), BASE64, PRODUCT(), and BIGINT‑safe DATEADD.