Choosing SQL and No-SQL database in Microsoft Azure Cloud services
Overview Pre-requisites: Glimpse of cosmos DB and SQL server You might have come across various database platforms when it comes to storage. This article would help you to understand the scenarios and how you may have the considerations when it comes to choosing the database into the real world scenarios. Database as storage On a broader scale we would discuss about No-SQL database and Azure SQL Database which can cover various scenarios. Of-course, Azure provides variety of database other than we are discussing in this article. You need to be considerate when it comes to chose with PaaS, Native support, ability to configure settings and cost. Below picture indicates a thumb rule to consider database and No-SQL APIs. Picture 1: Database scenarios Scenarios When it comes to choosing the API on Azure Cosmos DB, there needs to be number of considerations that should be taken in to account. Table API: When you want to store just a key value pair such as configurations tho...