What users are saying about
61 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
1150 Ratings
61 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.9 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>
1150 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Likelihood to Recommend

Amazon Aurora

Amazon Aurora is best suited for creating complex, highly available and commercial databases, in a very straightforward way. The database size should be medium to large because only then will you be able to justify the extra cost incurred for using Amazon Aurora. Another aspect is that if you are already using AWS and most of your applications and services are on the cloud, then it makes sense to use Amazon Aurora since it fits in the Amazon ecosystem really well.
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

Pros

Amazon Aurora

  • Performance: We utilize Aurora as a PostgreSQL replacement, and Aurora's throughput is up to 3 times higher.
  • Simple Instance Auto-Scaling: We can scale the underlying database engine up or down with no down time.
  • Auto-Growing Storage: Rather than having to over-provision, Aurora automatically adds blocks of 10GB to your storage cluster up to multiple terabytes of storage.
No photo available

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

Amazon Aurora

  • Just like AWS DynamoDB which is a not a SQL solution and is truly a global DB, it would be great if AWS Aurora can become a global DB. What that means is that it is multi-region multi-master. That way writes to different regions of AWS would all be in sync and available in replicas on different regions.
No photo available

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

Amazon Aurora

No score
No answers yet
No answers on this topic

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

Amazon Aurora

No score
No answers yet
No answers on this topic

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

Amazon Aurora

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

Amazon Aurora

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

Amazon Aurora

Amazon Aurora 7.7
Based on 3 answers
The support as a whole cannot be applied to just Aurora, but I must say that the response to our tickets from the AWS side was a bit anemic. Despite that, there is plenty of documentation and forum articles that should make anybody self-serviced. Again, let me stress this out - the product (in either MySQL or Postgres form) was used by many people and thus now well understood, explained and there are plenty of books and other material available. This is not the case that we encountered with NoSQL.
Arthur Zubarev profile photo

Microsoft SQL Server

Microsoft SQL Server 8.8
Based on 18 answers
Support is a mixed bag. It works so well you really don't need support except for some edge cases. However, you also are going to be hiring experts in databases, specifically with SQL Server experience, in order to setup and maintain your product. Luckily, SQLServer has the largest user group and most responsive out of all technologies. You just need to put in the effort.
No photo available

In-Person Training

Amazon Aurora

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

Amazon Aurora

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

Amazon Aurora

No score
No answers yet
No answers on this topic

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

Amazon Aurora

Using cloud-based services such as RDS or Aurora take all the hassle out of managing database servers yourself. It also gives you the flexibility to easily spin up and down additional instances and as when required. Where Aurora outshines RDS is in terms of performance - we saw around 2-5x improvement in query read times across the board.
Andrew Raines profile photo

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

Amazon Aurora

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

Amazon Aurora

  • The customers where we implemented Amazon Aurora database don't need to have an employee specialized in features and security upgrades.
  • The database replication and schedule for backup tasks are much easier, so less prone to errors.
  • We have never had a database downtime on our applications, which is essential for our customer business.
Vasco Mendes profile photo

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

Pricing Details

Amazon Aurora

General

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

Microsoft SQL Server

General

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

Add comparison