What users are saying about
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
1222 Ratings
10 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 6.4 out of 100

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>
Top Rated
1222 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 100

Likelihood to Recommend

Presto

Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
Praveen Murugesan | TrustRadius Reviewer

Microsoft SQL Server

I've found Microsoft SQL Server a robust and affordable solution for most OLTP scenarios, starting with department solutions up to enterprise-level systems. There are many advanced features (like compression and partitioning) that correctly implemented provide huge benefits on performance, reducing hardware requirements and costs. The default locking mechanism can be a problem for systems with high concurrency if the READ_COMMITTED_SNAPSHOT option is not selected.
Lisandro Fernigrini | TrustRadius Reviewer

Pros

Presto

  • Linking, embedding links and adding images is easy enough.
  • Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
  • Organizing & design is fairly simple with click & drag parameters.
Corinne Nacin-Martinez | TrustRadius Reviewer

Microsoft SQL Server

  • Easy to setup with the included Wizard that helps to get you up and running with the essential components covered. You won't waste a lot of time reading through documentation to just get started.
  • There is a large community of support for Microsoft SQL Server that can help to troubleshoot issues and explain how to tackle a problem.
  • The other components and modules to the system make is easy to setup backups and connections to other services.
Anonymous | TrustRadius Reviewer

Cons

Presto

  • Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
  • Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
  • UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
Praveen Murugesan | TrustRadius Reviewer

Microsoft SQL Server

  • There isn't as much that I dislike with SQL Server. It will be good to have features where we have fine grain control over internal things. For example, it would have been a good feature to have historical tracking of the metrics as opposed to setting up custom metrics. Overall SQL Server made my life easy to manage a lot of databases and ease of use while migration projects.
  • The database is the target of many attacks from it's SA account, this must come disabled by default and just after the instalation, some of 30 seconds, the attacks start, with many requests per second, it needs to improve the firewall to prevent these attacks, or put the SQL Server inside of a VPN and local network to avoid these attacks.
  • It requires knowledge and in-depth technical skills to make complex processes truly performing, especially if we are in very complex infrastructures
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Presto

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 6 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 | TrustRadius Reviewer

Usability

Presto

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 8.0
Based on 9 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 | TrustRadius Reviewer

Reliability and Availability

Presto

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 | TrustRadius Reviewer

Performance

Presto

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 | TrustRadius Reviewer

Support Rating

Presto

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 8.5
Based on 25 answers
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
luka horvat | TrustRadius Reviewer

In-Person Training

Presto

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 | TrustRadius Reviewer

Online Training

Presto

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 | TrustRadius Reviewer

Implementation Rating

Presto

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 5 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 | TrustRadius Reviewer

Alternatives Considered

Presto

Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
Corinne Nacin-Martinez | TrustRadius Reviewer

Microsoft SQL Server

The reason we've decided to go with Microsoft over Oracle or MySQL is because our company lives in the Microsoft ecosystem. It works well with other Microsoft products (Exchange, Office, etc.). It allows for easier integration. Also, the support from Microsoft is crucial, in case we run across complicated issues. They've helped as a lot. Our company actually maintained the largest Microsoft Dynamics database at one time, and there were several times we've had to reach out to Microsoft to fix unique errors and issues we had.
Anonymous | TrustRadius Reviewer

Scalability

Presto

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 | TrustRadius Reviewer

Return on Investment

Presto

  • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
  • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
  • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
Praveen Murugesan | TrustRadius Reviewer

Microsoft SQL Server

  • We can very quickly and easily start up a new database.
  • Active Directory integration has been a huge time saver for us.
  • It changed the way we did our data backup strategy by giving us a backup 4-5 times a day instead of once at night.
John Glenn | TrustRadius Reviewer

Pricing Details

Presto

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