My opinion on using Microsoft SQL Server
January 21, 2019
My opinion on using Microsoft SQL Server
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
Microsoft SQL Server is used as a relational database management tool by our organisation. It's mostly used by every department in our corporation to insert, update, delete, manage data and to provide various encryptions to it.
- SQL Sever supports multiple users in one setup which make it a multiuser system.
- SQL profiler tracks the background queries and helps with the debugging and management of SQL queries
- By analysing estimated and actual test plans, it helps to make queries more optimized
- Issues exist when restoring a database for low screen resolution system. This should be debugged and corrected.
- Doesn't auto backup an unsaved query window. So when SQL server is restarted it [loses] previously unsaved work.
- Hanging issues while booting SQL Server.
- SQL Server has a positive impact on our corporation.
- Our company owns the SQL Server Enterprise edition. The return is pretty good when investment is done with SQL Server.
It works well with Microsoft Visual Studio IDE. We use that for the development of applications.