Azure Cosmos DB vs. Azure SQL Database

NoSQL platforms are very useful when it comes to security, speed, accuracy, high accessibility with high read and write power. Everything is managed under the cloud and we have the various capabilities of Azure and support for Microsoft products with us. Flexibility in price and variety of features, as well as real-time results, are some of the popular [features] of this platform.

Incentivized

Your upcoming app can be built faster on a fully managed SQL database and can be moved into Azure with a few to no application code changes. Flexible and responsive server less computing and Hyperscale storage can cope with your changing requirements and one of the main benefits is the reduction in costs, which is noticeable.

Incentivized

• Turn-key geo-redundancy with multi-master writes is unprecedented and unparalleled in the industry!
• Guaranteed low latency makes Cosmos DB an excellent fit for most of our performance-intensive situations.
• The tunable consistency model simplifies so many challenges in distributed systems engineering that otherwise require advanced knowledge of computer science topics. I continue to be impressed at how Cosmos DB has abstracted away so much complexity.

Incentivized

• Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
• All the tools simply work after you are on Azure SQL Database.
• The applications do not need changes in order to start using Azure SQL Database.
• Hybrid Cloud scenarios will work.
• Clustering and failover - already there.
• You can start monitoring the use and extract performance insights in a new way in Azure.

Incentivized

• When searching by default, it is case sensitive, which must be changed by default
• In many ways, the price should be more flexible according to the requested facilities, because the price is very expensive for startup companies.
• It is not fully compatible with most common Streaming Analytics tools applications and developers should be worked on it

Incentivized

• A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
• Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
• Price can always be improved as well. It’s not bad, but room for improvement.

Incentivized

It's efficient, easy to scale, and works. We do have to do a bit of administration, but less now than when we started with this a couple of years ago. Microsoft continues to improve its self-management capability.

Incentivized

This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.

Incentivized

Like I said, Cosmos is the way to go. From all of the services that Azure has, Cosmos is very robust in terms of usability. It's ever-evolving and integrates with other applications seamlessly. The interface is pretty easy to understand. I implemented various solutions for my company and Cosmos was one of them.

Incentivized

It just works!

The support team is very responsive and we are generally satisfied with Microsoft support, in my opinion support team of a product and service is just as valuable as its quality and performance. Telephone answering, 24-hour hotline, email support and ticketing are excellent.

Incentivized

We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.

Incentivized

Azure Cosmos DB for MongoDB is more affordable than many other solutions and works incredibly well if you're within the Azure ecosystem.

Incentivized

Oracle Database is "the" serious database. There really is no competition in that field. SQL Database would be a serious competitor through the ease of implementation and the "no maintenance," but since it's too expensive for "normal" use (medium to small applications), it just priced itself out of the market, so to speak. Nevertheless, we do have 2 or 3 large applications that are highly integrated in azure, and for those it's just too easy to use SQL Database instead of the on premise Oracle Database with VPN gateways etcetera.

Incentivized

• Expensive but works if your infra is on Azure data center.
• No latency and nearly no downtime.
• Takes time for end users to adapt.

Incentivized

• We don't need a dedicated SQL dba because so many of the database maintenance operations are managed. A huge positive not only in budget but time constraints.
• The ability to scale quickly is the biggest positive as our data needs change constantly.
• Easy to migrate from legacy tools and systems, saving us on the need for redevelopment.

Incentivized