What started as a simple recommendation turned into a comprehensive benchmarking exercise. Let us see blog post about JSON vs XML.
Shredding JSON Into Relational Tables in One Pass
Use shredding JSON to stage parent and child rows, validate their data, capture identity mappings, and load relational tables atomically.
Shaping Query Results as JSON With FOR JSON PATH
Shape FOR JSON PATH output with nested objects, child arrays, null options, and wrappers, then return one complete JSON value to clients.
Azure Data Studio- Export Any SQL SERVER Query As JSON
Recently, one of my clients’ Comprehensive Database Performance Health Check asked me if I know a way to export any query as JSON with SSMS.
Entity-Attribute-Value Tables: Why They Hurt Queries
Understand entity-attribute-value query costs, lost types, indexing limits, and alternatives using real columns, sparse columns, or JSON.
Schema Discovery for JSON Columns: Listing Every Key With OPENJSON
Use schema discovery on JSON columns to count keys and types, inspect nested objects, and find missing required paths with guarded input.
SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword
Why does a JSON path that doesn’t match return NULL? Add the STRICT keyword to get an error instead. A follow-up on JSON NULL values in SQL Server 2016.