Episode
JSON Type & Aggregates Public Preview in Azure SQL Database | Data Exposed
with Anna Hoffman, Umachandar Jayachandran
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
Recommended resources
- JSON data type (preview) - SQL Server
- JSON_OBJECTAGG (Transact-SQL) - SQL Server
- JSON_ARRAYAGG (Transact-SQL) - SQL Server
Related episodes
- Data Exposed | Microsoft Learn
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
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
Recommended resources
- JSON data type (preview) - SQL Server
- JSON_OBJECTAGG (Transact-SQL) - SQL Server
- JSON_ARRAYAGG (Transact-SQL) - SQL Server
Related episodes
- Data Exposed | Microsoft Learn
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- AzureSQL | Twitter/X: @azuresqltw
Have feedback? Submit an issue here.