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

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.

Learn about JavaScript Object Notation and JSON objects and arrays, including how and why they're used. Also, find out how JSON compares to HTML and XML.