SQL Server review
September 06, 2016

SQL Server review

Seth Werner | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

We use it to manage part of our enterprise ETL process.
  • Great catalog of online support
  • Intuitive interface
  • Very useful functions and methods not available on other platforms
  • SQL Server Integration Services, in my experience, is very buggy and crashes often. Needs improvement
  • I wish it was easier to retrieve current instance settings and configurations without going through much of the installation process again
  • Compatibility with Power BI suite is not intuitive and is less than robust
  • A great impact. Have been able to solve many complex business problems with ease and provide robust ETL solutions.
  • Some frustration in trying to recreate functions only available in SQL Server 2012 in SQL Server 2008 versions.
  • Solid impact in terms of consumption of reporting and dashboards through SQL Server Reporting Services.
SQL Server is definitely the go-to product for all things BI. It has its weaknesses, but other products like Oracle or Pentaho don't hold a candle to the power of SQL Server.
Great for complex querying and administration. Needs improvement on out-of-the-box ETL functionality.