Microsoft Azure SQL Database and Microsoft Azure Cosmos DB compete in the cloud database category, offering distinct advantages based on user needs. For enterprises focused on traditional SQL environments, Azure SQL Database might be preferable due to its integration and elasticity, while Cosmos DB stands out for NoSQL operations with its global distribution capabilities.
Features: Microsoft Azure SQL Database provides strong scalability, high availability, and seamless integration with other Microsoft products. It includes advanced security features and elastic licensing, making it ideal for web and enterprise applications. Microsoft Azure Cosmos DB features multi-model data support, low-latency data access, and efficient global distribution, tailored for diverse data storage needs and rapid ingest capabilities.
Room for Improvement: Azure SQL Database users have highlighted the need for enhanced security, improved support for distributed transactions, and better documentation. They desire a more flexible pricing model and streamlined integration processes. Azure Cosmos DB users often cite high costs and complex pricing models, requesting better API compatibility and expanded developer tools for improved query functionality.
Ease of Deployment and Customer Service: Microsoft Azure SQL Database provides extensive deployment flexibility in public, private, and hybrid cloud environments, combined with robust technical support. Users note occasional delays in commercial support responsiveness. Azure Cosmos DB is mainly deployed in public cloud environments, appreciated for its proactive support and comprehensive documentation, though complex issues occasionally challenge support accessibility.
Pricing and ROI: Azure SQL Database is known for cost-effective, flexible pricing plans based on resource consumption, beneficial for traditional SQL applications, reducing infrastructure costs. Azure Cosmos DB's pricing is perceived as higher due to features like global distribution; however, its scalability and performance justify the investment for diverse environments. ROI effects vary, often reducing traditional system costs significantly.
Getting an MVP of that project would have taken six to eight months, but because we had an active choice of using Azure Cosmos DB and other related cloud-native services of Azure, we were able to get to an MVP stage in a matter of weeks, which is six weeks.
You can react quickly and trim down the specs, memory, RAM, storage size, etc. It can save about 20% of the costs.
When I have done comparisons or cost calculations, I have sometimes personally seen as much as 25% to 30% savings.
It is ensuring we receive what we pay for through the blend of price, performance, and features.
If you're managing your own data center, you always have to overprovision your systems and pay for storage space you're not using.
We've reduced costs by about 20 percent after two or three years.
Premier Support has deteriorated compared to what it used to be, especially for small to medium-sized customers like ours.
The response was quick.
I would rate customer service and support a nine out of ten.
Microsoft played a significant role, even from a training perspective, and provided resources that directed us toward the right deployment path.
Once I reach the right people, the support is incredibly knowledgeable and thorough.
Microsoft provides excellent service and is always available to support us.
The system scales up capacity when needed and scales down when not in use, preventing unnecessary expenses.
We like that it can auto-scale to demand, ensuring we only pay for what we use.
We have had no issues with its ability to search through large amounts of data.
Scaling the solution is incredibly simple and involves just clicking a button or dragging a slider.
Azure's scalability features like Elasticity are essential.
Microsoft Azure SQL Database is cloud-based, so it's great for scaling workloads.
We have multiple availability zones, so nothing goes down.
Azure Cosmos DB would be a good choice if you have to deploy your application in a limited time frame and you want to auto-scale the database across different applications.
I would rate it a ten out of ten in terms of availability and latency.
We can't tell the difference between running on-prem or Azure because we no longer have those latency issues.
SQL never crashes or suddenly becomes unavailable.
Therefore, it is preferable to provision an instance local to the connection point to optimize performance and minimize latency.
We must ensure data security remains the top priority.
You have to monitor the Request Units.
The first one is the ability to assign role-based access control through the Azure portal for accounts to have contributor rights.
It would be helpful if CPU performance were not pinned to the amount of storage you're using, and we could scale different properties of the Azure SQL database independently.
I could not get an accurate quote on what my monthly costs would be based on my needs.
To overcome this, we collaborated with the network team to develop alternative solutions.
Initially, it seemed like an expensive way to manage a NoSQL data store, but so many improvements that have been made to the platform have made it cost-effective.
Cosmos DB is expensive, and the RU-based pricing model is confusing.
Cosmos DB is great compared to other databases because we can reduce the cost while doing the same things.
Azure Hybrid Benefit reduced costs by facilitating an easy transition of on-premises databases to the cloud.
Microsoft Azure SQL Database is not cheap.
It greatly reduces the total cost of ownership through efficient licensing depending on the client, the cost savings, and hybrid benefits.
The most valuable feature of Microsoft Azure Cosmos DB is its real-time analytics capabilities, which allow for turnaround times in milliseconds.
Performance and security are valuable features, particularly when using Cosmos DB for MongoDB emulation and NoSQL.
The performance and scaling capabilities of Cosmos DB are excellent, allowing it to handle large workloads compared to other services such as Azure AI Search.
The simplicity in usability, along with improved organizational productivity where we no longer need to maintain on-premises SQL servers, is invaluable.
The Software as a Service model is more effective and easier to access in terms of security, as Azure provides security at the security layer, reducing the risk of breach.
Some of the best features of Microsoft Azure SQL Database are its scalability, pricing, and ease of setup.
Microsoft Azure Cosmos DB is a globally distributed, multi-model database service providing scalability, user-friendliness, and seamless integration, suitable for managing large volumes of structured and unstructured data across diverse applications.
Azure Cosmos DB is renowned for its scalability, stability, and ease of integration, offering robust support for multiple data models and APIs. Its capacity for handling unstructured data efficiently and providing real-time analytics makes it ideal for applications requiring high performance and global distribution. With features like automatic failover and integration with Microsoft products, users benefit from cost optimization and secure data handling. Enhancement opportunities include simplifying queries, improving documentation, and expanding backup and analytics functionalities.
What are the most important features of Microsoft Azure Cosmos DB?Azure Cosmos DB is frequently used in sectors like web, mobile, IoT, and analytics. It supports applications as a key-value store, processes real-time data, and enables global scalability with low-latency access. Its big data management capabilities and integration with Azure services enhance its utility across industries.
Microsoft Azure SQL Database is a relational database-as-a-service that delivers predictable performance, scalability, business continuity, data protection, and near-zero administration to cloud developers and solution architects. This is the deep technical library for Azure SQL Database.
We monitor all Database as a Service (DBaaS) reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.