1. Home
  2. Relational Databases
  3. Microsoft SQL Server Reviews
  4. User Review of Microsoft SQL Server
Best DBMS solution for professionals as well as beginners
September 12, 2019

Best DBMS solution for professionals as well as beginners

Anonymous | TrustRadius Reviewer
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.
  • 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.
  • 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.
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.
My rating is primarily based on the online community and forum support available for SQL Server. So far, whenever I have been stuck somewhere, I have been able to find help whether on the official SQL Server support forums or public forums such as StackExchange. I think using SQL instead of MySQL also goes in favor of SQL Server in that regard.

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

If you work with Spatial Databases, definitely go for it as it supports a wide library and the online community support is a real boon in case you are stuck anywhere. On the flip side, there are some performance issues with very long queries and the Enterprise costing structure also needs to be considered.