Microsoft SQL Server makes it easy to focus on the important stuff
Anonymous | TrustRadius Reviewer
December 04, 2018

Microsoft SQL Server makes it easy to focus on the important stuff

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft SQL Server

Microsoft SQL Server is the database of used by all web applications. Hosted web applications that collect gigabytes of information directly store data into one or more Microsoft SQL Servers being used by our organization. We need these servers to not only store data but provide an easy means to make available to other software and services.
  • Easy to setup with the included Wizard that helps to get you up and running with the essential components covered. You won't waste a lot of time reading through documentation to just get started.
  • There is a large community of support for Microsoft SQL Server that can help to troubleshoot issues and explain how to tackle a problem.
  • The other components and modules to the system make is easy to setup backups and connections to other services.
  • I would like to see them overhaul the Microsoft SQL Report Server included. Its very outdated and lacks modern features.
  • I would like more artificial intelligence support to help make the databases run more efficiently.
  • I would like have better support for ORM management within the included Studio Manager.
  • With just one server we can easily host databases for many applications, which makes it easier to maintain.
  • The ROI on Microsoft SQL Server is very good as we have been able to set it and forget with out too much time invested in keeping it up and running.
  • The Microsoft SQL Server down time has been minimal and 90% of the downtime is due to our user error.
Since we run a .NET shop I'm not able to speak too much on how it compares to the alternatives. I would say in our dealings with MYSQL demonstrated that Microsoft SQL Server is less complicated to get up and running initially. The user interface of MYSQL seemed to be complex and require a lot of reading documentation before you could start running it.
With Microsoft SQL Server I can quickly develop a data storage solution for a .NET web application. The built in Visual Studio tool makes choosing Microsoft SQL Server an easy choice for getting up and running quickly. However it does require a large footprint, and would not be well suited for small applications where a NOSQL or static database solution would be more efficient.