Database and Analytics

W10 Fast Focus: JSON Integration in SQL Server


1:30pm - 1:50pm

Level: Introductory

Leonard Lobel



Sleek Technologies, Inc.

For over a decade, the XML support in SQL Server has enabled developers to integrate structured relational data with unstructured hierarchical XML. Today, JSON (JavaScript Object Notation) is the new XML, and SQL Server 2016 provides built-in support for storing, querying, parsing, and manipulating JSON. In this session, you'll learn the best use cases for leveraging JSON in SQL Server, and then explore different techniques for working with JSON. Whether you're consuming it into relational tables, delivering it out of query results, or any combination of the two, JSON support in SQL Server 2016 provides the flexibility you need to get your job done.