JSON

SQLServerCentral Article

How to Flatten JSON in Azure Data Factory?

  • Article

When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]

4.5 (2)

2021-09-17

13,186 reads

SQLServerCentral Article

Reading and Writing your Database's Documentation using JSON

  • Article

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I'm doing for Redgate's Product Learning, I've been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object […]

2021-06-28 (first published: )

3,216 reads

SQLServerCentral Article

NoSqlOnSql

  • Article

Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]

5 (1)

2020-11-02

4,494 reads

External Article

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

Blogs

FIRST Robotics Competition 2023 - World Championships!

By

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

Errata for my book: Pro Encryption in SQL Server 2022

By

My biggest fear when my book went into production was that any factual errors...

SQL Server Quickie #45 – SQL Server Availability Groups

By

Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...

Read the latest Blogs

Forums

Query based on sorting based on month

By Smash125

    SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...

SSRS 2017 - SSRS 2019 migration

By Wecks

I am after some advice, I have completed a SSRS migration 2017 - 2019. ...

Fixing a mismatched collation on MSDB

By NoDowt

Hi, I've been tasked with finding out why we've been unable to patch the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers