SQL terms vs MongoDB terms trip up teams that use both products. This glossary maps tables, collections, rows, documents and fields, shows tested SQL Server queries beside the mongosh equivalents, and marks where the vocabulary stops matching.
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.
JSON_MODIFY: Changing One Property Inside a JSON Column
Edit one value inside a JSON document without string surgery. A hands-on tour of the quirks with types, NULL, missing paths and retries.
JSON Column Index in SQL Server: Index One Property
A JSON column index is one of the first tools a DBA needs when documents arrive in SQL Server. This test stores 100,000 recipes as JSON, searches one property with no index, then indexes it through a computed column. It also shows the cast that quietly breaks the match and how missing keys behave.
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.
SQL SERVER – Understanding JSON Use is Case-Sensitive
My daughter explores every new toy, and that is how I play with JSON in SQL Server 2016. One surprise: JSON paths are case-sensitive, as this example shows.
SQL SERVER – Fix Error Msg 13603 working with JSON documents
Msg 13603 appeared when I used a custom path with FOR JSON PATH, because the column alias had an invalid character. Here is how to fix it.