CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

Azure recently announced the public preview of Azure SQL trigger for Azure Functions to build event-driven applications. The new functionality is currently available only for C# functions and can ...

In SQL Server 2016, this feature is vastly improved, supporting foreign keys, check and unique constraints and parallelism. Additionally, tables up to 2TB are now supported (up from 256GB).

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.

SQL Window functions are an advanced type of function in SQL. In this post, you will learn about what SQL window functions are and how they can be used or work.