Microsoft SQL Server Reviews & Product Details

A fundamental pillar in databases is the security of the information stored there. Usually these are sensitive data that should not be accessed by unknown persons. SQL Server integrates tools that allow data encryption to prevent external attacks or any malware or virus. It also allows to protect the data of registered users for its use, activating the use of alerts in the case of previously established policy violations. Review collected by and hosted on G2.com.

It uses a lot of RAM for installations and software utilization.It has many page-level locks, a fixed page size and too small, a lousy implementation of variable data types. Review collected by and hosted on G2.com.

MS SQL has been around long enough and has enough distribution that there is a tremendous amount of information out there for any situation that you might encounter. If you can ask the correctly you can find the answer. It's relatively tolerant to crashes and can be scaled to any size or cluster configuration needed. Lots of add ons available as well as tools for optimization and troubleshooting. Review collected by and hosted on G2.com.

Microsoft's pricing has become borderline esoteric in it's level of complexity. SQL is now priced by CORE (not Proc), which can make it very expensive and confusing to license. It also needs proper tuning in order to work well - a small tweak can have huge performance issues. Review collected by and hosted on G2.com.

The best thing in Microsoft SQL Server is that we can easily process the SQL query. Review collected by and hosted on G2.com.

The dislike about the SQL Server is gets hanged or stucked. Review collected by and hosted on G2.com.

We are using SQL Server from 2014 and highly impressed with its simplicity and how its growing its capability with every version. server is a great database server with lots of features that are must for small or large scale companies. part is its user interface and simple to use.It is enabling developers to build their logic with intelligent window as well. Review collected by and hosted on G2.com.

We are not using any training for now as most of the features are free. Thank you Microsoft. I loved this platform. I dislike the only one thing is that licencing is too costly for small companies. Review collected by and hosted on G2.com.

Mainly the compatibility with Windows and Linux, my SQL bases control them efficiently with this system, Microsoft SQL generates error reports constantly to be aware of any inconvenience generated by the server. Review collected by and hosted on G2.com.

I have no problems with this service, everything works great. Review collected by and hosted on G2.com.

Good features for query optimization, good performance overall, plenty of documentation available on the internet. Review collected by and hosted on G2.com.

Some system procedures are undocummented. Review collected by and hosted on G2.com.

The good feature of this Microsoft SQL is their installation process. We don't need to install the pre dependent software forcefully it automatically gets installed during their update process so it's a quite easy way to install then any other databases. It also provides the facility of auto updation so by doing so their maintenance cost also get decreased then manually updating the whole system. Review collected by and hosted on G2.com.

Microsoft SQL can be used in a large scale company to a small scale business also so if there is a person who owns a small business then he/she may find it too much complex as it has higher functionality as compared to that business and also it's cost seems to be very high from them. Review collected by and hosted on G2.com.

The biggest advantage of the Microsoft Sql is their installation process which is quite simple as compared to many other databases servers. This is installed through the setup vizard and the primary things needed for their installation are detected automatically and then installed during this process so don't need to explicit install the dependency. Review collected by and hosted on G2.com.

The main disadvantage of using the Microsoft Sql is it's price which is very high.The person needs to first buy the license for this database then only then can use and price of license is very much high and in other databases this license is not required for using it so that seems to be the biggest disadvantage of using the Microsoft Sql Review collected by and hosted on G2.com.

SQL database have too good speed. It has a large database storage. SQL provides SQL corn job, Store procedure, Scheduling for create the report in shows data as per requirements. Data security is great. Review collected by and hosted on G2.com.

It's Installation process long and complex. Database backup can not restore if SQL version different. Review collected by and hosted on G2.com.

When you're working with MS SQL on its management studio, you do have this enterprise feeling, which is great because it gives you a secure notion that it sure is a solid solution. I use it every day at my job and we have a nice development workflow using the solution explorer that keeps your queries organized and neat. Review collected by and hosted on G2.com.

It is heavy. Be ready for that. You do need a development machine for this, not a personal laptop. Maybe your personal desktop PC is properly equipped, but I do not recommend having this on a low spec machine because you will feel a performance hit. Review collected by and hosted on G2.com.