en-UShe-IL
You are here:   Blog
Register   |  Login

Blog Archive:

Maximize
* Can be used in order to search for older blogs Entries

Search in blogs


Blog Categories:

Maximize
* Can be used in order to search for blogs Entries by Categories

Blog Tags:

Maximize
* Can be used in order to search for blogs by keywords

TNWikiSummit


Awared MVP 


 


Microsoft® Community Contributor 


Microsoft® Community Contributor


 Read first, before you you use the blog! Maximize
אפר15

Written by: ronen ariely
15/04/2016 10:39 RssIcon

Abstract

JSON defines a small set of formatting rules, designed to be as lightweight as possible text format, for the serialization of structured data. JSON can represent four primitive types (Strings, Numbers, Booleans, and Null) and two structured types (Objects and Arrays).

SQL Server 2016 provides built-in support for importing, exporting, parsing, and querying JSON documents. However, JSON support is not the same as the native JSON type, and it implemented using NVARCHAR type. This might lead to bad performance. For example, there's no built-in option for indexing, which can give us direct use of data as structured data.

In this session we will demonstrate several built-in JSON support functions in SQL Server 2016, and we will finish with some tricks and tips to improve performance.

Download a zip file, which includes code files and the presentation from the lecture of Ronen Ariely at SQLSaturday #481 event: 
https://gallery.technet.microsoft.com/Built-in-JSON-support-in-060c73ce