SQL SERVER PREFERENCE
September 13, 2017
SQL SERVER PREFERENCE
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
It is used as a data storage engine and also for providing information to users based on the business user's requirement. It also supports multiple users' requirements. It is also used for reporting services for providing run time reports or summarized reports from OLAP cubes. We also use the various security features and different editions available based on the requirement and budget. I have been working with this product for over 15 years and I am a great admirer of how the product has evolved since 2000.
- In a single package, you get a data base/OLAP/reporting.
- Ease in using the best documentation and books are available for anyone to start working on it and use tons of features.
- Columnstore indexes need to be improved further even after many limitations were removed in SQL 2016.
- Pricing of the SQL Server license should be made more simple to be understand easily.
- Based on the features available and cost it always makes for a prudent decision to have SQL in the organization as the main data.storage.
- Some of the improvements are: Improvement in query response time without any changes in hardware, database, or application. Total cost of ownership (TCO) for storage dropped to the low end of the industry average scale. Forrester calculated a 3-year, risk-adjusted Return on Investment (ROI) of 100% with a payback period of six months after upgrading to SQL Server 2014.
SQL Server is way ahead of the support available and documentation available. Oracle should invest heavily in bringing good technical books on MySQL rather than putting documentation online and expect users to go through it.
Easy to manage all tools without extra cost is a big plus against any other RDBMS available in the market.