Microsoft SQL Server Reviews & Product Details

Works well enough like any other relational database, though I always love using Microsoft native tools. I think that I would specifically choose to use a Microsoft SQL database over a MySQL just for the known brand/name and the expected stability and vendor support. Review collected by and hosted on G2.com.

The built-in management tools are too bloated. It takes a while for them to load up, and when they do often they feel more clunky than they should for such an enterprise product. I also feel the security, while important and tight, is often too difficult to navigate based on roles, users, etc. It may be more suited to larger deployments with dozens of unique roles and users within them. Review collected by and hosted on G2.com.

Simplistic SQL development tool from MS. Brings convenience to developers at ease. Review collected by and hosted on G2.com.

This works like a charm - I don’t have anything to dislike at all. Review collected by and hosted on G2.com.

What's best is the ability for seamless auto encryption for passwords. Today with data hosted in azure, security is of utmost importance.

I like it's capability for Automatic database tuning, New graph database capabilities, In-memory enhancements.

Review collected by and hosted on G2.com.

The aggravating part is where SQL Management Studio has been split apart from the database engine at installation. We would have to search around searching for the right version compatible with it's corresponding database engine version. Review collected by and hosted on G2.com.

Equipped with different tools like sql profiler, tunning advisor and sql search. This really make life easier. Solve business level problems using ssis and ssrs. Big brand Microsoft another advantage. Review collected by and hosted on G2.com.

Need to improve in resource utilisation. Should take less cpu usage. Should not rely on thrid party' service when itself can built better. Review collected by and hosted on G2.com.

I like the easy way to query any data in any DB, it helps me analyzing data, also I like the easy way to control the access to the live DB by granting users the appropriate permissions, also I like that I can preview data from more than one SQL server, and I can export data from one to another very easily from DB tasks, also I like the DB shrinking feature and SQL replications to save data secured in another server, also I like the descriptive error messages. Review collected by and hosted on G2.com.

It hangs sometimes and data is not secured enough. Review collected by and hosted on G2.com.

Its user friendly, GUI is designed in a very nice way for DBAs and users to work upon. High Availability technologies like Always-ON in SQL Services provides lots of benefits for 24*7 availability Review collected by and hosted on G2.com.

Didn't find anything so far. I loved this product since Day 1 . Review collected by and hosted on G2.com.

It's my predefined database engine, our servers, our Mcrosoft-based services are fine-tuning and linking perfectly Review collected by and hosted on G2.com.

It requires a more robust computer than usual, it could be lighter for small and medium enterprises. Review collected by and hosted on G2.com.

Ease of use and cost and capabilities of the product. Review collected by and hosted on G2.com.

I would like to get more granular in backups, but it can be done with a little more work. Review collected by and hosted on G2.com.

It's easy to use. I am accoustomed to it. Review collected by and hosted on G2.com.

Toad offers addition capabilities while returning the query. I canuse that in the tool Review collected by and hosted on G2.com.

I like SQL query designer which provides me the flexibility to drag and drop tables to creates queries. It also helps me identify how tables are interlinked with foreign keys and dependencies within one or multiple databases. I like how we can create scheduled job task and maintenance plans using SSMS. Review collected by and hosted on G2.com.

I dislike debugging temp tables in stored procedures and functions. We cant keep the interconnecting while debugging stored procedure which is, in turn, calling other stored procedures/ functions. I wish we can see run-time variables and view in command window like visual studio.net. Performance debugging one which part taking time is also difficult to predict without third parties. Review collected by and hosted on G2.com.