JSON parsing – performance comparison

One of the first questions that people asked once we announced JSON support in SQL Server 2016 was “Would it be slow?” and “How fast you can parse JSON text?”. In this post, I will compare performance of JSON parsing with JSON_VALUE function with the XML and string functions. Experiment In this experiment I have… Read more

Returning spatial data in GeoJSON format – Part 2

In the previous post Returning spatial data in GeoJSON format – Part 1, I have described how you can export Sql Server spatial data to GeoJSON. GeoJSON is popular JSON format used to represent spatial data that looks like: { “type”: “Feature”, “geometry”: { “type”: “Point”, “coordinates”: [125.6, 10.1] }, “properties”: { “name”: “Dinagat Islands” }}  … Read more

Loading GeoJSON data into SQL Server

GeoJSON is popular format for spatial data representation. If you receive text formatted as GeoJSON from other systems, you can load it into SQL Server and convert it into spatial types. New OPENJSON function in SQL Server 2016 enables you to parse and load GeoJSON text into SQL Server spatial types. In this example, I will… Read more

Returning spatial data in GeoJSON format – Part 1

GeoJSON is popular format used to represent spatial data. An example of GeoJSON text that represents one point is shown in the following example: { “type”: “Feature”, “geometry”: { “type”: “Point”, “coordinates”: [125.6, 10.1] }, “properties”: { “name”: “Dinagat Islands” }} In ‘geometry’ object are placed type of the spatial data and coordinates. In “property”… Read more

Samples for SQL Server 2016 CTP3

Update: New sample database for SQL Server 2016: Wide World Importers   CTP3 of SQL Server 2016 was just announced, and is available for download. To accompany CTP3, we also created an updated version of AdventureWorks, called AdventureWorks2016CTP3, and we created a number of samples to showcase some of the new functionality in SQL2016. We… Read more