Microsoft SQL Server survives the test of time
April 13, 2021

Microsoft SQL Server survives the test of time

John P. Maher | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft SQL Server

I have worked with Microsoft SQL Server on many projects. The most recent was as the backend of an ERP system. The nature of an ERP system involved the entire organization from the shop which would use it to get the BOM (Bill Of Material) to build the parts to QA to check the parts to Purchasing to buy the raw materials to Sales to sell the parts to Shipping to ship the parts and even HR.
  • When properly maintained results are returned quickly
  • Backups and restores can be done quickly for testing
  • Support for common data access methods makes coding less painful
  • SSMS (SQL Server Management Studio) really helps IT in database activities
  • Debugging stored procedures can be done better
  • SSMS could be integrated more efficiently
  • Tasks that require many steps could be either streamlined or at the very least remember the data entered for each step
  • Multiuser support
  • Multiple databases on a single server
  • Backup and restore
  • The ability to connect all departments has a tremendous value
  • Administering the server is not too bad
  • Installing SSMS has improved drastically
I was not too impressed with Oracle. Following the manual prohibited installation. They did provide a phone number and explained the manual was wrong and provided me with the correct information with which I was able to install the product. This was awhile back and I do not know how it works currently.

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

Yes

Are you happy with Microsoft SQL Server's feature set?

Yes

Did Microsoft SQL Server live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Microsoft SQL Server go as expected?

Yes

Would you buy Microsoft SQL Server again?

Yes

Microsoft SQL Server is a good database and works well in all the situations in which I have used it. Although there are things that can be challenging or unintuitive but once they are learned you quickly forget how difficult or unclear they are. To be fair, other databases exhibit the same difficulties and overall, SQL Server provides great service in any situation where a multiuser environment is required.