Hadoop vs Microsoft SQL Server | TrustRadius

What users are saying about

Score 8.4 out of 10

Based on 245 reviews and ratings

Score 8.9 out of 10

Based on 1319 reviews and ratings

Pros

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

Read full review

Bharadwaj (Brad) Chivukula

Sr. Engineering Manager/Delivery Manager

Nisum Technologies, Inc.Retail, 10,001+ employees

View all 35 answers on this topic

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

Read full review

Data Analyst / Scuba Dive Instructor

Haymarket PublishingMedia Production, 1001-5000 employees

View all 81 answers on this topic

Cons

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.

Read full review

Mrugen Deshmukh

Senior Software Engineer

San Jose State UniversityComputer Software, 51-200 employees

View all 35 answers on this topic

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).

Read full review

Verified User

Manager in Information Technology

Retail Company, 201-500 employees

View all 81 answers on this topic

Likelihood to Renew

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

Read full review

Senior Vice President

IpsosInformation Technology and Services, 10,001+ employees

View all 8 answers on this topic

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.

Read full review

Lisandro Fernigrini

Sr Database Administrator / Developer

Kapsch TrafficcomInformation Technology and Services, 51-200 employees

View all 6 answers on this topic

Usability

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.

Read full review

Senior Financial Analyst

Lowe's Companies, Inc.Retail, 10,001+ employees

View all 5 answers on this topic

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.

Read full review

Senior Consultant

NavigantUtilities, 1001-5000 employees

View all 10 answers on this topic

Reliability and Availability

No score

No answers yet

No answers on this topic

Microsoft SQL Server 10.0

Based on 1 answer

Its does not have outages.

Read full review

Sr MS SQL BI Developer

Georgia-Pacific LLCConsumer Goods, 1001-5000 employees

View all 1 answers on this topic

Performance

Hadoop 8.0

Based on 2 answers

No answer on this topic is available.

Microsoft SQL Server 9.0

Based on 1 answer

SSAS data cubes may some time slow down your Excel reports.

Read full review

Sr MS SQL BI Developer

Georgia-Pacific LLCConsumer Goods, 1001-5000 employees

View all 1 answers on this topic

Support Rating

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.

Read full review

Vice President, Chief Architect, Development Manager and Software Engineer

WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees

View all 6 answers on this topic

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.

Read full review

Software Engineer

King-ICTComputer Software, 501-1000 employees

View all 32 answers on this topic

In-Person Training

No score

No answers yet

No answers on this topic

Microsoft SQL Server 9.0

Based on 1 answer

It was good

Read full review

Sr MS SQL BI Developer

Georgia-Pacific LLCConsumer Goods, 1001-5000 employees

View all 1 answers on this topic

Online Training

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.

Read full review

Senior Vice President

IpsosInformation Technology and Services, 10,001+ employees

View all 2 answers on this topic

Microsoft SQL Server 9.0

Based on 1 answer

very hands on and detailed training

Read full review

Sr MS SQL BI Developer

Georgia-Pacific LLCConsumer Goods, 1001-5000 employees

View all 1 answers on this topic

Implementation Rating

No score

No answers yet

No answers on this topic

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.

Read full review

Database Administrator

AderantComputer Software, 201-500 employees

View all 6 answers on this topic

Alternatives Considered

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.

Read full review

Verified User

Engineer in Engineering

Computer Software Company, 51-200 employees

View all 35 answers on this topic

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.

Read full review

Verified User

Engineer in Product Management

Financial Services Company, 5001-10,000 employees

View all 81 answers on this topic

Scalability

No score

No answers yet

No answers on this topic

Microsoft SQL Server 9.0

Based on 1 answer

SQL server does handle growing demands of a mid sized company.

Read full review

Sr MS SQL BI Developer

Georgia-Pacific LLCConsumer Goods, 1001-5000 employees

View all 1 answers on this topic

Return on Investment

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.

Read full review

Senior Network Administrator

Vizient, Inc.Hospital & Health Care, 1001-5000 employees

View all 35 answers on this topic

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.

Read full review

Verified User

Project Manager in Information Technology

Individual & Family Services Company, 51-200 employees

View all 81 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

Yes

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Hadoop Editions & Modules

—

Additional Pricing Details

—

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.00¹
Subscription	$1,418.00¹

Per License

Additional Pricing Details

—

Add comparison