Explore JSON integration with SQL Server 2016 in this 55-minute conference talk from PASS Data Community Summit. Delve into the history of JSON, examine practical examples, and learn about JSON support in SQL Server 2016. Gain insights into JSON objects, arrays, and path expressions. Master the use of OPENJSON and FOR JSON clauses, along with various JSON functions. Discover techniques for indexing JSON data to optimize performance. Presented by Steve Hughes and moderated by Sarah Huang, this comprehensive session covers everything from basic concepts to advanced implementation strategies for effectively utilizing JSON within SQL Server 2016 environments.
Overview
Syllabus
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
Taught by
PASS Data Community Summit
