SQL Server 2016 provides new support for working with JSON objects. In a previous column, I discussed how to generate JSON from SQL queries.This column looks at the reverse process: accepting JSON ...

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 ...