Microsoft SQL Server Reviews & Product Details

MS SQL has matured into the enterprise database system it is today. Whether you need it for the backend DB for a simple solution to a full featured data warehouse, it has it all. I have seen the range of features cover businesses of all sizes. SQL has been around long enough to have proven validity as a scalable solution in business. Review collected by and hosted on G2.com.

Some basic automation tools that could be provided are unavailable. But, 3rd party tools come in handy in these situation (with the downside of additional cost). Review collected by and hosted on G2.com.

I like that it is simple and easy. There are lots of places where you can find help to improve yourself. Review collected by and hosted on G2.com.

The install can take a while. The files are big and there are lots of aspects that accompany the install. Review collected by and hosted on G2.com.

Simplicity of managing databases. Ui is intuitive and easy to follow. Review collected by and hosted on G2.com.

Permissions could use fine tuning. Not much granularity. Review collected by and hosted on G2.com.

Sql managemet gui is super essy to use.

Tsql is very intuitive

Nice integrations with vs Review collected by and hosted on G2.com.

That it only works on windows. I really wish i could run it on my mac or linux. Review collected by and hosted on G2.com.

We used this to organize our different classifications of mortgages and it worked well when it was launched to adhere all depts. Review collected by and hosted on G2.com.

It's pretty basic and some people may not find it user friendly Review collected by and hosted on G2.com.

I like that the software is easy to use and returns my data efficiently. Review collected by and hosted on G2.com.

Sometimes the software can be a bit clunky when compared to other software like SAS. Review collected by and hosted on G2.com.

The IDE (Management Studio) its very easy to use and it implements the basics of any SQL database Review collected by and hosted on G2.com.

Its to heavy to install it tooks a lot of hours to be installed Review collected by and hosted on G2.com.

One of the easiest databases I have used both in terms of development and querying. It is scalable and has a lot very good troubleshooting and support resources. Review collected by and hosted on G2.com.

I am very satisfied in general with this product but the query debugging could be enhanced. Performance optimization is not straight forward. It would be nice to have a wizard to guide you in this area. Review collected by and hosted on G2.com.

As it is from Microsoft some integrations are good. You can easily connect it with other Microsoft products and even some shortcuts will be similar. Review collected by and hosted on G2.com.

A lot of things actually

It's load with bunch of useless features.

It's slow as compare to opensource SQL software Review collected by and hosted on G2.com.

I like how it plays with Microsoft's family. You have your security from a domain standpoint. ASP plays nicely with SQL. All the standard query language can be used in SQL, so there's no learning curve if you already know about them. I do enjoy the local backup of the database, it allows me to control my backup and recovery instead of relying on the backup admin. Another key point is a stable SQL which makes it crucial; there's not a lot of crashes. Review collected by and hosted on G2.com.

I still cannot figure out why Microsoft has not put together a GUI for relational database. You have to type how the tables are related to one another. Another thing that I do not like is the Windows Update, every time SQL reboots, I have to make sure the services are back on. Sometime the services doesn't start which takes time to investigate why the service doesn't start. So always make sure to check the service and start SQL to see if you run into errors after a restart. Also, why does SQL eat up so much RAM? It's RAM thirsty. Review collected by and hosted on G2.com.