Validate payloads with JSON_PATH_EXISTS and typed ISJSON in SQL Server 2022, distinguish null from missing, and enforce a clear contract.
Moving Data Out of SQL Server in Open Formats
Move SQL Server data into open formats such as CSV, JSON, and Parquet while preserving types, NULLs, encoding, and readable files.
Relational, Document, Graph and Vector: Choosing the Right Data Model
Choosing the Right Data Model means matching the shape of your data to the questions you ask. This post stores one bookshop four ways in SQL Server 2025, with relational tables, JSON documents, graph tables and a vector column, and runs the question each one answers best. It ends with a rule for choosing.
Loading Data From an API Into SQL Server
Loading data from an API into SQL Server takes paging, JSON staging, retries, and durable checkpoints so a failed request can resume safely.
T-SQL Features Added in Recent Versions
T-SQL features added in recent SQL Server versions shorten common date, comparison, string, and JSON patterns when deployed deliberately.
Validating JSON Parameters Before a Procedure Uses Them
Learn validating JSON parameters before changing data with ISJSON, JSON_PATH_EXISTS, TRY_CAST, and a single clear list of input errors.
STRING_ESCAPE JSON Text: Escaping Is Not Serialization
STRING_ESCAPE JSON text is still text that belongs inside a JSON string. This example compares quotations, backslashes and a newline with complete FOR JSON PATH objects.