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

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

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

For the past fifty years, SQL has helped us understand, manipulate and use our data to our advantage.

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

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