A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, ...

I did not figure out the root cause of that error, but running the create function script in a subsequent database connection has resolved the issue. While SQL Server has configurations ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

or 10/1/2015), which we can achieve using SQL Server’s built-in “convert” function with formatting style 103. In the example below, we can see that the provided date string is in the wrong format. It ...

This article highlights the different commonly used SQL functions as exit in the analysis of data such as the aggregate functions, string functions, date functions and others. The arithmetic function ...

With such a huge percentage of all our IT systems relying on data to function, SQL will not be going away any time soon. So, let’s celebrate SQL turning 50, and consider how we can continue to ...

I want to call a user defined SQL SERVER function and use as parameter a property ... c.Name creates an error, because it is of type ML<CountryName> and not of type string as the first parameter of ...