Microsoft SQL Server Reviews & Product Details

I like the HA feature in SQL. Always on is easy to implement and is an extremely powerful feature to provide redundancy to any business Review collected by and hosted on G2.com.

Complex product to manage. You will need DBA Skills so that you can troubleshoot if and when it begins to cause issues. Review collected by and hosted on G2.com.

Works great with our ever expanding database for storing and reporting medical records for our clients. Review collected by and hosted on G2.com.

Performance issues when using over VPN & as database gets larger Review collected by and hosted on G2.com.

Easy to maintain and with a easy query language.

There's a free version that you can use with databases smaller then 10gb

we can check query execution plan, helps in improving production system performance.

SQL Server Management Studio it’s a great solution to DBA or IT departments, his GUI allow less known users to do tasks like backup, restore, change passwords or change security settings Review collected by and hosted on G2.com.

What I do not like is that its main disadvantages would be that it uses a large amount of RAM and that Enterprise edition licensing cost alot.

It's very hard to change a database collation. Review collected by and hosted on G2.com.

I like how fluid the integration is with my current ERP software. Review collected by and hosted on G2.com.

It was difficult to use at first and still learning new sql queries and the language. Review collected by and hosted on G2.com.

SQL is widely used and has so much amazing support and resources out there that it makes database administration very easy Review collected by and hosted on G2.com.

Several different versions that slightly change features each release causing a few bugs when upgrading Review collected by and hosted on G2.com.

The friendly easy SQL interface that Microsoft have always used. There is also lots of SQL knowledgebase articles online so its easy to learn and support Review collected by and hosted on G2.com.

Version's and Collates are difficult sometimes, especially when migrating from SQL versions Review collected by and hosted on G2.com.

As a Systems Administrator, MS SQL Server is one of the easiest DBMS you can use from a management perspective. SQL Server Management Studio is a very robust client, and it allows you to configure everything from either the GUI or SQL scripts. No digging into config files, calling apps from command line, etc. User management in SQL server is easy and straight-forward while being EXTREMELY granular. Plus, it easily connects to Active Directory if you so desire.

The software is very reliable. MySQL can have issues during backups, but not SQL Server. Once you get it set up and configured properly (again, not hard to do), you can leave it running for months without encountering problems.

While SQL Server is by no means cheap, compared to the other enterprise-level DBMS like Oracle, it's quite reasonable. MySQL is free, but it's quite limited when you do a feature-by-feature comparison with SQL Server.

If you're on the fence, install an Express instance (up to 10GB databases with some limitations). You won't be disappointed. Review collected by and hosted on G2.com.

Like a lot of other Microsoft software, the installer is pretty bloated with prerequisites, components, etc. But that's a fairly small nitpick.

I will also say that RAM management in SQL Server isn't perfect. SQL will, as long as it is regularly used, consume all of the RAM you have allocated it. By default, that setting is 2 petabytes of RAM, so it will slow your system to an absolute crawl, consuming everything it can to the detriment of the OS itself. This means you need to manually allocated a reasonable amount of RAM to SQL knowing full-well that it will likely consume this RAM at all times. That's fine for dedicated database servers, but it's not ideal for people running SQL on laptops. Review collected by and hosted on G2.com.

Since its a Microsoft product, it can integrate into other software which can be very useful depending on your needs. Within SQL you can use scripts that are VB based so its not like you have to learn a whole lot to start using those additional items. I also like that it integrates into outlook so we can run queries and put results directly into an email. Review collected by and hosted on G2.com.

Its not nearly as advanced as other products available. The GUI is outdated compared to other products like Tableau which is much more user friendly and visually appealing. You do have to learn how to code specifically to MS SQL as it does slightly differ from Oracle and other SQL products. Review collected by and hosted on G2.com.

It is very easy to use(2013 version), Its user interface is also very good. Review collected by and hosted on G2.com.

Data uploading is a pretty much-complicated task in it, as data type mapping takes a lot of time. Review collected by and hosted on G2.com.

Easy to write T-SQL for CTE data. It has complete integration and analytical features such as SSIS, SSAS, And SSRS. It is also easier to integration BI such as Power BI for data visualization. It is one of a powerful simple database management system. I found it easier for indexing the table to increase the performance of the query data. Easier to manage database including Backup and restore, clustering, scheduling jobs, design database and data warehouse. Review collected by and hosted on G2.com.

Microsoft SQL Server on Windows has some debugs, therefore, we experienced some disconnected problem, system hangs issues. Review collected by and hosted on G2.com.