Why Choose a Product Based on MS SQL?
June 18, 2021

Why Choose a Product Based on MS SQL?

Rick Hahn | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

It is used as a back-end database engine for front-end client databases. Client is installed on user computers and it connects to a Microsoft SQL Server server for data.

Pros

  • It supplies a quick and easy way to analyze raw data when troubleshooting.
  • It gives the ability to easily create non standard ad hoc reports for clients.
  • It provides a standard platform for trouble shooting when we need to bring in engineers with advanced skills to solve problems.
  • It provides great tools for testing and development off line.

Cons

  • Configuration of the environment to create compatibility and restrict resource uses.
  • Configuration of connections in configuration manager.
  • Connection of data to other Microsoft products like Excel.
  • Data analysis.
  • Ubiquitous presence in the market (it is used everywhere).
  • Ease of use via Studio Manager.
  • High availability of skilled engineers who can be hired from the IT market.
  • The cost of a standard version is has created a barrier to closing business.
  • Support costs higher due to the level of skill to maintain.
  • It is standard in small and mid size businesses because of the amount of software written to use a Microsoft SQL Server engine.
It just boils down to why learn anther product when you are going to run across it so seldom. Developers determine what database engine I am going to need so I just tend to pick products for implementation that use a well know product that has lots of support resources available.

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

Not sure

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

My ability to support the recommendation with skills I have gained using Microsoft SQL Server. My ability to provide Microsoft SQL Server queries and stored procedures to others when supporting Microsoft SQL Server in an environment. Ease of moving data into Microsoft SQL Server. It does present problems when importing data from older versions or other sources and takes advanced skills in many cases. Installer is a bit baffling at times and you have to just know from experience what to check or uncheck in the process. Needs a better way to determine what version to use, where and with which licensing mode. Express version often fails for unexplained reasons even though the environment, data size, number of connections.... all are within spec.

Comments

More Reviews of Microsoft SQL Server

  1. Home
  2. Relational Databases
  3. Microsoft SQL Server Reviews
  4. User Review of Microsoft SQL Server