JSON in SQL, Expanding the Possibilities!


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.


  • Mike Burek

    16 Recordings
    Mike Burek has worked with SQL Server for 25 years. Throughout his career, he has often worked with marketing data. From this, he has experience with various tools for ETL as the industry and programming has changed and matured over time. On the SQL Server side, he has held senior positions in database administration and database programming, focusing on optimization, automation, and increasing the value of data. Outside of work, he also runs the Austin SQL Server user group and makes a big effort to train others to help them grow in their careers.

Recorded At:

Recorded on:

Nov 15, 2022

More Info:



  • SQL 28 Recordings
  • Json 3 Recordings