Sign in to confirm you’re not a bot
This helps protect our community. Learn more

JSON Type & Aggregates Public Preview in Azure SQL Database | Data Exposed

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
1.6K views 10 months ago #LearnSQL #SQL #AzureSQL
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... JSON_OBJECTAGG (Transact-SQL) - SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql... JSON_ARRAYAGG (Transact-SQL) - SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql... 📌 Let's connect: Twitter - Anna Hoffman,   / 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 ...more
...more
JSON Type & Aggregates Public Preview in Azure SQL Database | Data Exposed
66Likes
1,673Views
Jun 202024
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... JSON_OBJECTAGG (Transact-SQL) - SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql... JSON_ARRAYAGG (Transact-SQL) - SQL Server | Microsoft Learn: https://learn.microsoft.com/en-us/sql... 📌 Let's connect: Twitter - Anna Hoffman,   / 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

Follow along using the transcript.

Microsoft Developer

588K subscribers