JSON

Transferring Data with JSON in SQL Server

  • Article

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.

2018-12-05

3,025 reads

Importing JSON Data from Web Services and Applications into SQL Server

  • Article

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.

2017-12-04

4,513 reads

Consuming hierarchical JSON documents in SQL Server using OpenJSON

  • Article

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.

2017-11-15

3,562 reads

Blogs

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

By

I am very passionate about having a disaster recovery architecture, plan and strategy. This...

I Presented with Live Captioning and Sign Language Interpreters

By

I had the pleasure of presenting a full-day pre-conference session on the Friday before...

What's New in SQL 2019? at the Santa Fe SQL Server User Group

By

Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...

Read the latest Blogs

Forums

Convert column values into single row comma separator

By Rock

Team My requirement is to convert column values into single row comma separator along...

Running VBS Script through SQL Agent Job

By EsquireDeveloper

Hello All, Glad to have found this board. I have a VB Script that...

SELECT different rows on multiple threads

By Lambert Antonio

I have an application which will be reading from a single table, in order...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DBCC Meaning

See possible answers