Microsoft SQL Server Reviews & Product Details

the ability to query my database in any scenario to give me better insight on my data Review collected by and hosted on G2.com.

Not very intuitive, requires to research before using it correctly Review collected by and hosted on G2.com.

1. Execution Plan is very helpful in improving the query performance. They are really making it very simple to understand by showing it with nice UI.

2. Profiler helps in debugging and fixing issues in production and UAT environments, where we don't have direct access.

3. UI. Compare to other database tools like Toad for oracle and mysql, SQL Server Management Studio UI is nicely designed. Very limited buttons on screen, but clean and easy to use. Where as you have lot of buttons and options in Toad screen, but they are really confusing and difficult to find useful one. Review collected by and hosted on G2.com.

1. They could have given some better option to see that which server you have connected to, specially when you have multiple windows open and connect to different servers. Let's say you are connected to multiple servers and databases in separate windows, so there are changes that without looking at right side bottom on status bar you can run the query. You may run this in production or UAT environment :(. It happened with my ex. colleague.

2. If we can get font Increase option in sql server also like we have it in visual studio. This will really help when you work on bigger monitors. Font size is really very small in bigger monitor. Review collected by and hosted on G2.com.

It’s the best product to use for database Review collected by and hosted on G2.com.

Actually nothing it’s the perfect software to work Review collected by and hosted on G2.com.

SQL server can store large sets of data

We performed various functions to extract large sets of data. Review collected by and hosted on G2.com.

speed reduces if the data size is huge.

We cannot perform advance analytics like SAS, R etc.. Review collected by and hosted on G2.com.

Ease of use and ability to use tsql to perform data analysis Review collected by and hosted on G2.com.

Set up and installation needs more documenation Review collected by and hosted on G2.com.

SQL Server provides multiple options to choose for High Availability for e.g. Always ON, Database Mirroring, Replication, Cluster, Log shipping, etc. It support database snapshot and content databases which is very useful way of managing multiple DB requirements. Client tool is one of best add on, almost 99% of activities can be performed using intuitive GUI console, easy for newcomers and also provide advanced capabilities for advanced DBA's. It provides easy to use configurable options, vast online help for using it, it is certainly a very High available RDBMS system and reliable enough to provide 99.99% availability for mission critical applications. Other features I like about, MSDN, Microsoft community support, Powershell support for programming administrations and the list is endless. It do come with 180 days trial version and is a good way to start up with for new SQL Server administrators and developers. Review collected by and hosted on G2.com.

It doesn't provide portability to AIX/Unix based system, may be in near future it will come as Microsoft just announced some progress on same due to Microsoft R support. Review collected by and hosted on G2.com.

Easy to use as this is a main tool to ultilize data. Easy to transform and extract data Review collected by and hosted on G2.com.

It is not responsive sometimes. Sometimes it takes long time to process big data set Review collected by and hosted on G2.com.

I love the fact that SQL Server has been steadily getting better and better since it's initial release. Oracle dominated the database market at the time and SQL server was dismissed as a "tinker toy" database and not something ready for the enterprise.

SQL server is now world class, easy to use and the SQL Always On option is a really easy way to setup mirrored SQL sites for instant backup and disaster recovery.

The interface is point and click and, as expected, feels just like other Microsoft products. The ease of integration both into and out of SQL server make it ideal for all types of businesses large and small.

Oh...and SQLExpress (the free version) is usually good enough for development and test environment if you are short on $$$. Review collected by and hosted on G2.com.

Not much -- many of the annoying gaps have been plugged and it is pretty rock solid in terms of all the functions I need including backup/recovery, deployment, etc...

SQL server (like all databases) has benefited GREATLY from the general rise of available RAM and faster hard drives in everything from latptops to servers. Review collected by and hosted on G2.com.

ease of access ,price ,user friendly interface Review collected by and hosted on G2.com.

hard to scale because it don't run on linux Review collected by and hosted on G2.com.

Robust, ease of use. Great knowledge and support Review collected by and hosted on G2.com.

MS SQL Server is a complete end to end tool for database management Review collected by and hosted on G2.com.