JSON - a first class citizen in Azure SQL DB
summary
Azure SQL DB now stores JSON in a native JSON data type (binary storage, private preview, docs + signup) supporting update-in-place, efficient partial reads, and documents up to 2 GB; existing helpers like JSON_VALUE and OPENJSON work with it and JSON_OBJECT_AGG enables producing JSON outputs. The session also previews POSIX-style regular expressions with functions regxp_like, regxp_count, regxp_instr, regxp_replace, regxp_substr, allowing check constraints, computed-column indexes, and built-in validation and transformation inside the engine.
AI-written summary · about
chapters (25)
- 0:00JSON in Azure SQL DB
- 1:19JSON universal format
- 5:14JSON support evolution
- 6:39Native JSON data type
- 8:49Querying and storing JSON
- 11:44Demo: Insert and retrieve JSON
- 13:49Demo: JSON to tables
- 15:58Demo: Aggregate JSON for APIs
- 17:04Q&A: JSON limitations
- 18:07Q&A: Validate JSON before insert
- 19:11JSON with public data
- 20:18JSON bridges SQL and NoSQL
- 21:21Explore JSON private preview
- 22:46Introduction to regular expressions in SQL
- 24:12Regex functions
- 27:03Demo: Regex validation
- 31:43Demo: Regex constraints
- 34:56Demo: Advanced regex
- 38:52Q&A: Regex indexing
- 40:07Q&A: Regex bugs
- 41:36Q&A: JSON indexing
- 42:02Q&A: Private preview signup
- 42:44Q&A: JSON in SQL MI
- 43:49Q&A: JSON storage efficiency
- 44:34Closing remarks
related talks
01h 06mSQL ❤️ JSON: The Best of Both Worlds
01h 01mThe JSON evolution with SQL Database
55mThe JSON Evolution with SQL Database
47mDealing with JSON in the Relational World
56mExciting new features in SQL Server for developers
01h 02mNot your Father's SQL Server: Developer Innovations in Data Storage
46mThe JSON Evolution With SQL Database
45mHow Well Do Relational Database Engines Support JSON?