MS SQL Server Industry standard database and comprehensive solution
May 17, 2021

MS SQL Server Industry standard database and comprehensive solution

Salvador Orochena | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

I currently provide consulting services to various clients. These clients use [Microsoft] SQL Server as the database for there financial system and CRM applications in addition to using for reporting and ETL processes.
  • ETL using SSIS to automate processes
  • Reporting Services to offer SSRS reports as a standard reporting interface
  • Data Analysis using stored procedure, views and transformations
  • Connectivity/Integration with other applications through ODBC, Linked Server, etc.
  • Simplify licensing
  • Data Analysis
  • Transactional Database for hosted applications
  • ETL tool
  • The ROI on data analytics is immense, this allow establishment of metrics and KPI's
  • The time saved through automations using ETL tool allows the product to cover ownership cost
[Microsoft SQL Server] offers a full solution, Inhouse Applications and hosted application continue to use SQL as backend database. Allows easy creation of development environments and continuous feature release.

Do you think Microsoft SQL Server delivers good value for the price?

Yes

Are you happy with Microsoft SQL Server's feature set?

Yes

Did Microsoft SQL Server live up to sales and marketing promises?

Yes

Did implementation of Microsoft SQL Server go as expected?

Yes

Would you buy Microsoft SQL Server again?

Yes

[Microsoft SQL Server is well suited] as a comprehensive solution as transactional database, data warehouse, analytics, reporting and ETL. Able to communicate with Azure database environment.

If you use other Microsoft applications, it integrates well such as Excel and Access.

If you have limited resources to support and maintain environment this may not be ideal compared to a managed service or SAAS solution such as Snowflake.