JSON Type & Aggregates Public Preview in Azure SQL Database

Post Content

The native JSON type allows JSON documents to be stored in a binary format. This binary format allows for efficient query processing and in-place modifications of JSON documents. The JSON aggregates – JSON_OBJECTAGG & JSON_ARRAYAGG enable easy aggregation of relational data into a JSON document. Learn more in this episode of Data Exposed with Anna Hoffman and Umachandar Jayachandran.

Chapters:
00:00 – Introduction
01:46 – Demo
04:00 – Getting started

✔️Resources:
JSON data type (preview) – SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type?view=azuresqldb-current
JSON_OBJECTAGG (Transact-SQL) – SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-objectagg-transact-sql?view=azuresqldb-current
JSON_ARRAYAGG (Transact-SQL) – SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-arrayagg-transact-sql?view=azuresqldb-current

? Let’s connect:
Twitter – Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter – AzureSQL, https://aka.ms/azuresqltw

? Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt

Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt

#AzureSQL #SQL #LearnSQL Read More Microsoft Developer