Best DBMS solution for professionals as well as beginners
September 12, 2019
Best DBMS solution for professionals as well as beginners

Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
Microsoft SQL Server is being used as the default database management solution. It is used across the whole organization and is responsible for managing different types of databases such as ERP, Spatial and regular ones. SQL server caters to regular reports generation, establish relational queries between different datasets, provide backup in case of any issues.
Pros
- Microsoft SQL Server has a very user-friendly interface. It is a breeze to create and schedule jobs for data reporting and updates.
- The online community support and the numerous forums for Microsoft SQL Server are really handy in case of any issues.
- Microsoft SQL Server supports Spatial Databases which is a critical requirement for an organization like ours.
Cons
- It would be great if working with SSIS packages would be much more streamlined in the Microsoft SQL Server. As of now, the only option is to use Visual Studio which in itself is not very forthcoming in how to work with a package.
- The version upgrade can be a bit of nuisance in case you have different databases created on different versions of Microsoft SQL Server. The version compatibility for different databases can definitely be improved upon.
- It has helped in maintaining all our records in one place.
- Plus seamless integration with the data sources ensures and scheduled jobs to make sure that the data remains up to date.
- It has helped us explore advanced analysis by allowing to maps data as per spatial attributes.
- Oracle Database and MySQL
The major factor in favor of Microsoft SQL Server as compared to Oracle DBMS is its cost for small to medium enterprises. For larger organizations, Oracle DBMS's value is in being a bit more competitive but when it comes to smaller organizations, Microsft SQL Server is much more cost-effective. Also, personally, I found SQL Server Query language to be much more linear and easy to use as compared to MySQL.
Do you think Microsoft SQL Server delivers good value for the price?
Yes
Are you happy with Microsoft SQL Server's feature set?
Yes
Did Microsoft SQL Server live up to sales and marketing promises?
Yes
Did implementation of Microsoft SQL Server go as expected?
Yes
Would you buy Microsoft SQL Server again?
Yes
Comments
Please log in to join the conversation