Fun with JSON

Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]

Creating JSON II

Creating JSON I

JSON Has a Cost

JSON has become a very popular data format used in many software applications. However, it's not magic.

How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:

Techniques to query Azure SQL’s new JSON Datatype

The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation in SQL Databases. These features are slated to be a part of SQL Server 2025 as well. Let’s analyze some practical uses of these features

SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG

I need to construct JSON from data in our database, but I find the existing FOR JSON PATH limited when the data is not located in one single row but rather scattered over multiple rows. Is there another method on how to handle JSON data in SQL Server? Learn how to use the new SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG in this article.

Rows estimation with OPENJSON

Effective Strategies for Storing and Parsing JSON in SQL Server

Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.

JQ - Tool for Querying JSON documents using the CLI

Learn how you can query JSON data from a CLI to check it before importing the data into a database.