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

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

Recently I already mentioned Named Formulas and User Defined Functions in my posts. Today I'm looking at User Defined Types.

How to Start SQL in Single-User Mode. Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and ...