Microsoft SQL Server Reviews & Product Details

MS SQL is probably one of the top 3 most essential software which we have in our organization. It was introduced by Microsoft some 12-15 years ago and from that time, they have kept on improving it in every release. It comes packed with default integrations like "SQL Server Management Studio " which helps the developer in fine-tuning the database and also helps to form better and faster queries. The Free version for the developer is the icing on the cake because in free version also they give you around 25GB of space for creating/editing/deleting databases. We always start our new projects on the free version and then move onto the paid version, once the database entities are well defined.

The creation and maintenance of the databases are super simple and straightforward. The query language is quite easy to learn and once you attain a good exposure in them, you can write very useful and time-saving scripts. It supports APIs as well which makes it the best to integrate with other software because they can make an inquiry through the API's which is supports. Scheduling the auto backup and alerts in case of failure is another highly sought after quality because it notifies all the concerned parties that something of this nature has happened. The setting up of security and provisioning different user ids with different levels of access is very straightforward and resourceful too to keep in check that only the required person has access to that table and not everyone. It provides all these features but still, you will never face any lag or slowness, the queries will bring back the results in milliseconds. Review collected by and hosted on G2.com.

This software does the job very well but nothing is perfect and always has scope for improvement. The main thing which I'll like to see getting better is resource management which the software does because if you are running it on an old system with a small RAM. then it can slow other applications considerably because it ties up most of the resources with itself. Another thing which I find troublesome is that it is primarily a windows software and does not support other OS that well and which limits the usability to a large extent especially if you are having a mix of both the OS in the organization. Review collected by and hosted on G2.com.

the high performance programming capability for highly transactional, heavy workload and high usage database system. SQL programming gives various ways to describe the data more analytically. Review collected by and hosted on G2.com.

Schema migration lack db support. For example if you define an index on a field, typically you are required to name it and people name it after the field name(s). Renaming fields later will not suggest, require or perform renaming of the index leaving you with not-so-helpful index names. Database does not store history of migrations, so you may accidentally add or miss one when you try to manage them. Review collected by and hosted on G2.com.

The community of Microsoft is so much strong that it had made any thing possible for us to do, if you were struck in any issues and you don't have the solution for it then google it and the community has already the answer to give to you. Review collected by and hosted on G2.com.

The lack of Monitoring tools and the GUI feature in the Monitoring tool is the main reason i dislike this database as we have to purchase the other 3rd part tool like IDERA, APEX SQL and etc. so if we have to integrate more third part software's like IDERA they have a agent running on the SQL Server database server and this is the possibility that the SQL Server performance could be downgraded and have a low performance. Review collected by and hosted on G2.com.

We can easily manage huge data by ms sql, process of insert, update, delete are eaisly done. When we are calling data in our project than we use store procedure for better performance. Review collected by and hosted on G2.com.

When we connecting it throw data base providing correct user name and password but its not connecting. We also cause difficulty for changing user name and password. Review collected by and hosted on G2.com.

the ease of querying language and the support for scheduling jobs easily Review collected by and hosted on G2.com.

it has to be used with MS SQL server management studio to use it easily Review collected by and hosted on G2.com.

Working on SQL server with stored procedure is the most precise way of connecting database with our own appliacation. Review collected by and hosted on G2.com.

Freezes sometimes when doing larger database transactions.

Opening design view takes more time to load. Review collected by and hosted on G2.com.

user friendly easy interface and wizards

with a certain level of knowledge , easy to run and manage

reliable and get job done

good return for investment Review collected by and hosted on G2.com.

like in all software, there is always some improvements to be done

especially adaptability to the large sized databases and data sizes Review collected by and hosted on G2.com.

Easy to use , user friendly tool. Quality of the product is also excellent. Less bugs and integration Is also very easy Review collected by and hosted on G2.com.

Would have preferred to have more short cut keys or commands Review collected by and hosted on G2.com.

SQL server is very easy to learn and use, it has a lot of nice features out of the box and a lot of online documentation. I also appreciate other modules that perfectly integrates with it like SSRS and SSIS Review collected by and hosted on G2.com.

Besides the cost and compatibility related aspects which are not top of the market in general (although I do not see as real issue around this in many medium/large organization), I would also mention a couple of details: I used to be an Oracle user too, so what I miss in SQL is: default message for Commit statement confirmation and a more powerful Explain & Execution plan functionality.

I also found the Oracle Grants system much more "robust" and somehow easier to manage after an initial learning curve, than the SQL logins/principals/database concepts. Review collected by and hosted on G2.com.

I like that I can find any information from the database with a query. I can link tables together in order to get all the information I need from different tables. I can change the status of items in the software through a database query. Review collected by and hosted on G2.com.

How some of these database tables are designed but that's all on the particular designer of the database, not the software itself. Review collected by and hosted on G2.com.