JSON

External Article

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

External Article

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

SQL Saturday Boston Slides and Code

By

Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...

Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings

By

SQL Server 2025 introduces native support for vector data types and external AI models....

Advice I Like: Fear and Imagination

By

Fear is fueled by a lack of imagination. The antidote to fear is not...

Read the latest Blogs

Forums

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Choosing an AI in Sept 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choosing an AI in Sept...

The New SQL Server 2025 Data type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New SQL Server 2025...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers