Database and Analytics

W09 JSON and SQL Server, Finally Together


9:30am - 10:45am

Level: Intermediate to Advanced

Steve Hughes

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