Microsoft SQL Server - reliable and stable product to meet all of your data needs
March 16, 2016

Microsoft SQL Server - reliable and stable product to meet all of your data needs

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

We are currently using Microsoft SQL Server across many different departments within our organization to integrate with a number of applications. Our development team uses it to integrate with various .NET applications and our data team uses it in all aspects of our department. We are able to address pretty much all of our data storage, reporting, ETL (extract, transform, and load) processing, data analysis, and other business intelligence needs.
  • It's stable and reliable - a mature product and known industry leader.
  • Easy integration across a number of applications.
  • Includes a number of powerful and easy to use tools as part of the entire product offering.
  • Requires a large "footprint" when installed in order to be best utilized. It would be nice if the overall size of it brought down.
  • High price tag. This could turn some organizations away in favor of free open source back end tools.
  • Performance tuning can be difficult, especially if you are non-dba type.
  • Positive - ability to scale
  • Positive - centralized data storage and warehousing capabilities
  • Positive - Third party application support
There's really no comparison between Microsoft SQL Server and MySQL tools. While the others, particularly access, make certain plug and play features easy to use (e.g. forms, simple reports), it can not offer the array of integration options and general scalability, performance, and power of Microsoft SQL Server. We use SQL Server for all those reasons.
The number of scenarios for which Microsoft SQL Server is well suited is probably too numerous to mention here. I'll include a couple: 1) Organizations handling a large volume of data - SQL Server offers best in industry performance and scalability 2) Data availability - allows for continuous access of data while always providing reliable backup functionality. May be less suited for organizations dealing with low data volumes and where budget is a concern.