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 ...

In a previous Practical .NET column I showed how to retrieve rows that hold JSON objects by querying on values in those objects’ properties. However, sometimes you’ll want to work with the complete ...

SQL Server 2025 is supposed to go into public preview soon, so at that point we should be able to run tests against it (e.g. via docker on Linux). We should also make sure that current test coverage ...

In SQL Server 2025 (and an upcoming update of Azure SQL), the JSON_VALUE() ... SQL Server CAST attempts to parse out SQL Server's native format, which fails. JSON_VALUE() returns nvarchar(4000) by ...