Past Meetup

Thomas Grohser: Half-Day Training - 42 TSQL Functions.

This Meetup is past

41 people went

Price: $25.00 /per person
Location image of event venue


There will be two events on November 14th, both are tought by Thomas Grohser.

1. Half-day training: 42 TSQL Functions.
$25 fee to cover the cost of food and drinks.

2. Free NESQL meeting: You should use Column Store but Avoid the Mistakes I made...

12 PM - 1 PM Lunch and networking
1 PM - 5 PM Half-Day Training session
6 PM - 8: 30 PM Free NESQL meeting (register at

42 TSQL Functions Abstract:
This afternoon session will be about 42 of the built in functions SQL Server’s TSQL language has to offer, they will be interesting for both database developers and administrators. As with many of my talks this one originated from a real world case. For each function I am going to explain what it is used for, how to use it and demonstrate with a few examples. We start with functions making SQL Server metadata handling easier, transition into data conversion, security and string manipulation and flow control. The grand finale will show the practical use of aggregation and windowing functions in queries.


Thomas Grohser for the past 25+ years has spent most of his time exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical and financial services industries. His primary focus is to architect, plan, build and operate reliable, highly available, secure and scalable infrastructures for SQL Server. Over the years he managed thousands of SQL Server instances processing trillions of rows taking up petabytes of storage. Thomas is a Microsoft Data Platform MVP for 9 years and speaks at regularly at conferences, SQL Saturdays and user groups for 11+ years.