SQL ❤️ JSON: The Best of Both Worlds

on YouTube ↗01h 06m

" summary

SQL Server and Azure SQL now store JSON in a native binary MSJSON format via a native JSON type (up to 2 GB per row), parsed on write and indexable; new features include JSON contains for type-safe existence checks, path expressions (including last and ranges), JSON object/array construction and JSON array/object aggregate, and in-place JSON.modify for faster updates. Microsoft.Data.SqlClient (6.x) and JDBC support the JSON type, EF Core can map columns to JSON, and a demo shows JSON indexing turning multi-second scans into millisecond seeks.

AI-written summary · about

" chapters (9)

1. 0:00Introduction
2. 1:27History of JSON in SQL Server
3. 1:58JSON features 2016-2022
4. 5:15JSON improvements 2022
5. 8:30New features in SQL Server 2025
6. 14:50Driver support and best practices
7. 17:31JSON in action: code demos
8. 44:17JSON indexing and performance
9. 53:11Application architecture with JSON

" related talks

• 45mJSON - a first class citizen in Azure SQL DBSanjay Mishra, Abhiman Tiwari · SQLBits 2024
• 01h 01mThe JSON evolution with SQL DatabaseRoberto Freato · DotNext 2021 Moscow
• 56mExciting new features in SQL Server for developersHasan Savran · NDC London 2023
• 55mThe JSON Evolution with SQL DatabaseRoberto Freato · Developers Summit 2021
• 47mDealing with JSON in the Relational WorldAndres Almiray · DevDays || DevOps Pro || CyberWiseCon Europe 2025
• 45mHow Well Do Relational Database Engines Support JSON?Christian Antognini · Riga Dev Days 2019
• 46mThe JSON Evolution With SQL DatabaseRoberto Freato · DevOps Pro Europe 2021
• 58mMySQL 5 7 + JSONMorgan Tocker · PHP UK Conference 2016