SQL Server is great DBMS for corporate use
January 06, 2016
SQL Server is great DBMS for corporate use
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
SQL Server is widely used to support business needs across all organization. We use most of SQL Server features such as SSIS, SSAS, SSRS, Full-text search, and Always On.
- Advanced data transformation and ETL techniques with SSIS.
- Great platform for enterprise reporting with SSRS. You don't have to license each user like some other reporting software.
- Reliable DBMS engine with advanced options for replication, data recovery, change tracking, maintenance.
- Future support of Big Data and Predictive Analytics which matters for companies who want to get most value of its data.
- Easy to support and maintain with built-in maintenance plans and wizards.
- Extremely well documented.
- Sometimes needs CU to make things work right.
- Not all the features have meaningful error messages which forces the database administrator (DBA) to search the web on how to resolve such issue.
- It is very reliable so we can always focus on our primary job functions and not on troubleshooting SQL Server.
Microsoft is much more easy to use than Oracle. Also it is very easy to integrate with most of web technologies like .NET, ASP etc.