MS SQL- Great Tool!
June 01, 2016
MS SQL- Great Tool!
Score 9 out of 10
Overall Satisfaction with Microsoft SQL Server
Microsoft SQL is the company's backend. We utilize it for many different systems in place. It's the backend to our financial suite, to our internal and external CRM systems, to store financial data, etc. We heavily rely on it.
- It's a great database backend system. It will allow you to store a wide variety of databases and datatypes.
- It's easy to create and execute, stored procedures to automate tasks.
- It allows for us to set up a vast array of permission sets, so people who need to access it only can access the features they need.
- The latest implementation of SSIS does not work as well as the previous versions when it comes to importing datasets from Access or Excel files. Rather than using the datatypes in those source files, it tried to figure out the datatypes by looking at the first few columns. This has been frustrating for us.
- It would be good if SQL Server came equipped code checking. We currently use SQL Enlight to ensure that our code meets certain standards.
- It's allowed us to automate a lot of tasks, which in turn frees our staff up to focus on other things.
- We've built many systems with SQL Server as the back end. These systems are one of the main reasons we are able to attract new clients and keep the ones we already have.
- The cost for licensing is fairly high, but one we think is worth it.
The reason we've decided to go with Microsoft over Oracle or MySQL is because our company lives in the Microsoft ecosystem. It works well with other Microsoft products (Exchange, Office, etc.). It allows for easier integration. Also, the support from Microsoft is crucial, in case we run across complicated issues. They've helped as a lot. Our company actually maintained the largest Microsoft Dynamics database at one time, and there were several times we've had to reach out to Microsoft to fix unique errors and issues we had.
SQL Server is better equipped for larger companies due to licensing and maintenance cost. Smaller companies or individuals are probably better suited to use MySQL since it's free. However, the support Microsoft gives for SQL server has to be weighed, it's one of the reasons we are willing to pay the extra costs.