Build customer arrays with JSON_ARRAYAGG and settings objects with JSON_OBJECTAGG in SQL Server 2025, with explicit order and null rules.
JSON_PATH_EXISTS and Typed ISJSON in SQL Server 2022
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.
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.