With SQL Server 2016, you can store JSON objects in your rows ... JSON_MODIFY lets you do that. You must pass the JSON_MODIFY function the JSON object, a JSON path expression to the property you want ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

A public preview of SQL Server 2025 adds new vector capabilities already found in rival databases, along with JSON support ...