Why you should avoid JSON in Azure SQL Database
JSON is convenient, but storing it in Azure SQL Database takes a lot of space. In this post, I will show you with a demo how much more space we are talking about.
Blog
Azure apps, from the database up
Mostly Azure SQL Database and Azure Cosmos DB, plus the rest of the app. Pick a service, then narrow it down.
Shred JSON Data into Rows in Azure SQL Database Using OPENJSON
JSON_QUERY gives you arrays, but you can't join or count what's inside them. OPENJSON turns each item of a JSON array into its own row. In this post, I will show you how to use it with and without a WITH clause.
Query JSON Data in Azure SQL Database Using JSON_QUERY and JSON_VALUE
Two JSON functions help us read JSON: JSON_QUERY and JSON_VALUE. In this post, I will discuss the differences and how to use them.
Why Azure SQL Database got a JSON data type
Here is why Microsoft added a JSON data type to Azure SQL Database, and when I would use it instead of the good old data types.
No posts match your search.
Happy to chat about Azure and architecture. Connect on LinkedIn