Build customer arrays with JSON_ARRAYAGG and settings objects with JSON_OBJECTAGG in SQL Server 2025, with explicit order and null rules.
Change Logs as JSON: Old and New Values in One Column
Skip the audit table with a column for every field. One JSON payload per changed row is lighter, if you handle NULL and multirow updates correctly.
Structured, Semi-Structured and Unstructured Data Explained
Structured, Semi-Structured and Unstructured Data differ in where the schema lives and how you query them. This post compares the three shapes and runs one query across a table, a json column and free text in SQL Server 2025.
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.
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.