SQL Saturday – Redmond 2019

On February 9, 2019, I have the privileged of presenting at SQL Saturday in Redmond Washington, at the Microsoft campus. SQL Saturday is a free SQL Server event, so if you want to spend a day at Microsoft learning about SQL Server then this is for you.

TSQL User Defined Functions – Taboo or not?
Track: Enterprise Database Administration & Deployment
Level: Intermediate

For years user defined functions (UDFs) have been the nemesis of the DBA focused on performance, but they have been loved by developers due to their ability to help with code re-usability and abstraction of business rules.

SQL Server 2019 introduces techniques that help eliminate some of the performance issues related to UDFs. Learn how and in what cases scalar UDF In-lining can improve your performance reducing the historic performance problems with UDFs.

We will explore how in-lining improves performance, along with what you can do and what prevents in-lining of UDFs.

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!