Item: Microsoft SQL Server
Rating: 10
Author: Filip Grasheski

Overall Satisfaction with Microsoft SQL Server

Use Cases and Deployment Scope

MS SQL is used as a database(s) for the Symantec Management Platform. This basically means that it's used across the whole company as it holds data for all the supported machines. Moreover, the data for the DBs is used for reporting using MS SQL BI tools.

Pros and Cons

Pros

Great performance
Very easy to manage even for non-experienced users
MS SQL LocalDB is great if you're developer as it's very easy to use and it's free

Cons

Intellisense in management studio would be great improvement
Better GUI for LocalDB and SQL Express management

Alternatives Considered

MySQL

It has better support and it's a much more robust tool. Not to mention that it's a lot easier to manage.

Other Software Used

Symantec Client Management Suite, Visual Studio.NET, ASP.NET

Likelihood to Recommend

I can't think of a scenario where the product wouldn't be appropriate to use. It scales so well that you can use it for tiny DBs, like for example if one does web development. It also works well with huge DBs that not only can hold a lot of data, but it can be queried with very reasonable speeds.

Comments

Please log in to join the conversation

Very good DB that can be utilized for many different roles