What users are saying about
245 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
1319 Ratings
245 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.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
1319 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 100

Likelihood to Recommend

Hadoop

Apache Hadoop (and its subsequent add-ons) are well-suited to larger, unstructured data flows, such as aggregation of web traffic or advertising. Geospatial algorithms and their outputs are well-suited for this kind of aggregation as structuring that data is challenging, but leaving it unstructured and performing queries as-needed is a better fit for most business models. With the advent of data science, I would expect Hadoop fits a LOT of their initial outputs quite well.
Joe Hughes | TrustRadius Reviewer

Microsoft SQL Server

Since [Microsoft] SQL Server is a widely-accepted and popular database format, it is well-suited for smaller and larger environments, thanks to the different SQL Server versions available. SQL Server installation and configuration is fairly straightforward, and can be installed on different hardware, depending on needs. It may be less appropriate where simple database usage is required.
John Suit | TrustRadius Reviewer

Pros

Hadoop

  • HDFS is reliable and solid, and in my experience with it, there are very few problems using it
  • Enterprise support from different vendors makes it easier to 'sell' inside an enterprise
  • It provides High Scalability and Redundancy
  • Horizontal scaling and distributed architecture
Bharadwaj (Brad) Chivukula | TrustRadius Reviewer

Microsoft SQL Server

  • Good range of data types helps us store lots of diverse data
  • Easy administration helps us control who has access and what they can do with the data
  • Backup and restore processes are easy to manage and provide good security
  • Data can be easily replicated from Server to Server for use in other countries
Paul Nockolds | TrustRadius Reviewer

Cons

Hadoop

  • Hadoop is a batch oriented processing framework, it lacks real time or stream processing.
  • Hadoop's HDFS file system is not a POSIX compliant file system and does not work well with small files, especially smaller than the default block size.
  • Hadoop cannot be used for running interactive jobs or analytics.
Mrugen Deshmukh | TrustRadius Reviewer

Microsoft SQL Server

  • Enterprise is unbelievably expensive.
  • Not tolerant of bad practices and poor query writing, really shows up when you do it badly!
  • Deep insight into what is happening with query performance is not especially great (but as mentioned in the "Pros", software support from third parties does cover this).
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Hadoop

Hadoop 9.6
Based on 8 answers
Hadoop is organization-independent and can be used for various purposes ranging from archiving to reporting and can make use of economic, commodity hardware. There is also a lot of saving in terms of licensing costs - since most of the Hadoop ecosystem is available as open-source and is free
Bhushan Lakhe | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 6 answers
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
Lisandro Fernigrini | TrustRadius Reviewer

Usability

Hadoop

Hadoop 8.5
Based on 5 answers
Great! Hadoop has an easy to use interface that mimics most other data warehouses. You can access your data via SQL and have it display in a terminal before exporting it to your business intelligence platform of choice. Of course, for smaller data sets, you can also export it to Microsoft Excel.
Blake Baron | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.1
Based on 10 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

Hadoop

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

Hadoop

Hadoop 8.0
Based on 2 answers
No answer on this topic is available.

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

Hadoop

Hadoop 6.9
Based on 6 answers
We went with a third party for support, i.e., consultant. Had we gone with Azure or Cloudera, we would have obtained support directly from the vendor. my rating is more on the third party we selected and doesn't reflect the overall support available for Hadoop. I think we could have done better in our selection process, however, we were trying to use an already approved vendor within our organization. There is plenty of self-help available for Hadoop online.
Gene Baker | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 7.9
Based on 32 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

Hadoop

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

Hadoop

Hadoop 6.1
Based on 2 answers
Hadoop is a complex topic and best suited for classrom training. Online training are a waste of time and money.
Bhushan Lakhe | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
very hands on and detailed training
Srikanth S | TrustRadius Reviewer

Implementation Rating

Hadoop

No score
No answers yet
No answers on this topic

Microsoft SQL Server

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

Alternatives Considered

Hadoop

Not used any other product than Hadoop and I don't think our company will switch to any other product, as Hadoop is providing excellent results. Our company is growing rapidly, Hadoop helps to keep up our performance and meet customer expectations. We also use HDFS which provides very high bandwidth to support MapReduce workloads.
Anonymous | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server is one of the fastest RDBMS systems available in the market. Pricing is a bit on the higher side but all the features it provides pretty much justifies it. It can be integrated with a large number of frameworks thus enabling to work on multiple frameworks for your application without much worrying about the backend support or compatibility.
Anonymous | TrustRadius Reviewer

Scalability

Hadoop

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

Hadoop

  • Hadoop has allowed us to scale out a few of our tier-1, customer facing applications to provide very fast access to reports and analytics.
  • Hadoop was easily implemented by our Linux team and onboarded by our Hadoop Admins.
  • Hadoop has been a very stable platform and only goes down due to server patching or other maintenance.
Mark McCully | TrustRadius Reviewer

Microsoft SQL Server

  • With just one server we can easily host databases for many applications, which makes it easier to maintain.
  • The ROI on Microsoft SQL Server is very good as we have been able to set it and forget with out too much time invested in keeping it up and running.
  • The Microsoft SQL Server down time has been minimal and 90% of the downtime is due to our user error.
Anonymous | TrustRadius Reviewer

Pricing Details

Hadoop

General

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

Hadoop Editions & Modules

Additional Pricing Details

Microsoft SQL Server

General

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

Microsoft SQL Server Editions & Modules

Edition
Enterprise$13,748.001
Subscription$1,418.001
  1. Per License
Additional Pricing Details

Add comparison