22-25 April 2026

42 TSQL Functions

Proposed session for SQLBits 2026

TL; DR

Demoing 42 TSQL functions that will make your DBA and/or developer life easier. This session is 99% demo and sharing code.

Session Details

SQL Server has hundreds of built-in functions that can make your day to work easier and simplify the code in your procedures and scripts. This session will pick 42 of the lesser known one and show how to use them with practical and easy to understand examples. This session is all demo and no slides.
Both DBA and Developers will learn something in this session.
We will cover functions that are in SQL Server since version 4.21 as well as some added in SQL 2025.
This session has just one slide with the word "Demo" on it.

3 things you'll get out of this session

Learn about TSQL functions that are not well known. Larn how to make your life easier with built in functions. See practical examples how and why to use these built in functions.