So, what about JSON in my database?

The JSON data format, also called hipster's XML, is all around, not only in Javascript environments. In this session we'll first see where it comes from, what it looks like and what it can be used for.

Next we'll explore how SQL Server handles JSON. Despite not providing a dedicated data type for it, there are some sophisticated functions for storing and retrieving JSON data, thus bridging NoSQL and relational concepts. SQL Server 2022 even brought some new JSON functions.

After that we're joined by the NoSQL/document store solutions. Microsoft's own Azure Cosmos DB, as well as the "original" called MongoDB enter the comparison with SQL Server in terms of features and limitations, pros and cons. Eventually we'll know when to prefer which solution.

Thomas Hütter

Explorer of Things

Brüggen, Germany

View Speaker Profile