JSON

How to parse JSON in SQL Server

September 15, 2020 by Esat Erkec

In this article, we will learn how to parse and query JSON in SQL Server with the help of the OPENJSON function. Firstly, we will briefly look at the data structure of the JSON and then we will learn details of the parsing and querying JSON data using the OPENJSON function.

Importing data from JSON files and Power BI Rest APIs into Power BI

August 27, 2020 by Ben Richardson

In this article, you will see how to import data from JSON files and Power BI Rest API into the Power BI environment.

Link an Azure Cosmos DB into a SQL Server Stored Procedure

August 3, 2020 by Frank Solomon

Introduction

Microsoft Azure offers hundreds of cloud products, with more on the way. In the database space, Microsoft offers Azure Cosmos DB, a NoSQL database product. We can build Java, .Net, etc. applications around Cosmos DB resources. To extend this capability, this article will show how to query Cosmos DB directly from SQL Server.

The JSON_QUERY() function to extract objects from JSON Data

May 19, 2020 by Rajendra Gupta

In this article, we will explore JSON_QUERY() functions in SQL Server to extract JSON objects and array from the JSON Data.

Extract scalar values from JSON data using JSON_VALUE()

May 5, 2020 by Rajendra Gupta

In this article, we will explore JSON_VALUE() function in SQL Server to extract scalar values from JSON data.

Modifying JSON data using JSON_MODIFY() in SQL Server

May 4, 2020 by Rajendra Gupta

This article explores JSON_MODIFY() function to modify JSON Data in the SQL Server.

SQL Server JSON functions: a bridge between NoSQL and relational worlds

April 22, 2020 by Hadi Fadlallah

In this article, we will explain what JSON is, what are the SQL Server JSON functions introduced in 2016, how to index JSON values, and how to import JSON data into SQL tables.

Import JSON data into SQL Server

January 17, 2020 by Rajendra Gupta

This article explores the process of JSON data import in the SQL Server table using T-SQL and SSIS.

How to use JSON data in Azure Machine Learning

November 9, 2018 by Esat Erkec

Azure Machine Learning (also known as Azure ML) is cloud-based machine learning solution of Microsoft. Microsoft Azure Machine Learning is a fully-managed cloud-based service that provides the ability to create and train predictive analytic solutions. Another advantage of Azure ML is that you can access and easily make changes anywhere in machine learning models with help of Microsoft Azure Machine Learning Studio.

How to use JSON data in SSRS

November 6, 2018 by Esat Erkec

In this article, we will explore the concept of using JSON data in SQL Server Reporting Services (SSRS). This usage concept will include a different approach than the usual methodologies because we will take advantage of SQL Server R service support.

What is JSON?

JSON is an abbreviation for JavaScriptObjectNotation. The main purpose of JSON data was to provide data transfer between server and web applications for JavaScript but today’s JSON is the most popular data interchange format. JSON offers two advantages to us. These are; light-weight text based format easily readable by humans. Currently, JSON is not only used in JavaScript applications, it is also used in all popular software programing languages like JavaScript, C++, C#, Perl, Java, Python, Php etc.

Illustration of an example availability monitoring service Using PowerShell and SQL

March 23, 2017 by Prashanth Jayaram

This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML

$C:\Users\Marko\AppData\Local\Microsoft\Windows\INetCacheContent.Word\JSON.PNG$

How to import/export JSON data using SQL Server 2016

March 7, 2017 by Marko Zivkovic

JSON is an abbreviation for JavaScript Object Notation. JSON is very popular and currently the most commonly used data exchange format. Most modern web and mobile services return information formatted as JSON text, all database web services, web browsers (Firefox, Internet Explorer) return results formatted as JSON text or accept data formatted as JSON. Since external systems format information as JSON text, JSON is also stored in SQL Server 2016 as text. You can use standard NVARCHAR columns to store JSON data in SQL Server 2016.

Native JSON Support in SQL Server 2016

January 6, 2017 by Manjuke Fernando

With the introduction of SQL Server 2016, Microsoft introduced many new features which had taken SQL Server another step forward and they made sure that it stands in front among many major Relational Database Systems.

One such feature which has been lacking but desperately required was the native support towards JSON.

Convert SQL Server results into JSON

July 12, 2016 by Sifiso W. Ndlovu

In my article, Warehousing JSON Formatted Data in SQL Server 2016, we had a look at available T-SQL options for converting JSON data into rows and columns for the purposes of populating a SQL Server based data warehouse. The increased popularity of JSON in modern web applications may create a requirement for data teams to expose some of their data to client applications (i.e. reporting tools, web services etc.) in a JSON format. In this article we take a look at how such a requirement can be implemented by data teams using SQL Server 2016 FOR JSON clause

Warehousing JSON formatted data in SQL Server 2016

June 22, 2016 by Sifiso W. Ndlovu

In this article, I continue to review the exciting features available in SQL Server 2016. One such feature is the long awaited T-SQL support for JSON formatted data. In this article we take a look at how JSON support will impact data warehouse solutions.