Visual Studio Magazine

Converting JSON Objects to Relational Tables: Flattening the Object

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...
MCPmag

A Look at JSON and PowerShell

If you are not familiar with JSON, it stands for Java Script Object Notation and is an open standard format that uses human readable text for data interchanges. Despite its name, it is separate to ...
TheServerSide

JSON (JavaScript Object Notation)

What is JSON (JavaScript Object Notation)? JSON (JavaScript Object Notation) is a text-based, human-readable data interchange format used to exchange data between web clients and web servers. The ...
Visual Studio Magazine

Retrieving and Updating JSON Objects in SQL Server 2016

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them. In a previous Practical .NET column I showed ...