Microsoft SQL Server Reviews & Product Details

I love the SQL management to control all the DBS and SQL agents to handle the job for scheduling store procedure and integration services process. Also to send an email when a job fails Review collected by and hosted on G2.com.

It is a little limited to integrate other dbs. I have to use a linked server to create ODBC connects Review collected by and hosted on G2.com.

1. Easy UI

Ui is very easy to follow

2. Top of the line security

SQL is the pioneer for ACID properties

3. Easy Table management

It is very easy to control layout, column data type Review collected by and hosted on G2.com.

I don't like the old UI though it is very recognizable still it is old and also I feel that they should bring document type of database concept with maximizing CAP theorem Review collected by and hosted on G2.com.

Easy to understand and use. Very easy to export database and tables in the form of SQL query or a script. Review collected by and hosted on G2.com.

License is a bit costly for many organisations. When there is a complex query it would hit performance and takes more time to fetch the results. Review collected by and hosted on G2.com.

It's a traditional tool so you will find most of the developers who have knowledge on it Review collected by and hosted on G2.com.

Very slow on query fetching.

Not redundant.

Not too user friendly. Review collected by and hosted on G2.com.

An enterprise-scale Azure SQL Database that provides secure, scalable relational storage for our mission-critical applications. Review collected by and hosted on G2.com.

Management can sometimes be challenging. Review collected by and hosted on G2.com.

Microsoft SQL has an easy-to-use user interface. It can handle large data sets with great ease and can process queries very fast. The Query creation process is also straightforward, and the software yields accurate and fast results. It integrates easily with your front-end to capture data points, and the changes get reflected in the software instantly. You can fetch data from the data management software and generate views according to your requirements. Review collected by and hosted on G2.com.

Query Language needs to be studied before using it, i.e., people who don't have a Computer Science background might take time to get used to it. Error tracking, I feel, is challenging than the other options available. You also have to pay a fee for using Microsoft SQL, and you have good enough applications (My SQL) that are free of cost. Review collected by and hosted on G2.com.

I like the ssis jobs like how we can create Review collected by and hosted on G2.com.

Nothing as of now everything is fine in ssis Review collected by and hosted on G2.com.

I like that I am able to pretty easily manage my relational database through MS SQL Server. Review collected by and hosted on G2.com.

I dislike that the format for this program is sometimes different than other SQL servers. Review collected by and hosted on G2.com.

All the easy and quick functionalities to create the table, views, stored procedures.

There is query statistics and time execution for the stored procedures. Review collected by and hosted on G2.com.

As of now there are no points to dislike the SQL server. Review collected by and hosted on G2.com.

It is a query language tool to return multiple sets of records in the database. It is based on SQL (Structured query language). It can manage database and tables in a very effective manner.

We run different sets of queries in SQL Server Management Studio in our organization. Review collected by and hosted on G2.com.

The tool has multiple option and makes its layout a bit complex. But though the tool has everything which is required to manipulate the data and tables.

Our database records are private and protected as well.

In SQL server we do not get any UI like DBeaver to manipulate the data via a UI. Review collected by and hosted on G2.com.