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.

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

In SQL Server, the 'N' in N'...' represents 'National Character Set' and is used to identify Unicode strings. The core function of this syntax is to inform the database that the string should be ...

This only occurs when a "/" character exists in the BASE64 string. This is because the output binding framework tries to run the following command, escaping "/" characters in the whole JSON object.