Related Articles
Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Training
Customized training to master new skills and grow your business.
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Private Training
Cheat Sheets
Quick references for when you need a little guidance.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Affiliate Program
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
Reseller Partner
It's time to address your client's training needs.
Foundation
Learn how to get into IT with free training and mentorship.
Management Team
Discover the faces behind our success: Meet our dedicated team
Contact Us
How can we help? Connect with Our Team Today!
FAQs
Find all the information you’re looking for. We’re happy to help.
Here’s a fact: Cosmos DB is one of the fastest growing Azure services ever. Many of our customers say, we have SQL Server or Azure SQL DB or Azure Data Warehouse, should we be using Cosmos DB?
Let me tell you why you may want to. People are storing more data than ever, our data is more interconnected, plus we often don’t know the relationships ahead of time. Where Cosmos DB excels is on some of these new types of workloads that have increased complexity, semantics and size.
When you need extreme query workloads that may not scale through an RDBMS and you need to be able to do that while the schema’s evolving and adjust schema as you go, with Cosmos DB you get that scalability, a lower cost and the schema flexibility with sparse and semi structured data.
There are some query capability limits and portability can be an issue depending upon how you’re using it. But Cosmos DB solves most negativities. When you think about a SQL relational world, you think of something very structured and more measurable amounts of data. We can fetch order data and it’s compatible with a lot of tools.
But when we look at a NoSQL world, it fits well for volatile data and for very high read and write throughput. It can perform faster than SQL on the right workloads and it scales well. It also allows for rapid development since you don’t have to design the entire database schema to match all the questions you’re going to need to ask or to have that all identified right from the start.
This allows developers to quickly iterate in their application and change what they need on the backend in real time. Not only does this create a lot of flexibility for the development team, but also for the people designing and architecting the solution.
So, let’s get back to question; should you be using Cosmos DB? To answer this, ask yourself a couple questions: Do you have a data set that could benefit from a flexible schema set up? Do you have the need to query that data and be able to interconnect more data than ever before?
If you answered yes and you’re running into those typical types of NoSQL variables or workloads, then you should absolutely consider using Cosmos DB. If you’re already running Mongo or Maria, Cosmos DB has the ability to look like all those open source database platforms back to your application, plus you cut down on the amount of code, as well as work needed to bring that solution online.
Cosmos DB is incredibly powerful and fast. And it’s only going to get better as the team that’s working on it is committed to innovation. I recommend going through some of the hands-on labs for Cosmos DB on the Microsoft website. You’ll quickly know whether it’s a good workload for you and why it’s the one of the fastest growing Azure services ever.
If you have more questions about Cosmos DB and how it can benefit what you’re doing, you’re in the right place. Click the link below or contact us, we’re here to answer your questions and help you get on track using Azure for your business – no matter where you are on your Azure journey.
ABOUT THE AUTHOR
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment