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.

In SQL Server, the initial dialect for stored procedures (or stored procs) was Transact-SQL, aka T-SQL; in Oracle, it was PL-SQL. Both databases have added additional languages for stored ...

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. ...