SQL Server 2016 adds JSON support. Here is a quick look at what JSON (JavaScript Object Notation) is and how to create your first JSON document with a query.
JSON_CONTAINS in SQL Server 2025: Searching Inside JSON Arrays
JSON_CONTAINS checks whether a JSON document holds a value at a path, including inside an array. This post tests it on SQL Server 2025: the json data type it needs, numbers versus text, case, NULL results and the older OPENJSON way.
JSON or Real Columns: Deciding Where Attributes Live
Putting everything in a JSON column is tempting. Here is what it costs in reads, type checks and null handling, and when to promote a property.
Casting JSON Arrays to the vector Type for Embeddings
A cast checks the count of numbers, not the model they came from. Here is a simple staging pattern that loads good rows and reports the rest.
JSON_OBJECT and JSON_ARRAY: Building JSON in SQL Server 2022
Build JSON_OBJECT and JSON_ARRAY values in SQL Server 2022, control null handling, nest arrays, and compare rowset and aggregate output.
Querying Nested JSON Arrays With OPENJSON
Query nested JSON arrays with OPENJSON, preserve element positions, pass inner arrays with AS JSON, and handle missing or strict paths.
Indexing JSON Properties With Computed Columns
Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.