In SQL Server 2014 we saw the introduction of Natively Compiled Stored Procedures. In 2016 we’ll be able to do the same for Scalar User Defined Functions.

User-defined functions in SQL Server fall into three categories: scalar functions that return a single value, inline functions that return a table set, and multi-statement functions that return ...

In addition, developers are able to define SQL Server user-defined types, stored procedures and functions using Common Language Runtime (CLR) languages.

SQL Server expert Kevin Kline has kicked off a multi-continent roadshow, sharing his deep SQL knowledge and best practices at a series at a series of SQL Saturdays and SQL Server User Group meetings. ...

Microsoft recently released User Defined Functions in Preview. In this post I'm going to compare User Defined Functions with Named Formulas.