What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
169 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
1124 Ratings

Redis

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
169 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 101

Microsoft SQL Server

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
1124 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

Likelihood to Recommend

Redis

Redis is great at at reducing your reliance on SQL and the cost associated with running a SQL infrastructure.We have been able to scale out and improve performance on database requests. Reliability has also great improved over running a SQL infrastructure
No photo available

Microsoft SQL Server

With Microsoft SQL Server I can quickly develop a data storage solution for a .NET web application. The built in Visual Studio tool makes choosing Microsoft SQL Server an easy choice for getting up and running quickly. However it does require a large footprint, and would not be well suited for small applications where a NOSQL or static database solution would be more efficient.
No photo available

Feature Rating Comparison

NoSQL Databases

Redis
8.3
Microsoft SQL Server
Performance
Redis
9.3
Microsoft SQL Server
Availability
Redis
8.8
Microsoft SQL Server
Concurrency
Redis
8.8
Microsoft SQL Server
Security
Redis
6.6
Microsoft SQL Server
Scalability
Redis
8.6
Microsoft SQL Server
Data model flexibility
Redis
7.7
Microsoft SQL Server
Deployment model flexibility
Redis
8.0
Microsoft SQL Server

Pros

Redis

  • Easy for developers to understand. Unlike Riak, which I've used in the past, it's fast without having to worry about eventual consistency.
  • Reliable. With a proper multi-node configuration, it can handle failover instantly.
  • Configurable. We primarily still use Memcache for caching but one of the teams uses Redis for both long-term storage and temporary expiry keys without taking on another external dependency.
  • Fast. We process tens of thousands of RPS and it doesn't skip a beat.
David Sommers profile photo

Microsoft SQL Server

  • If configured correctly with the proper hardware, SQL Server can be incredibly powerful, delivering millions of data points in the blink of an eye
  • If you're just starting with relational databases, you would probably be fine with opting for an open source solution. However, if you need a solution that can handle an enormous number of requests and return results with considerable speed, SQL is worth researching to see if it fits your needs.
  • Managing database using SQL Server Management studio provides very good flexibility
No photo available

Cons

Redis

  • We had some difficulty scaling Redis without it becoming prohibitively expensive.
  • Redis has very simple search capabilities, which means its not suitable for all use cases.
  • Redis doesn't have good native support for storing data in object form and many libraries built over it return data as a string, meaning you need build your own serialization layer over it.
Eric Mason profile photo

Microsoft SQL Server

  • The latest implementation of SSIS does not work as well as the previous versions when it comes to importing datasets from Access or Excel files. Rather than using the datatypes in those source files, it tried to figure out the datatypes by looking at the first few columns. This has been frustrating for us.
  • It would be good if SQL Server came equipped code checking. We currently use SQL Enlight to ensure that our code meets certain standards.
No photo available

Likelihood to Renew

Redis

Redis 9.4
Based on 12 answers
We will definitely continue using Redis because:1. It is free and open source.2. We already use it in so many applications, it will be hard for us to let go.3. There isn't another competitive product that we know of that gives a better performance.4. We never had any major issues with Redis, so no point turning our backs.
Rahul Chaudhary profile photo

Microsoft SQL Server

Microsoft SQL Server 10.0
Based on 5 answers
We are a Microsoft Gold partner and are very in depth with our SQL server development with out software and it would take too many resources to try and switch to another database product, not to mention all of our clients run SQL Server so we would then have to support SQL and another product which is fiscally irresponsible.
Bill Starling profile photo

Usability

Redis

Redis 8.4
Based on 3 answers
Redis has been around for very long and it is good at what it does. It proved to be very valuable in my use case for interfacing between two applications with very little code as it has drivers for almost every language out there and the community support is really good.
No photo available

Microsoft SQL Server

Microsoft SQL Server 9.8
Based on 8 answers
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
Andy Erickson profile photo

Reliability and Availability

Redis

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 10.0
Based on 1 answer
Its does not have outages.
Srikanth S profile photo

Performance

Redis

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
SSAS data cubes may some time slow down your Excel reports.
Srikanth S profile photo

Support

Redis

Redis 4.5
Based on 1 answer
Redis has lots of documentation publicly available so we do not require much support.
No photo available

Microsoft SQL Server

Microsoft SQL Server 9.1
Based on 15 answers
While its really convenient to use for me as a web developer, its fairly expensive to use in a production environment. I need to explain or justify the choice of using MS SQL Server against its pricing tier which is pretty expensive. We need to think about how to keep the whole infrastructure cost reasonable while keeping MS SQL Server.
No photo available

In-Person Training

Redis

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
It was good
Srikanth S profile photo

Online Training

Redis

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
very hands on and detailed training
Srikanth S profile photo

Implementation

Redis

Redis 7.3
Based on 1 answer
Whitelisting of the AWS lambda functions.
No photo available

Microsoft SQL Server

Microsoft SQL Server 9.7
Based on 4 answers
As mentioned before, the implementation of SQL Server in a company that is beginning to use a new structure, which does not require any type of data migration, do not requires particular comment to make.
If you must to do a porting of databases from a different platform, definitely you need to consider the situation in detail depending on your needs.
Luca Campanelli profile photo

Alternatives Considered

Redis

We are big users of MySQL and PostgreSQL. We were looking at replacing our aging web page caching technology and found that we could do it in SQL, but there was a NoSQL movement happening at the time. We dabbled a bit in the NoSQL scene just to get an idea of what it was about and whether it was for us. We tried a bunch, but I can only seem to remember Mongo and Couch. Mongo had big issues early on that drove us to Redis and we couldn't quite figure out how to deploy couch.
No photo available

Microsoft SQL Server

Microsoft SQL is so much easier to use. Getting data in and out of the RDS was so difficult we stopped using it. Microsoft SQL Server was so much faster and user friendly that we exclusively move all new databases to these servers instead of using services like RDS. With RDS we had a familiar interface in that we could use Microsoft SQL Studio Manager to access it but there was just way too many restrictions that we don't have in Microsoft SQL Server
John Glenn profile photo

Scalability

Redis

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
SQL server does handle growing demands of a mid sized company.
Srikanth S profile photo

Return on Investment

Redis

  • Redis has helped us increase our throughput and server data to a growing amount of traffic while keeping our app fast. We couldn't have grown without the ability to easily cache data that Redis provides.
  • Redis has helped us decrease the load on our database. By being able to scale up and cache important data, we reduce the load on our database reducing costs and infra issues.
  • Running a Redis node on something like AWS can be costly, but it is often a requirement for scaling a company. If you need data quickly and your business is already a positive ROI, Redis is worth the investment.
No photo available

Microsoft SQL Server

  • Our company's tools are based on SQL Server (mostly), so the name recognition and integration has certainly been useful to align with customer goals.
  • The easy integration of .NET tools has meant that we can easily build features for our systems without much effort on understanding APIs or connectivity.
  • The security integration with AD, and the Azure AD, means that we can extend our authentication to remote users without much effort or development time.
  • The costs of SQL Server have gone up over time, and these certainly impact ROI, especially for smaller applications.
  • I'm sure most platforms have bugs, and there are certainly some in SQL Server. The limited fixes or issues we've seen in a few cases of implementing certain database features have meant we needed to implement workarounds. We have also had some tuning issues with plan regressions, however these are likely to occur in many systems.
Steve Jones profile photo

Screenshots

Microsoft SQL Server

Pricing Details

Redis

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

Microsoft SQL Server

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison