Recently I have been using Azure DocumentDB to validate several business use cases for a variety of application purposes.
For those SQL DBA’s and others who are new to Azure DocumentDB, its a recent entrant to the NoSQL document database world, and as its a PaaS document database cloud service it has the agility, scalability and availability of the Azure Cloud.
Being a schema-less Azure PaaS “document database” for my use case I wanted to verify…
- basic costing and performance levels
- methods to create valid JSON documents from SQL Server
- methods to load JSON documents into Azure DocumentDB
- performing basic like-for-like document query comparisons with SQL Server
Some homework reading for those interested…
- For those wanting to know more about NoSQL itself then you seriously just cannot go past the great Wiki article – https://en.wikipedia.org/wiki/NoSQL
- For those wanting to be aware of some Azure DocumentDB use cases then this is a good start – https://azure.microsoft.com/en-us/documentation/articles/documentdb-use-cases/
- For those wanting a good solid background on Azure DocumentDB see this great article – https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-documentdb/
- For the official Microsoft documentation on Azure DocumentDB see this link – https://azure.microsoft.com/en-us/services/documentdb/
22 May 2017 [EDIT]
Microsoft have just recently added significant new functionality and also formally renamed Azure DocumentDB as Azure CosmosDB – a major evolution of the NoSQL database engine. The details on the renamed service is here – https://docs.microsoft.com/en-us/azure/cosmos-db/introduction
And so… let get into the belly of Azure