1. Home
  2. Relational Databases
  3. Microsoft SQL Server Reviews
  4. User Review of Microsoft SQL Server
MS SQL Server is my favorite DBMS for more than 13 years
February 23, 2016

MS SQL Server is my favorite DBMS for more than 13 years

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

Overall Satisfaction with Microsoft SQL Server

We use MS SQL Server 2008R2-2012 as a data storage in our EDMS for our major client from the government.
  • Best out-of-the-box tools among enterprise scale DBMSs. SQL Management Studio is one of the best tools for almost all day-to-day tasks including deployment and support. In conjunction with other standard MS SQL Server tools it outperforms most other DBMSs I ever saw, including but not limiting Oracle and DB2.
  • Very powerful T-SQL.
  • Lots of data migration tools for easy integration with other data sources.
  • Great stability.
  • Native support by Visual Studio including database projects. You can deploy database updates even to production environment with literally 2-3 clicks. You may also generate diff script for manual analysis and deployment.
  • Price may seem tough.
  • Security model is a bit strange to get started but once you know a few particularities then nothing stops you from day-to-day tasks.
  • Overall MS SQL Server costs money and allows [you] to lower the costs for development and support stuff.
I've used many DBMS during my career including Oracle, DB2, SQLite and FoxPro. Since I'm more a technical guy, I personally prefer MS SQL Server more than others for its ease of use and development tools and features.
Technically MS SQL Server suits almost all middle-to-large use cases. However, be careful with high load scenarios and big non-relational data - you may get stuck with huge backups.