42 TSQL Functions
Proposed session for SQLBits 2026TL; 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.
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.
Speakers
Thomas Grohser's other proposed sessions for 2026
Backup and Restore / Yes it's still the most important thing - 2026
Backup and Restore / Yes it's still the most important thing Part 2 - 2026
Managing SQL Server Error Log - 2026
Scaling Clustered Column Store Indexes - 2026
Shaving off Micros Seconds - 2026
SQL Server Licensing 101 - 2026