Cassandra vs Microsoft SQL Server

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Cassandra
Cassandra

1.9K
1.5K
+ 1
445
Microsoft SQL Server
Microsoft SQL Server

3.6K
2.5K
+ 1
520
Add tool

Cassandra vs Microsoft SQL Server: What are the differences?

Cassandra: A partitioned row store. Rows are organized into tables with a required primary key. Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL; Microsoft SQL Server: A relational database management system developed by Microsoft. Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

Cassandra and Microsoft SQL Server can be primarily classified as "Databases" tools.

"Distributed", "High performance" and "High availability" are the key factors why developers consider Cassandra; whereas "Reliable and easy to use", "High performance" and "Great with .net" are the primary reasons why Microsoft SQL Server is favored.

Cassandra is an open source tool with 5.27K GitHub stars and 2.35K GitHub forks. Here's a link to Cassandra's open source repository on GitHub.

According to the StackShare community, Microsoft SQL Server has a broader approval, being mentioned in 478 company stacks & 443 developers stacks; compared to Cassandra, which is listed in 342 company stacks and 239 developer stacks.

- No public GitHub repository available -

What is Cassandra?

Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Cassandra?
Why do developers choose Microsoft SQL Server?

Sign up to add, upvote and see more prosMake informed product decisions

What are the cons of using Cassandra?
What are the cons of using Microsoft SQL Server?
What companies use Cassandra?
What companies use Microsoft SQL Server?

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Cassandra?
What tools integrate with Microsoft SQL Server?

Sign up to get full access to all the tool integrationsMake informed product decisions

What are some alternatives to Cassandra and Microsoft SQL Server?
HBase
Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google' Bigtable: A Distributed Storage System for Structured Data by Chang et al. Just as Bigtable leverages the distributed data storage provided by the Google File System, HBase provides Bigtable-like capabilities on top of Apache Hadoop.
Hadoop
The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.
Redis
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.
Couchbase
Developed as an alternative to traditionally inflexible SQL databases, the Couchbase NoSQL database is built on an open source foundation and architected to help developers solve real-world problems and meet high scalability demands.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
See all alternatives
Decisions about Cassandra and Microsoft SQL Server
No stack decisions found
Interest over time
Reviews of Cassandra and Microsoft SQL Server
No reviews found
How developers use Cassandra and Microsoft SQL Server
Avatar of Soundcloud
Soundcloud uses CassandraCassandra

Stitch is a wrapper around a Cassandra database. It has a web application that provides read-access to the counts through an HTTP API. The counts are written to Cassandra in two distinct ways, and it's possible to use either or both of them:

  • Real-time: For real-time updates, Stitch has a processor application that handles a stream of events coming from a broker and increments the appropriate counts in Cassandra.

  • Batch: The batch part is a MapReduce job running on Hadoop that reads event logs, calculates the overall totals, and bulk loads this into Cassandra.

Avatar of Brillium, Inc.
Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

Avatar of Vital Labs, Inc.
Vital Labs, Inc. uses CassandraCassandra

Cassandra is our data management workhorse. It handles all our key-value services, supports time-series data storage and retrieval, securely stores all our audit trails, and backs our Datomic database.

Avatar of Andrew Miller
Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

Avatar of David Flynn
David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

Avatar of SocialCops
SocialCops uses CassandraCassandra

While we experimented with Cassandra in the past, we are no longer using it. It is, however, open for consideration in future projects.

Avatar of Olo
Olo uses Microsoft SQL ServerMicrosoft SQL Server

Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

Avatar of ShareThis
ShareThis uses CassandraCassandra

We are using Cassandra in a few of our apps. One of them is as a count service application to track the number of shares, clicks.. etc

Avatar of Kaiko
Kaiko uses CassandraCassandra
Avatar of Arbor Health, LLC
Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

Managing script output and input, as well as data cleansing.

How much does Cassandra cost?
How much does Microsoft SQL Server cost?
Pricing unavailable
Pricing unavailable