Using JSON with SQL Server 2016

Explore the integration of JSON with SQL Server 2016 in this 54-minute conference talk from PASS Data Community Summit. Dive into the history of JSON support, examine practical examples, and learn about JSON objects and arrays. Discover how to leverage JSON Path, OPENJSON, and FOR JSON functionalities within SQL Server. Gain insights into JSON functions and indexing techniques to optimize your database operations. Presented by Steve Hughes and moderated by Sarah Huang, this comprehensive session covers everything from technical assistance to real-world applications, equipping you with the knowledge to effectively utilize JSON in your SQL Server 2016 environment.

Intro
Technical Assistance
A Bit of History
Examples
JSON Support in SQL Server 2016
A Little About JSON Objects
A Little About JSON Arrays
JSON Example
JSON Path in SQL Server
OPENJSON
FOR JSON
JSON Functions
Indexing JSON
Wrap Up