Microsoft SQL Server Reviews & Product Details

The way it manages the data/ tables and eaee of access. Review collected by and hosted on G2.com.

I suppose it would be good if it can be portable to different file format so that it can be saved easily... Many times it does not upload to one drive if it is huge size. Review collected by and hosted on G2.com.

The simple queries and structures can be used by any new learners Review collected by and hosted on G2.com.

Sometime this affeects the quota setup in market research surveys Review collected by and hosted on G2.com.

The Microsoft SQL Server got a lot of benefits compared to the other databases. My favorite about MSSQL Server is the ability to have big data clusters at high consistency performance which makes it soo much reliable for large-scale data pipelines. Also, there is another best part about Microsoft SQL Server is the comprehensive BI capabilities and ease to work with reporting functions. Review collected by and hosted on G2.com.

Even though the Microsoft SQL Server got awesome capabilities. it's adding too much complexity for small/medium software solutions. It doesn't work as convincing enough for small solutions as it's only shining in the large enterprise markets. It would be great if there is a lightweight and efficient version available. Review collected by and hosted on G2.com.

Rock stability, tools (through the Studio, which is free), there is a free version too (often bundled with software that requires it.) Review collected by and hosted on G2.com.

The learning curve, but primarily I'd love for SQL to come out of the box with a backup plan already in place. I find deployments without any backup plans all the time. I also find it a bit annoying that the syntax is finicky when compared to MySQL/MariaDB, like putting double quotes instead of single quotes for a simple comparison breaks the query. Review collected by and hosted on G2.com.

Performance is good. Data processing is fast compared to other tools. Good response to a query, Also easy to learn SQL query and also very compactable in writing compact queries Review collected by and hosted on G2.com.

Sometimes there will be an issue with performance due to connectivity issues. Also, recovery or restoring of lost or corrupt data takes a longer time, and the process needs to follow is more. Review collected by and hosted on G2.com.

The best about this platform it doesn't require too much hard and fast learning. One can easily practice on this platform and can become a good data analyst and data scientist—the more thing about that, the coding of M-SQL is not so hard. We can quickly learn this language from youtube also from google, Udemy, Coursera, or any other online platform. Review collected by and hosted on G2.com.

The thing I wouldn't say I like is the integration of different servers outside the box, which is quite tricky. It can be an easier way to integrate the business application into the database. Although you can say that it is good that it sometimes takes less time to analyze the result of perspective command of those business application. Review collected by and hosted on G2.com.

For being a database developer or data scientist and data analyst one should use this platform because it is much easier than another language to learn. A beginner who wants to learn about SQL can easily learn by youtube or online platforms like Udemy, Coursera, etc, This is much I like in this platform that a beginner can easily learn this language by his practice. Review collected by and hosted on G2.com.

The thing I dislike about this software is its installation. It's not that easy as other software. Also, a guide was not properly defined while installing this software. Also sometimes users have faced some issues getting the server name so if these problems were solved and I think it would be better for beginners to install this software. Review collected by and hosted on G2.com.

1. Data storing capacity and different features to take backup of your data, and reload the data. Review collected by and hosted on G2.com.

UI needs improvement also few system-defined words need to be handled properly, as the user uses similar kinds of variables.

It should show the message as a variable that cannot be used as it's a system variable instead of throwing an error. Review collected by and hosted on G2.com.

The best thing about SQL Server is that it helps arranging huge data in tabular form in database

We can put several complex queries and get the desired results in fraction of seconds.

It can do mathematical calculations in blink of an eye.

SQL server handles the redundant data by using common keys in multiple tables

it helps in maintaining transparency,integrity,security of data by hiding the data values using username and passwords Review collected by and hosted on G2.com.

It can hang and struck if server gets hit on by multiple users at the same time.

It can crash at the same time, so work gets hampered Review collected by and hosted on G2.com.

Microsoft SQL is easy to use. You can set up environment variables easily and connect the DBMS to your front-end without any hassle. The query processing language is easy to grasp, and you can generate multiple views from the same database as per your requirements. Review collected by and hosted on G2.com.

Microsoft SQL is costly. There are free alternatives available, but MS SQL's functionality is worth the cost. It loads quickly. The only problem I have is with Error tracking - it can be simplified for a better user experience. Review collected by and hosted on G2.com.