Microsoft SQL Server Reviews & Product Details

It's a Standard in industry like Oracle. Robust in data management and powerfull office integration. You can use it for every app you want to manage data. Review collected by and hosted on G2.com.

The price for very large servers is expensive. You need to purchase special licenses for each CPU even if the system is virtualized. Review collected by and hosted on G2.com.

This Database system is one of the best in the industry. I love the way it manage the information of the company. It never crash, if you patch it with all the patches. Review collected by and hosted on G2.com.

It consumes a lots of memory in the server. Other than that, its a good database software. Review collected by and hosted on G2.com.

as this product is of microsoft, so it is the best in user friendliness, very easy to use. loys of functionalities to interact with sql server database and perform varios tasks. Review collected by and hosted on G2.com.

not much cons i have faced using this but always have some issues with reinstallation of this. very difficult to remove each and every component. otherwise everything is good. Review collected by and hosted on G2.com.

I like its easy way to connect to any SQL server around the world, also I like the feature to extract data from live client's SQL tables to our testing server which save a considerable amount of time to backup and restore, also I feel very comfortable while querying data, I like also the verify "Check" feature before execute any query so I'm confident that my query will succeed before I executing it, It is very easy to connect to SQL and manage data from most of programming IDEs, also DB shrinking always save us to free big space for new clients Review collected by and hosted on G2.com.

It really needs to be more secured as before we deleted the data by mistake and finally we lost a client because we couldn't recove the deleted data completely. Review collected by and hosted on G2.com.

Its administration is awesome and very easy. You can also create your queries and run and debug them. It gives great user interfaces for all purposes from management to development. Review collected by and hosted on G2.com.

I wish they had formatting for query development. I would really like it to enable indentation and format my query to look smart. Review collected by and hosted on G2.com.

Many IT professionals tend to shy away from database management as they feel it to be tedious and require special knowledge. MSSQL, while complex, gives a UI that makes the system much easier to use. What I truly like best is the idea of what SQL supports, being able to create applications that run off of a SQL database, that streamline business operations. Often times, many businesses have a very manual way of doing things, but a simple C# (or other language) application can increase efficiency, visibility, and profitability very quickly. It is applications like Microsoft SQL that make these applications possible. Review collected by and hosted on G2.com.

The non-intuitiveness of security, or managing multiple users. For a company without a dedicated IT staff, scripting may be tedious. When I have came into an organization that had already or was currently adopting Microsoft SQL, the headache they experienced when managing the security of multiple (and new) databases was great. The previous statement rings true more so in an environment lacking active directory and containing a substantial amount of users. However, through building SQL statements, creating databases and copying security settings becomes a non-issues. All that to say, without someone who is familiar with databases Review collected by and hosted on G2.com.

I like that I can runn it across my network Review collected by and hosted on G2.com.

The biggest dislike is the price. I had to learn a different language for the environment Review collected by and hosted on G2.com.

Intuitive interface, easy to use backup and auditing.

Performance is great and easier to trace and resolve deadlocks

Integrates easily with other applications Review collected by and hosted on G2.com.

Microsoft licensing and SQL Server chews up lot of resources if not configured properly. So a good database administrator and good design is necessary Review collected by and hosted on G2.com.

We have had no issues with MSSQL since I have been working with it and that is very comforting. It has performed as advertised and I feel comfortable recommending it to others. Review collected by and hosted on G2.com.

I am not a fan of the licensing model and I think it is more expensive than it should be. Smaller businesses are often unable to afford it and have to use other SQL database options that are free or inexpensive. Review collected by and hosted on G2.com.

Better integartion of the multidimensional databases and managing datbase, performing queries Review collected by and hosted on G2.com.

Query optimization and perform more data queries complex Review collected by and hosted on G2.com.