SQL Saturday – Redmond 2019

Download PDF

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:

SteveStedman5
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!

2 Comments on “SQL Saturday – Redmond 2019

  1. Steve,

    Hello. Happened by this link via the TSqlJoinTypePoster.. I live not far from Redmond campus. Can’t seem to get a link to further details on building time etc. for tomorrows session. Might be able to fit it in…

    thx
    Andreas

  2. Update: Found the website etc. Registered. But Oh No, looks like canceled due to Snowmegedan! Anyway good to hook up with this resource.

Leave a Reply

Your email address will not be published. Required fields are marked *

*