I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were available for attendees, the code was not distributed yet as an oversight on my part. In this post, I will do a quick summary of the sessions and make sample code available. I will be writing more on these topics throughout the year and will tag VS Live in the notices.
JSON & SQL Server Finally Together
JSON is now part of SQL Server 2016. SQL Server now includes functions to generate and shred JSON. Here are the basics:
- OPENJSON: Used to convert JSON data into a tabular format
- FOR JSON: Used to create JSON from tabular data
- ISJSON: Determines if the data in question is JSON
- JSON_VALUE: Returns scalar values from JSON data
- JSON_QUERY: Returns JSON formatted arrays or objects
- JSON_MODIFY: Used to modify JSON data and properties
With all of this support, JSON is not a native data type in SQL Server like XML.
You can download supporting files and code here.
Using Hive and Hive ODBC with HDInsight and Power BI
During this session I went through the process of setting up HDInsight and loading data into the cluster. Once created, Hive tables were created and queries created that were used with Power BI to analyze the results.
You can find the details here.