ISJSON

Consuming JSON Formatted API Data in 2016

Natively consume JSON data from API sources with SQL 2016 and CLR

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.

Getting Started with JSON Support in SQL Server 2016 – Part 2

Arshad Ali talks about using OPENJSON to read and parse JSON data and looks at how to convert it to tabular format.

Exploring SQL Server 2016 Always Encrypted – Part 4 – Encrypting Existing Data

Greg Larsen explores the different ways that you can encrypt your existing confidential data using Always Encrypted Columns in SQL Server 2016.

JSON support in SQL Server 2016

At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a useful start, even though it is nothing like as comprehensive as the existing XML support. For many applications, what is provided will be sufficient. Robert Sheldon describes what is there and what isn't.

De-normalize database schema using JSON

Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.

So You Need to Expose JSON Endpoints

Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.

JSON

NoSQL inside SQL Server

This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.