As I noted in an earlier column, JSON is great for moving data around but not so hot when you need to convert it into data stored in a relational database.In that earlier column, I looked at why you ...

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