Microsoft SQL Server Reviews & Product Details

Microsoft Studio is powerful tool to keep program and manage database. Review collected by and hosted on G2.com.

Better realtime formatting in Microsoft Studio, and also better performance. Review collected by and hosted on G2.com.

It is simple, fast and reliable. Easy to backup and restore. It can handle a pretty huge load Review collected by and hosted on G2.com.

The cost of having a full version of SQL server running is pretty high Review collected by and hosted on G2.com.

We use SQL for both our ERP and our WMS systems, as well as CRM and payroll. Output from SQL queries can be exported to Excel, then filtered effectively and refreshed periodically as needed. Review collected by and hosted on G2.com.

Sometimes statements to pull data aren't intuitive. Review collected by and hosted on G2.com.

Best in the industry. This handles a lot of transactions Review collected by and hosted on G2.com.

Not open source. The Microsoft support first level is not so responsive. Everytime we end up moving to premier support Review collected by and hosted on G2.com.

Microsoft SQL allows me to visually or textually sort and manipulate my objects. Review collected by and hosted on G2.com.

I would like the dynamic help to be more exact and involved when I am not able to find what I am looking for - a db search option without having to install redgate would be great. Review collected by and hosted on G2.com.

I am just beginning to learn, but there are so many things I like. Mainly, the ability to extract the precise data I need has been the best part so far. Review collected by and hosted on G2.com.

For a beginner it can get confusing, it takes a while to really get a good handle on it and be able to really use it to its maximum potential. Review collected by and hosted on G2.com.

The industry standard today for all who work with databases Review collected by and hosted on G2.com.

Some minor tasks still need to be accomplished by installing add-ons Review collected by and hosted on G2.com.

Their performance and integration with other .net frameworks is superb Review collected by and hosted on G2.com.

I have not observed anything that gives me a feeling to dislike Review collected by and hosted on G2.com.

Performance while retrieving the data.

Compatible with several on the shelf products.

Storing the data is easier.

Support for the Kerberos and other security products.

It is useful to manage and obtain data from the network of networks.

It allows us to forget about the files that make up the database.

Asynchronous filling of objects, with the possibility of filtering objects according to their metadata.

Access to the SQL Server Agent in the replication servers for administration.

A new interface for viewing XML results.

Review collected by and hosted on G2.com.

uses a lot of RAM memory for installations and software.

Difficult to setup permissions and roles.

Support for writing and modifying queries or scripts without the need to connect to a server.

Archieving data is not easier. Review collected by and hosted on G2.com.

I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and helpful resources that are available. Thanks to the developer network, I’ve been able to learn much more about querying and build more useful and advanced queries over time. Things such as Transact-SQL (T-SQL) come in handy a lot of the time due to the vast amount of new queries you can build after learning T-SQL. Review collected by and hosted on G2.com.

I dislike that sometimes the developer network resources can be much more complex than I anticipated. Sometimes you just need a simple answer and not a lecture on every argument that can be used. I would also say that understanding certain failures or issues with SQL could by better documented by Microsoft instead of other community forums i.e. Stack Overflow. It would be nice if Microsoft had an error mapping for each SQL error and what the resolution for it might be. As far as I know, the easiest way to troubleshoot a query on runtime is to paste a portion of the error in to a search engine and then start going through the form pages. Usually within the first several web links, someone will have found a resolution that works. Review collected by and hosted on G2.com.