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
2025-06-09
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.
2025-03-24
2025-02-28
388 reads
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.
2024-09-09
Learn how you can query JSON data from a CLI to check it before importing the data into a database.
2024-02-16
7,695 reads
2023-10-25
528 reads
2023-06-19
544 reads
2021-09-17
528 reads
When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]
2021-09-17
20,266 reads
2021-08-06
507 reads
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
If your Notion workspace feels more like a data graveyard than a command center,...
Comments posted to this topic are about the item What is Delayed Durability in...
Comments posted to this topic are about the item Which MAXDOP?
Comments posted to this topic are about the item Data Sovereignty in the Cloud
I have a SQL Server 2022 instance with this setting:
EXECUTE sp_configure 'max degree of parallelism', 4; GOI then run this:
SELECT ProductID, OrderQty, SUM(LineTotal) AS Total FROM Sales.SalesOrderDetail WHERE UnitPrice < $5.00 GROUP BY ProductID, OrderQty ORDER BY ProductID, OrderQty OPTION (MAXDOP 2); GOWhat is the maxdop for my query? See possible answers