Microsoft SQL Server Reviews & Product Details

Integrations with microsoft azure, power bi, excel etc

Ease of use

HA/DR

Performance tuning tools Review collected by and hosted on G2.com.

Licensing costs

Version compatability issues

Not open source Review collected by and hosted on G2.com.

Ease of integration with Microsoft power automate flows. I have created views and have run the scripts on data too. Review collected by and hosted on G2.com.

The design part of the view sometimes return errors while the query works successfully. Review collected by and hosted on G2.com.

The best thing about Microsost SQL Server is that it is user friendly. It is easy to integrate other tools like PowerBI, Excel with it which indeeds helps in streamlining workflows with ease.It provides advanced security feature which includes encryption and authetication making it a reliable tool. Microsoft offer many support channel. it includes 24/7 assistance and a diverse knowledge base. It is also useful for daily usage whether it's querying data from a database or generating reports. The installation and setup process of SQL server is straighforward. Review collected by and hosted on G2.com.

Although SQL Server is user-friendly, yet some features of it might seem challenging to beginners. For larger systems,setting up SQL server could take up ample amount of time which is a downside. Customer support is good but sometimes the response time could be high for things which has higher urgency. Review collected by and hosted on G2.com.

The best software which I use daily to analyze data Review collected by and hosted on G2.com.

Nothing as such negatives, sometimes the server is slow we should wait a long time to get a single query output, but server problem is common wherever you go Review collected by and hosted on G2.com.

Consistently stable, needs no special drivers on windows environments and secure Review collected by and hosted on G2.com.

Nothing really, it is a stable solution. Review collected by and hosted on G2.com.

Microsoft SQL Server is a database management system. It is widely used in many companies. It is very stable and can handle large volumes of data at a time. It is secure enough and roles can be assigned to users for access to the database. You can also use the SQL Server Reporting Services for analysing data. It is easy to get help from the Microsoft support team for any issues. Replication of a database is easy to do. Review collected by and hosted on G2.com.

It utilizes a lot of resources on the system that it is installed on. This can slow down the system thus making it difficult to use. Regular maintenance and monitoring is required. Review collected by and hosted on G2.com.

I love how they immediately let me know of my errors and the exact place the error is located Review collected by and hosted on G2.com.

There is nothing I dislike about sql server. Review collected by and hosted on G2.com.

I think this is the industry standard for SQL database, easy to use and learn, taught in most universities as the basis of SQL database. Review collected by and hosted on G2.com.

Advanced stuff are not that easy to learn, would be better if there are easy to read documentation for advanced things like SSIS, indexing, etc. Review collected by and hosted on G2.com.

Easy to learn syntax and well documented learning material. it also follow the statandard SQL syntax. Review collected by and hosted on G2.com.

Lack of protection against deleting the entire table since it does not make provision of where clause mandatory.

When you have sub-query on your query it allows the use of main query fields in the sub-query without explicitly referencing the main query table name or aliase, if this was done in error it will not raise any syntax error, it will just use the field of the main query if it's not found in the sub-query resulting with unexpected (and often unnoticed) results. Review collected by and hosted on G2.com.

Best place where your Data is securely stored, query and analyse easily with query language.

Outstanding Relational Database management application for big data.

Easily store data in relational form and query that with query language.

High speed processing with ACID properties.

Data transfer is also easy with Structured query language.

Sql helps you to interact with database with 100% uptime.

Using it as a developer from last 4+ years.

Worked with so many banking client and other domain also , they all used the SqL server because of the high performance.

Backups is also very helpful. Review collected by and hosted on G2.com.

Found difficulty while integrated with non Microsoft tool. Review collected by and hosted on G2.com.