Level: Intermediate to Advanced

Steve Hughes

Business Intelligence Architect

Pragmatic Works

While still in CTP, SQL Server 2016 is introducing support for JSON. It won't be implemented as a data type like XML, however, many new functions are being introduced. These functions support selecting data into a JSON object using a PATH statement similar to the XML functionality. This session will walk through demos of the most up-to-date JSON functionality in SQL Server 2016 including creating JSON objects, querying data from JSON objects and saving JSON in SQL Server.

You will learn:

• How JSON is handled in SQL Server
• How to create JSON objects using SQL Server
• How to query JSON objects using SQL Server