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

How do you use JSON data in Azure SQL Database & SQL Server 2022 | Data Exposed

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2.9K views 1 year ago #JSON #AzureSQL #AzureSQLDB
In this episode of Data Exposed with Anna Hoffman and Umachandar Jayachandran, you will learn how to use JSON documents from Transact-SQL in Azure SQL Database & SQL Server 2022. We will look at how JSON documents can be stored in tables, modified & queried in the database. We will also look at how to transform relational data into JSON and vice versa. 00:25 Introduction 00:45 JSON in SQL Server 01:39 Demo of storing and querying JSON in SQL Server 03:00 Changing a JSON Document 04:10 Query Individual JSON Objects 05:01 From SQL to JSON 07:00 New JSON features 08:00 Closing ✔️ Resources: JSON data in SQL Server: https://learn.microsoft.com/en-us/sql... Github: https://github.com/microsoft/sql-serv... Native JSON type & JSON aggregates are now in private preview for Azure SQL Database: https://aka.ms/json-preview 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 📌 Let's connect: Twitter: Anna Hoffman,   / analyticann …...more
...more
How do you use JSON data in Azure SQL Database & SQL Server 2022 | Data Exposed
69Likes
2,907Views
2023Jun 15
In this episode of Data Exposed with Anna Hoffman and Umachandar Jayachandran, you will learn how to use JSON documents from Transact-SQL in Azure SQL Database & SQL Server 2022. We will look at how JSON documents can be stored in tables, modified & queried in the database. We will also look at how to transform relational data into JSON and vice versa. 00:25 Introduction 00:45 JSON in SQL Server 01:39 Demo of storing and querying JSON in SQL Server 03:00 Changing a JSON Document 04:10 Query Individual JSON Objects 05:01 From SQL to JSON 07:00 New JSON features 08:00 Closing ✔️ Resources: JSON data in SQL Server: https://learn.microsoft.com/en-us/sql... Github: https://github.com/microsoft/sql-serv... Native JSON type & JSON aggregates are now in private preview for Azure SQL Database: https://aka.ms/json-preview 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna   Twitter: AzureSQL, https://aka.ms/azuresqltw 🔔 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 #AzureSQLDB #SQLServer2022 #JSON #TSQL

Follow along using the transcript.

Microsoft Developer

588K subscribers