Practical .NET Returning JSON from SQL Server Queries 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 ...

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

Couchbase Inc., long the champion of its "world's highest-performing NoSQL distributed database platform," has apparently decided that this SQL stuff isn't so bad after all, having announced a new ...

SQL Server 2025 is also introducing a native JSON datatype, which should improve performance over the current approach of storing JSON data in the VARCHAR (MAX) field.