Overall Satisfaction with Microsoft SQL Server
We use microsoft sql server Management Studio and it's being used across the whole organization. It comes with the Microsoft security which makes it very reliable. We have a large QA team and microsoft sql server Management Studio allows us to copy and recreate servers as local servers very easily. This creates a "playground" in which QA and developers can test and create new features without affecting the production environment.
- Easy to clone servers and set up local dummy servers
- Easy to back up all information and write tables with all the data as a script
- Very flexible in exporting data from a wide range of files
- Add more files that can be exported into SQL
- Allow for more than one local server to be able to be set up
- Made tiny mistake on a script once and we lost data from two columns since the script kept on running (human error, the software can't be held accountable for this)
- Overall its so easy to integrate, that impact has been mostly positive
Better security and support scales at an easier level.