Microsoft SQL Server is a great database solution!
August 08, 2021

Microsoft SQL Server is a great database solution!

Pritesh Patel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

We currently use Microsoft SQL Server as our database application for our applications. We are using the Microsoft SQL Server jobs, Analysis services, cubes, and many other features to help provide front end data solutions to our customers. Our instance of Microsoft SQL Server also allows for multi-database implementation with full backup capabilities. We also pair with the latest management studio to get the best UI experience.
  • Easy to use with Visual Studio and ASP projects
  • Multiple options for Data Security
  • Industry standard and easy to use
  • Easy to install and configure
  • Licensing can get complicated
  • Very very expensive
  • combability issues and dependencies with servers etc
  • Microsoft support....you know
  • Data Security
  • ETL with SSIS
  • Database Management
  • UI is easy to use
  • Able to scale applications quickly and store large amounts of data
  • Able to backup customer data
  • Able to troubleshoot customer data easily and get support onboard easily
  • Quick and easy implementation and setup helps go-live quicker
Microsoft SQL Server is a comprehensive solution as transactional database, data warehouse, analytics, reporting, and ETL. It also integrates with the cloud well (Azure). The ease of use and setup makes this better than Oracle Database because the query syntax is also different for that one, and it's harder to support. MongoDB is great for small applications and mobile apps. If you have limited resources to support and maintain the environment this may not be ideal compared to a managed service or SAAS solution such as Snowflake.

Do you think Microsoft SQL Server delivers good value for the price?

No

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

Microsoft SQL Server is best for enterprise-level databases for data management. If you need to scale easily there are other options like Azure SQL, etc, but this also works best on bare metals servers. The licensing can get a bit complicated so it is not good for small companies/applications. I also don't think it is the best for mobile applications, etc.