T-SQL in SQL Server 2025: JSON_ARRAYAGG

Learn how the JSON_ARRAYAGG() function works in SQL Server 2025.

Creating a JSON Document II

Creating a JSON Document I

T-SQL in SQL Server 2025: JSON_OBJECTAGG

Learn about the new JSON_OBJECTAGG function in SQL Server 2025.

Fun with JSON II

Fun with JSON I

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.