If your SQL Server database version is 2016 and above, a ready-made STRING_SPLIT function will come automatically. But if you have a SQL Server database under it, including 2014, you will never have ...

Below is a cheat sheet for creating SQL Server client connection strings and finding them in common configuration files.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

When we connect an app to a SQL Server table that has a column of type time, the values don't show in a user-friendly format by default in PowerApps. In this post we'll go over some expressions that ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.