Microsoft SQL Server Reviews & Product Details

That we can focus on the data modeling, data science and data development as opposed to managing database infrastructure, security, availability and even performance.The elastic pool feature provides better resource utilization. Review collected by and hosted on G2.com.

During the migration from on-prem to Azure SQL, the available tools had limitations due to the differences in SQL Server and Azure SQL Review collected by and hosted on G2.com.

Restoring and backup of the database is great and can be configured easily step by step. MS Sql server has an excellent sql Editor which uses intellisense to write the efficient queries. Support of Hadoop for Big data management. Cloud support using SQL Azure. It provides ability to create user defined roles and provides desired permission. Review collected by and hosted on G2.com.

Help and support link are lazy in loading and does not provides detailed information in simple way. No information on the nre replacements for old backward compatible objects. Review collected by and hosted on G2.com.

Fast and secure connection make it one of the best SQL solutions. Also, the layout is very User friendly Review collected by and hosted on G2.com.

The SQL editor needs huge improvements in formatting options and shortcuts. The need to manually select and run queries is not convenient. Review collected by and hosted on G2.com.

Is a great DB manage tool, easy to query and solves a wide variety of issues for managing data within the applications, very easy to configure if you have and existing Microsoft infrastructure Review collected by and hosted on G2.com.

Is a high performance tool, takes a lot of memory, this makes the server slows down Review collected by and hosted on G2.com.

It has been the best tool in compatibilty when working on ETL process. The query processing time is very quick and users can easily see the data flow and get the reports as per the business requirement quickly. Review collected by and hosted on G2.com.

It can be quick while processing the query. More Data nodes can be included to accomplish this aim. The system does not provide any suggestions if the query is wrong which leads to wastage of time and reduces efficiency of work. Review collected by and hosted on G2.com.

It is easy to create the databases and the tables. Best thing I like is that it has a proper database export and import function provided to make the developer's life easier. Review collected by and hosted on G2.com.

Installation is a bit troublesome and the cost is also a bit high. Review collected by and hosted on G2.com.

Easily deployable and provides a robust database management solution for my infrastructure which contains Citrix, Microsoft system center suite of products and Ivanti work space environment manager Review collected by and hosted on G2.com.

Costlier licenses and storage intensive for a few applications Review collected by and hosted on G2.com.

The best thing I like the most is the infrastructure of the SQL server that allows me to query the high volume data. Review collected by and hosted on G2.com.

The only negative point would be the free version of it does not provide a bunch of benefits. Review collected by and hosted on G2.com.

Integrating MSQL is pretty straightforward with very few hiccups to address. Can be set up programmatically or through a wizard which is pretty niffy for some IDEs. It also is seamlessly added to Visual Studio Server Explorer in the Data Connections section. The best part? It's free! The majority of requirements are included in the free version unless you need some type of backup process and higher level activities which will move you into the paid bracket for MSQL. Review collected by and hosted on G2.com.

The UI query script interface could do with some improvements. I'm not personally a fan of the "select Top 1000" and "edit Top 200" options. There is a Query Designer but it's not intuitive at first glance which could be improved by some tutorial links. Review collected by and hosted on G2.com.

SQL Server is one of the best available Data Storage Software in the market.

1. We can write Stored Procedures that are pre-executed queries that run very fast.

2. Triggers are also a very good feature of SQL Server.

3. Dynamic SQL gives the ability to make SQL statements based on the conditions.

4. Can store images in the database.

5. Supports for Reporting Services. (SSRS).

6.SQL Server BI tools are a great feature.

7. Indexing is the feature to fastly retrieve the data.

8.SQL SERVER monitoring tool is also a great feature.

9. Joins - to join tables based on the foreign key and primary key columns. Review collected by and hosted on G2.com.

Dynamic SQL Queries still struggle with the issue of SQL Injection. Dynamic queries are a great feature but there is no perfect solution given by SQL for controlling the SQL injections in Dynamic Queries. Review collected by and hosted on G2.com.