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.