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.

Order By JSON_VALUE(LastUpdate, '$.Name.Last') Because SQL Server doesn’t have a Boolean data type, I must test the IsPremium property against the string "true." But, wait, there’s more! In my next ...

You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.