Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.
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