What users are saying about
109 Ratings
Top Rated
1064 Ratings
109 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
Top Rated
1064 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

Likelihood to Recommend

Apache Spark

Spark is great as a workflow process and extract transform layer process tool. Is really good for machine learning especially for large datasets that can be processed in split file paralallelization. Spark streaming is scalable for close to real-time data workflow process.what it's not good for, is smaller subset of data processing.
Anson Abraham 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

Apache Spark

  • We used to make our batch processing faster. Spark is faster in batch processing than MapReduce with it in memory computing
  • Spark will run along with other tools in the Hadoop ecosystem including Hive and Pig
  • Spark supports both batch and real-time processing
  • Apache Spark has Machine Learning Algorithms support
No photo available

Microsoft SQL Server

  • If configured correctly with the proper hardware, SQL Server can be incredibly powerful, delivering millions of data points in the blink of an eye
  • If you're just starting with relational databases, you would probably be fine with opting for an open source solution. However, if you need a solution that can handle an enormous number of requests and return results with considerable speed, SQL is worth researching to see if it fits your needs.
  • Managing database using SQL Server Management studio provides very good flexibility
No photo available

Cons

Apache Spark

  • Consumes more memory
  • Difficult to address issues around memory utilization
  • Expensive - In-memory processing is expensive when we look for a cost-efficient processing of big data
No photo available

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
No photo available

Likelihood to Renew

Apache Spark

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 10.0
Based on 5 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 profile photo

Usability

Apache Spark

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.7
Based on 8 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 profile photo

Reliability and Availability

Apache Spark

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 profile photo

Performance

Apache Spark

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 profile photo

Support

Apache Spark

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 8.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

Apache Spark

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 profile photo

Online Training

Apache Spark

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 profile photo

Implementation

Apache Spark

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.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

Apache Spark

It is easy to learn, read and to maintain. It brings the best of the Ruby on Rails framework from Java that helps to create a web service so easily. Communication is one of the most distinctive features of Apache Spark compared to alternative products. You are able to communicate with your colleague in your team who also uses Spark while you are on the phone.
No photo available

Microsoft SQL Server

We've evaluated a number of database platforms, including Oracle, MySQL, Interbase/Firebird, and MongoDB. While there are similarities in each of the platforms, one key difference is the tools included to administer and develop against the platform. We found that Microsoft SQL Server, hands down, to be the easiest and more robust toolset and have entrusted our organization with this technology.
John Orate profile photo

Scalability

Apache Spark

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 profile photo

Return on Investment

Apache Spark

  • By learning Spark, we can become certified and/or provide proper recommendations or implementations on Spark solutions.
  • With a background in Hadoop distributed processes, it has been easy to understand and diagnose how Spark handles the transfer of data within a cluster. Especially when using YARN as the resource manager and HDFS as the data source.
  • Staying up to date with the latest changes to Spark has become a repetitive task. While most Hadoop distributions only support Spark 1.6 at the moment, Spark 2.0 has introduced some useful features, but those require a re-write of existing applications.
Jordan Moore profile photo

Microsoft SQL Server

  • The return by using SQL Server, for us, is more due to the use of the Automation Anywhere tool.
No photo available

Pricing Details

Apache Spark

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

Add comparison