How do you use JSON data in Azure SQL Database & SQL Server 2022 | 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 & 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:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #AzureSQLDB #SQLServer2022 #JSON #TSQL

[pedromogga]

It's great that SQL Server has JSON support but grading it would be a 6/10 whereas Postgres JSON support is 9/10 and DuckDBs is 10/10. Giving it its own data type is very much welcomed ... but why has it taken Microsoft so long to do so...and still not there in September? In the modern world of small incremental changes .... this just doesn't seem to happen with SQL Server. It's fair to say that DuckDB has introduced more features to devs in the last 12 months than SQL Server has in the last 6 years. Some of DuckDBs SQL 'extensions' such as group by all, pivot syntax, no need for actual select, exclude etc are things SQL Server needs to copy. I have built my 25 year data career on SQL Server but it seriously needs to improve. Its being left behind.