SQL Server and JSON - It's not a horror movie!

JSON has become the defacto standard for exchanging data between applications and over the web. SQL Server 2016 provides built-in support for JSON. This presentation will: - Provide a brief introduction to JSON - Describe the SQL Server 2016 functions that can be used to parse / format JSON data - Demonstrate the use of these functions against a dataset containing movie data in JSON format - Visualize the results in a Power BI report