Microsoft’s SQL Server may be a big dog in the enterprise database market, but its conspicuous lack of user-defined functions (UDFs) has stacked up poorly against other leaders of that pack ...

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

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

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

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.