Virtual - JSON in SQL, Expanding the Possibilities! - Mike Burek

URL: https://aka.ms/AustinSQLNov2022
Virtual Online Meeting 5:50 pm - 7:00 pm
Title: JSON in SQL, Expanding the Possibilities!
Speaker: Mike Burek
This topic was the most requested from the survey, so thank you to everyone who voted.

Abstract:
You're going to run into JSON data. And it's getting common enough that it's now hard to push back and request the data get converted to some time of table format; you are expected to hand JSON data now.
So let's look at the built-in ways to handle it natively in SQL Server, starting with 2016. There are various ways import and export the data, some special considerations since the data can be nested and denormalized with implicit linking.

Luckily, compared to XML data, we have a few additional built in functions that make working with JSON much easier than XML.

We won't cover external programs and manual processing of the JSON strings, since SQL Server can natively handle the data.