What users are saying about

Apache Spark

97 Ratings

Microsoft SQL Server

Top Rated
931 Ratings

Apache Spark

97 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

Microsoft SQL Server

Top Rated
931 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

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

  • Ease of use, the Spark API allows for minimal boilerplate and can be written in a variety of languages including Python, Scala, and Java.
  • Performance, for most applications we have found that jobs are more performant running via Spark than other distributed processing technologies like Map-Reduce, Hive, and Pig.
  • Flexibility, the frameworks comes with support for streaming, batch processing, sql queries, machine learning, etc. It can be used in a variety of applications without needing to integrate a lot of other distributed processing technologies.
No photo available
  • 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.
No photo available

Cons

  • 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
  • I would like to see them overhaul the Microsoft SQL Report Server included. Its very outdated and lacks modern features.
  • I would like more artificial intelligence support to help make the databases run more efficiently.
  • I would like have better support for ORM management within the included Studio Manager.
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're constantly rolling out new applications on this platform.
No photo available

Usability

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.5
Based on 8 answers
Microsoft SQL Server is a sold and robust platform. We find it easy to administer, develop, deploy, and manage solutions on this platform. We have used this technology for over 20 years and have entrusted our organization to run on this platform on a worldwide scale. It has been one of the best business decisions we've made.
John Orate 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
Nothing is perfect but Microsoft does fairly well even though they're such a large corporation. SQL server has a large user base and there are a lot of support tools you can find without even calling Microsoft. The internet has a plethora of knowledge and help and Microsoft has also done a great job of making articles on their MSDN website that explain and layout a lot of different things with SQL. With that comes the fact that you still have to go to the internet or on the phone to get help sometimes.
Bill Starling 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

Apache Pig and Apache Hive provide most of the things spark provide but apache spark has more features like actions and transformations which are easy to code. Spark uses optimization technique as we can select driver program and manipulate DAG (Directed Acyclic Graph)Python can be used even for data transformations but it requires lot of coding compared to Spark and it is even so slow.
Kamesh Emani profile photo
I have used Microsoft Access, MySQL, and I have been a user of systems that run on Oracle database servers. All but Oracle are really intended for smaller scale projects and teams as they start to get slow or the performance will suffer once you start getting lots of data input and output into them. They are good for single user or single entry applications that can be maintained by almost anyone who understands databases. Oracle is a real competitor for SQL Server as it can handle large and small scale applications and data loads. It is competitively priced to SQL Server but I have heard it can be a bit tricky to work through in the back end. Since I only used applications that had Oracle databases on the back end I can only attest to the fact that the front end applications always worked just fine.
Bill Starling profile photo

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

  • 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 has made an extremely positive impact on our organization. It was been running our core business for well over 20 years (starting with SQL Server 6.5, and now on SQL Server 2012), so the ROI has been huge!
  • Our administrators and developers have been accustomed to this technology, so the learning curve from version to version has been very little.
John Orate profile photo

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