Small to mid-sized business review of Microsoft SQL Server
February 23, 2016

Small to mid-sized business review of Microsoft SQL Server

Anonymous | TrustRadius Reviewer
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.
Microsoft SQL is very-well suited for any small to mid-sized company. I don't have experienced with very large roll outs so I cannot speak to performance on a large scale. However, I have found MS SQL to be near-perfect for our institution. The reality of it is the business world is still well rooted in Microsoft products. Having MS SQL allows us to integrate easily with products like Microsoft Excel. Additionally, MS SQL has many front-end tools that allow for the automation of maintenance plans and monitoring. This is especially good for small to mid-sized companies that often find their IT personnel stretched thin. Finally, MS SQL is not as cost-prohibitive as some of the larger database solutions.