JavaScript Object Notation – or JSON as it more commonly known – has been around for close to 20 years now.

However, it debuted in SQL Server with the 2016 release.

JSON is a fabulous data interchange language, however, unfortunately for SQL Server, XML – which is another data interchange format – suffered from a bad reputation of being tricky to use and non-intuitive.

Fortunately, JSON is a lot more user friendly than XML in SQL Server and is extremely useful for things such as

  • Importing configuration information.
  • Exporting data
  • Schema flexibility

Although, it might surprise you to know that there is no JSON data type in SQL Server – however, the JSON implementation is very user friendly and can benefit the DBA and developer in many different ways. A familiarity with JSON may also server as good introduction to other systems – such as CosmosDB – that use this format extensively. Tune into this session and see some of the ways that JSON could help you out as a SQL Server professional.


Martin Catherall, Data Consultant Data Platform Consultant

Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region.

Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.