What users are saying about
Top Rated
74 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
976 Ratings
Top Rated
74 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 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
976 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 RDS

Amazon Relational Database Service is great when you need a Database solution that can work for you very fast. It is also a great solution when you need a system that can scale to handle very large amounts of data. You can get set up with a complex, large database eco-system in minutes/hours, and have the best security and backups scheduled. The alternative to doing this would typically be hiring one or more very experienced database professionals for not just the implementation, but also on staff to handle the periodic maintenance necessary.
Gabriel Samaroo profile photo

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

  • Getting the data in and out of our databases, especially with the close integration RDS has with S3 buckets.
  • Less overall management of the database servers. Our DBAs are now do more DBA work than server admin work, which moves them higher on the value chain.
  • Performance and Scalability.
No photo available
  • Administration is fairly easy. A SQL Server can be setup quickly and run without much management from a DBA. Some work is needed to configure the instances, but the platform tends to run very smoothly for us. Backups, index maintenance, and security are smooth and easy to set up, and with the GUI, we can make adjustments quickly, while still saving the underlying code.
  • Development is very easy for our staff of .NET professionals. The integration between .NET in Visual Studio and SQL Server means that there is little time spent working out how to build an application and we can focus on adding business value. Our work with Oracle and MySQL has required a bit more effort to understand the APIs.
  • Reliable. We use all versions of SQL Server, and we find that they are very stable. The systems backing SQLServerCentral, for example, are rebooted about once a year, usually to apply some security patches from Microsoft. We tend to stick to Service Packs as a means of updating our systems
  • Value. We receive a good amount of value for our use of SQL Server for the price we pay. We might pay less in initial costs for MySQL, but time loss, support costs to understand how the system works, and potential administrative issues may overwhelm that. It's a hard choice to make, but we do find our SQL Server costs to be reasonable.
Steve Jones profile photo

Cons

  • We have at times dealt with a few latency issues between RDS and our server instances even when they are in the same zone. This isn't a big deal if you're appropriately caching, but if you were to run a CMS, say Drupal, without caching on RDS from an EC2 instance it could be quite a bit slower than using a single box.
  • Occasionally Amazon will depreciate a particular version and you are forced to "do some work" to migrate your database in a time period you may not have anticipated. Not sure there is any way around this for anybody, but it's a thing to think about.
Justin Schroeder profile photo
  • SQL Server has certain limitations in terms of functionality of SQL management studio. But there are a lot of third party programming tools which are available in the market which is powerful enough to overcome these limitations.
  • Database comparison tool - Lack of a tool where you can compare entities of database like tables, views, indexes between 2 databases of the same application (like comparing production to stage sites).
  • Version control management system (to maintain different versions of code checked in / checked out). Had to be driven using 3rd party tools.
  • SQL replication - coverage for all 3rd party databases has been withdrawn in recent editions which are a limitation especially while migrating from previous SQL server editions. This is a gray area of SQL Server often challenged to due to limitations of integration to 3rd party software's like Oracle, MySQL etc.
  • Performance management tools - even though there are built-in reports like "Activity Monitor", they are existing to monitor the performance of SQL Server. It's better to have an individual console to connect to SQL server instead of depending on Windows or other 3rd party tools like APEX SQL console, IDERA tool to monitor SQL server performance.
No photo available

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
Because MS SQL Server is easy RDMS and secures at the same time. Also, MS SQL Server is a Distributed Transactional Tool. The Support is always On, Documentation and Learning are always active. Around the world, Microsoft has a lot of partnerships that can help if it is necessary to have an expert. Microsoft always has upgrades.
Rony  Vargas M. 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
Microsoft support is a world class organization. While there are challenges in resolving real world problems, the support team goes beyond the call of duty to provide the necessary expertise to get the issue resolved.
John Orate profile photo

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
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Bill Starling profile photo

Alternatives Considered

Honestly, there aren't a lot of great alternatives to RDS, and most likely the real alternative is just running an instance on your local box. While lots of other services (like Rackspace) offer hosted database solutions, RDS in my opinion, is the clear winner on price, availability, and failover support
Justin Schroeder profile photo
Microsoft Access while a data tool cannot scale to number of concurrent users or the great amount of files needed to run a business. Microsoft Access can attach to sql server as a backend but the interface is still limited to less than 20 concurrent users at a time.
No photo available

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

  • Much less time spent managing database versions, restores, cloning and uptime.
  • Allows us to create server clusters which can push our business goals.
  • Allows us to push the envelope of what's possible in our backend systems.
Justin Schroeder profile photo
  • 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 RDS

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