What users are saying about
44 Ratings

Microsoft SQL Server

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
979 Ratings
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Microsoft SQL Server

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

Add comparison

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

Microsoft SQL Server

Microsoft SQL Server is great for interaction with other Microsoft products, it tends to be the elephant in the room, you can't miss it. MySQL can be a much more compact installation and requires fewer licensing issues to deploy a solution. Setting up a quick database and querying the data with Power BI is becoming much simpler as these products mature. As long as you already have SQL Server installed somewhere, that is. Importing data into SQL Server from Excel is pretty straight forward and it automatically sets up fields fairly well.
Andy Erickson profile photo

Pros

  • Automated maintenance for upgrades is by far the most superior feature of Amazon Aurora. Never be behind on upgrades again!
  • Performance improvements for poorly structured schema due to enhancements added by Amazon.
  • Replication works flawlessly due to added security measures added into Amazon Aurora which prevents admin users from "accidentally" breaking the slave instance.
  • Amazon Aurora is hosted on Amazon's RDBMS which also includes quick and easy setup of new database instances.
No photo available
  • Fast and efficient compression on backups. Typically we see about a 65% reduction in size compared to the data file.
  • It just "works". We say this very little in IT but it really does just work. Almost every enterprise application out there works with it and the downtime is very minimal.
  • You have the opportunity to cluster servers. You can easily create a cluster of SQL servers to share resources instead of buying all new equipment and scattering the database footprint.
John Glenn profile photo

Cons

  • I'd like to see Amazon Aurora get ahead of the curve on MySQL and introduce their own improvements to MySQL to make it a superior database so that I don't need to use SQL Server or Oracle to get performance improvements. For example, improve performance of views.
  • Amazon Aurora needs to improve the ability to restore backups as needed. Currently, the user can only restore an entire instance to a new or existing RDBMS instance. If you need to retrieve data from a single table, this can be tedious after waiting hours for an entire restore to complete. Instead, allow the user to select a database to restore. Better yet, allow the user to restore a database backup to ANOTHER database - which would allow you to restore a database on the same instance.
  • Again beat MySQL to the punch and introduce REAL server to server communication since they have disabled the "Federated Engine" which was the only way previously to do this. I'd like to be able to setup MySQL instances to talk to other MySQL instances.
No photo available
  • Implement features to process unstructured data easier
  • Increase performance speed
  • Add multiple results table in the same window
Darren Deng profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 5 answers
We have entrusted our organization on the Microsoft SQL Server platform due to its robustness and solid architecture. We have had very little downtime throughout the years and have found the platform to improve greatly with each new version. It's tight integration with the Visual Studio environment makes development much easier. Administration and maintenance is easy as well, utilizing its out-of-the-box toolset for ensuring that the database platform is running smooth and performing well.
John Orate profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.6
Based on 8 answers
Microsoft SQL Server is a sold and robust platform. We find it easy to administer, develop, deploy, and manage solutions on this platform. We have used this technology for over 20 years and have entrusted our organization to run on this platform on a worldwide scale. It has been one of the best business decisions we've made.
John Orate profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 1 answer
Its does not have outages.
Srikanth S profile photo

Performance

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
SSAS data cubes may some time slow down your Excel reports.
Srikanth S profile photo

Support

No score
No answers yet
No answers on this topic
Microsoft SQL Server8.2
Based on 5 answers
We've had problems with support bouncing the incident around between groups or engineers and having to repeat information that was already presented.
No photo available

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
It was good
Srikanth S profile photo

Online Training

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
very hands on and detailed training
Srikanth S profile photo

Implementation

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.7
Based on 4 answers
Make sure that all teams are fully represented in project meetings and planning. You'll need full involvement from networking, Windows, security, application teams, architects, and DBAs.
No photo available

Alternatives Considered

In the end, we went with Amazon Aurora due to the decent performance and cost. Cost was determined in two ways for us: 1) no additional license is required (such as using SQL Server or Oracle) and 2) the ability to cut down on needed resources to maintain the system from the maintenance perspective due to the built-in maintenance capabilities. Amazon Aurora is also based on MySQL (soon to include PostgreSQL ) which allowed my team to quickly and easily move our existing MySQL servers to a faster system.
No photo available
Microsoft SQL Server is what my company purchased and available for us to use. Everyone in my department uses Microsoft SQL Server. I think mainly it's because of its affordability. Also, its functionalities are enough for our day to day operations since the size of data we analyze are usually not too large.
Darren Deng profile photo

Scalability

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.0
Based on 1 answer
SQL server does handle growing demands of a mid sized company.
Srikanth S profile photo

Return on Investment

  • Aurora Serverless has allowed us to inexpensively implement best-practices for our microservices architecture.
  • Aurora is mostly managed; our engineers can focus on features instead of database administration.
  • Aurora is capable of high throughput. Speed is not our first priority, but we still benefit from it.
No photo available
  • Microsoft SQL server is priced less as compared to other enterprise database choices. This makes the initial investment more cost effective and in turn reflects better ROI.
  • Microsoft is easy to use and administer. Resources are readily available to support SQL Server. Microsoft SQL Server Management Studio makes life simpler when it comes to basic database administration tasks. As resource cost to maintain SQL Server is much less, it helps in gaining more positive ROI.
  • ROI can easily turn into negative side if solution evolves into a complex enterprise one, requiring better performance and bigger size of data. SQL Server cannot handle enterprise data as well as Oracle. Detailed architectural planning is needed before choosing SQL Server for an enterprise solution as the cost to move from SQL later could be more.
Ved Mishra profile photo

Pricing Details

Amazon Aurora

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

Microsoft SQL Server

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