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.
- Oracle, Microsoft Power BI and Pentaho
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.