Small to mid-sized business review of Microsoft SQL Server
February 23, 2016
Small to mid-sized business review of Microsoft SQL Server
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
We use Microsoft SQL Server almost exclusively as our database solution.
- SQL Server Management Studio provides an excellent UI for developing in SQL
- SQL Server integrates well into the other business intelligence components of the Microsoft suite (e.g. SSRS, Integration Services, PowerPivot, etc.)
- My main issues with SQL were related to limitations in programability. For instance, it was once cumbersome to build things like running totals. However, recent releases (e.g. SQL 2012) have addressed some of these limitations
- MS SQL has definitely had a positive impact on our business. We have put very little into performance tuning or optimizing MS SQL to its full potential. However, for the most part, we have very few problems. This says a lot about how optimized the solution is out-of-the-box.
- Additionally, MS SQL's intuitive front-end development software (SSMS) has allowed us to query complex data structures which allow for critical business insight.
Access is simply too small and the options too slim for our current needs.