The JSON Evolution With SQL Database
summary
SQL Server handles JSON natively and the demo proves it using a Kaggle movies dataset with a 1 GB reviews file. A C# importer plus a Visual Studio database project loads data, extracts fields with OPENJSON and JSON_VALUE and safeguards types with TRY_CAST, creates hybrid tables and a normalized view, and shows a join over huge JSON blobs that spools memory. Cold data moves to a clustered columnstore index, cutting storage and making analytics fast.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:56Disclaimer
- 3:10Common Scenario
- 4:49Data Changes
- 6:31Scenario
- 7:12Data
- 17:41Hybrid Table
- 21:51JSON
- 23:44JSON Functions
- 30:31Fine Tuning
- 39:14Future Options
- 43:47Conclusion
related talks
01h 01mThe JSON evolution with SQL Database
55mThe JSON Evolution with SQL Database
01h 06mSQL ❤️ JSON: The Best of Both Worlds
45mJSON - a first class citizen in Azure SQL DB
56mExciting new features in SQL Server for developers
47mDealing with JSON in the Relational World
29mRetire your tables. It's all JSON now.
50mSQL, JSON, and Java