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