What users are saying about
102 Ratings

Microsoft SQL Server

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
976 Ratings
102 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101

Microsoft SQL Server

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
976 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

Apache Spark has rich APIs for regular data transformations or for ML workloads or for graph workloads, whereas other systems may not such a wide range of support. Choose it when you need to perform data transformations for big data as offline jobs, whereas use MongoDB-like distributed database systems for more realtime queries.
Nitin Pasumarthy 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

  • Machine Learning.
  • Data Analysis
  • WorkFlow process (faster than MapReduce).
  • SQL connector to multiple data sources
Anson Abraham profile photo
  • SQL Server is a whole package that usually connects well with other Microsoft products.
  • SQL Server has a large community of users for tips and advice on SQL programming.
  • SQL Server works fairly seamlessly with Power BI, Power Query.
Andy Erickson profile photo

Cons

  • Increase the information and trainings that come with the application, especially for debugging since the process is difficult to understand.
  • It should be more attentive to users and make tutorials, to reduce the learning curve.
  • There should be more grouping algorithms.
Carla Borges profile photo
  • One area that I'd like to see improve is it's monitoring toolset. While the built-in tools are good, I've found better 3rd party solutions that do a better job in this area (Embarcadero in particular).
  • Another area is backups. The out-of-box solution is good for small-to-medium sized databases. When your data gets large (gigabtyte/terabyte), then being able to have a robust backup solution with compression becomes critical.
  • Needs better out-of-box analytics and reporting tools. Again, the tools included in the SQL server package are good, but I find that we have to do a lot of workarounds to get these to work the way we need them to. However, for the most part, Reporting Services and Analysis Services are good toolset to quickly produce reports that would otherwise be too cumbersome with other tools on the market.
  • Integration Services is ok for the most part, but it lacks that Enterprise class level of robustness of an effective ETL tool.
John Orate profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft SQL Server10.0
Based on 5 answers
We have entrusted our organization on the Microsoft SQL Server platform due to its robustness and solid architecture. We have had very little downtime throughout the years and have found the platform to improve greatly with each new version. It's tight integration with the Visual Studio environment makes development much easier. Administration and maintenance is easy as well, utilizing its out-of-the-box toolset for ensuring that the database platform is running smooth and performing well.
John Orate profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft SQL Server9.6
Based on 8 answers
Because MS SQL Server is easy RDMS and secures at the same time. Also, MS SQL Server is a Distributed Transactional Tool. The Support is always On, Documentation and Learning are always active. Around the world, Microsoft has a lot of partnerships that can help if it is necessary to have an expert. Microsoft always has upgrades.
Rony  Vargas M. 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
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

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
Oracle is also a good RDBMS solution, but it is costly to train your workers on it, as newer ones tend not to have much exposure to Oracle. In that case, SQL becomes the best option, as most newly hired students know the functionality of SQL Server.Morever, support from a company like Microsoft is a big deal, and integration of SQL Server with software like Visual Studio--which is itself a leader in that sector--all of these are advantages that lead us to choose SQL Server.
Rahul Kumar Singh 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

  • Apache Spark has faster performance compared to MapReduce.
  • Combination of Python & Spark is the best. Shorter code, faster and efficient performance.
  • Can replace RDBMS
Kartik Chavan profile photo
  • Our organization is using SQL Server for its business, and we are quite happy with its ROI, so I would say SQL has positive impact.
  • Organizations have to invest money somewhere for the operations of a DBMS (database management system,) so why not choose SQL, considering its huge benefits.
Rahul Kumar Singh 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