News

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want. It’s not unusual ...
Native support for JSON in the upcoming SQL Server 2016 was buried among the many goodies announced earlier this month for the flagship RDBMS, but it's clearly an important feature for data developers ...
Microsoft ORM Mapper learns column types Vector and JSON in Microsoft SQL Server 2025. At the same time, there is a first ...
In SQL Server 2025 (and an upcoming update of Azure SQL), the JSON_VALUE() function will be improved to support a RETURNING clause, allowing specifying the data type coming out of the JSON property.
EF 9.0 brought experimental support for the Azure SQL JSON data type (#32150, Azure SQL docs), which is still in preview. As the Azure SQL support will go GA soon, we need to bring the feature out of ...