Microsoft SQL Server Reviews & Product Details

Flexibility to create applications to specifically tailor custom requirements, especially in a pharmaceutical environment. Review collected by and hosted on G2.com.

There is nothing that I dislike about SQL. With the proper administration, the database will perform well. Review collected by and hosted on G2.com.

It can be used to handle vast amount of data with Sql and makes it easier to manipulate datasets for analysis. Review collected by and hosted on G2.com.

Lacks visualization features and also Sql syntax is too specific as compared to MYSQL Review collected by and hosted on G2.com.

We develop our product in C#, a Microsoft language, so it naturally follows we end up using Microsoft SQL. My favorite component of this is the SQL Management Studio. It's easy to navigate and it will come up with schema and table suggestions that make writing queries a lot simpler. Review collected by and hosted on G2.com.

I don't have much to complain about. The UI is a bit clunky for Studio. Review collected by and hosted on G2.com.

Works flawlessly with Windows Server. Very useful to have multiple databases and services manageable from a central location. Review collected by and hosted on G2.com.

Uses a ton of RAM. Somewhat expensive for small businesses to afford. Review collected by and hosted on G2.com.

The user interface of Sql Server Management Studio (what we use to query from Microsoft SQL Servers) is pretty intuitive. Coming from PLSQL, the transition was pretty easy Review collected by and hosted on G2.com.

I dislike some of the default settings, it takes a while to dig in and find the right settings. Specificially, if you create a new query page, it automatically queries the "master" instead of the specific database you were logged into. Review collected by and hosted on G2.com.

I really like the easy administration with sql server management studio, the hability to do querys with sqlcmd and the grand number of conector to develpment environments. Review collected by and hosted on G2.com.

It have a small limitations when creating specific querys with custom named columns. Review collected by and hosted on G2.com.

The ease of use using Microsoft SQL Server Management Studio is great. There is a vast amount of information available at my fingertips through the easy to understand user interface. The Data Transformation Services feature is a great feature that allows me to transfer data quickly and efficiently between other Microsoft SQL Server instances or to other database management systems. The Transact SQL language is very robust. Review collected by and hosted on G2.com.

Microsoft SQL Server Management Studio does however, force the use of bracketed database elements for table and column names. Review collected by and hosted on G2.com.

Ease and integration with Windows. Easy to create databases Review collected by and hosted on G2.com.

Overhead and cost is high for smaller companies Review collected by and hosted on G2.com.

What I like most about SQL is it’s scalability and ease of use. Years of development have gone into making the software function at a high level. Review collected by and hosted on G2.com.

I’m not always happy with the speed of queries but I’m pretty impatient when it comes to this sort of thing. Review collected by and hosted on G2.com.

Ease of use for replication setup, data packaging, OLTP, OLAP Review collected by and hosted on G2.com.

Derived models can/should be improved for SQL databases or imported databases. Better migration into SQL (mapping, etc.) can be offered without resorting to SSIS Review collected by and hosted on G2.com.