Episode

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

with Anna Hoffman, Umachandar Jayachandran

Data Exposed

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 and SQL Server 2022. We will look at how JSON documents can be stored in tables, modified and queried in the database. We will also look at how to transform relational data into JSON and vice versa.

Chapters

  • 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

Connect

Azure
Azure SQL Database
SQL Server
JSON
SQL
Transact-SQL