Using Windows? - Go SQL
June 27, 2017

Using Windows? - Go SQL

Rich Mephan | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

SQL Server underpins all our line of business applications and is the database of choice for our case management application. It is used firm-wide from our helpdesk, through to the finance and HR teams. It is used to log support calls, time record and bill our customers.
  • SSMS provides useful tools such as the database tuning advisor - providing recommendations for missing indexes.
  • SSMS provides useful tools such as the SQL Profiler - Providing in-depth trace files of queries currently executing in your database.
  • SSMS provides useful tools such as the Activity Monitor allowing you to find expensive queries, resource waits, processes, and I/O.
  • Would prefer more built in queries for DB optimization rather than having to find scripts on the internet.
  • Without SQL server we would struggle to run our business.
  • Without SQL server we wouldn.t have a Case Managment System to sell to our customers.
SQL has better admin tools than other similar products and is cost effective in comparison to other products. As a Microsoft tech company, it made logical sense for us to select SQL Server.
If you are looking for a relational database management system that scales and provides multi-transactional support then look no further. It gives you ETL through integrations services, reporting through reporting services and cubes through analysis services. The administrative tools beat any other RDBMS available (Oracle for example); it is also much cheaper.