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/relational-databases/json/json-data-sql-server?view=sql-server-ver16
Github: https://github.com/microsoft/sql-server-samples/tree/master/samples/features/json
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, https://twitter.com/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
