Working with JSON functions in SQL Server – Jonathan Crozier

Support for JSON was added to SQL Server 2016 and was made available for Azure SQL around the same time. Unlike the support for XML in SQL Server, a new data type was not introduced specifically for JSON.