Item: Microsoft SQL Server
Rating: 8
Author: Rich Mephan

Overall Satisfaction with Microsoft SQL Server

Use Cases and Deployment Scope

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.

Pros and Cons

Pros

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.

Cons

Would prefer more built in queries for DB optimization rather than having to find scripts on the internet.

Return on Investment

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.

Alternatives Considered

MySQL

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.

Other Software Used

Microsoft Dynamics CRM, Visual Studio IDE, MS SharePoint / SQL

Likelihood to Recommend

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.

Comments

Please log in to join the conversation

Using Windows? - Go SQL