Exciting new features in SQL Server for developers
summary
Covers concrete SQL Server additions: row-level JSON functions like json_modify/json_value plus new creators json_array/json_object and json_path_exists, and shows how persisted computed columns plus nonclustered or columnstore indexes make JSON queries fast; demonstrates graph node and edge tables with MATCH and shortest_path for relationship queries; explains memory-optimized durable vs non-durable tables and natively compiled stored procedures for microsecond access; demos include warehouse→user geospatial routing, a 1.1M-row StackOverflow graph, and 8M JSON docs with large columnstore compression.
AI-written summary · about
chapters (5)
- 0:00Start
- 2:28History of JSON in SQL Server
- 5:21JSON Path Expressions
- 16:59Return Data as JSON
- 23:06SELECTING CORRECT DATA MODEL
related talks
01h 02mNot your Father's SQL Server: Developer Innovations in Data Storage
01h 06mSQL ❤️ JSON: The Best of Both Worlds
45mJSON - a first class citizen in Azure SQL DB
37mBeyond Relational with Entity Framework
59mBeyond Relational With Entity Framework
01h 01mThe JSON evolution with SQL Database
39mMore Than a Query Language: SQL in the 21st Century
46mThe JSON Evolution With SQL Database