So, what about JSON in my database?
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.
Explorer of Things
Brüggen, GermanyView Speaker Profile