Microsoft SQL Server Reviews & Product Details

Storing of Data, using a conditional statement such as addition, filtration, deletion of data and managing of the client was has been quite helpful while using Microsoft sql server. Review collected by and hosted on G2.com.

Not really ever felt like not using Microsoft sql server in RPA automation but i think my dislikes could be of managing massive data at times or also maintenance of big databases could lead to certain problems. Review collected by and hosted on G2.com.

Easily integrate with SSMS SSIS SSRS. Fast in small trastional operation. Review collected by and hosted on G2.com.

Poor performance in general setup, high performance requires lot of memory to store in-memory tables Review collected by and hosted on G2.com.

Very easy to understand and implement SQL. DB design and data importing are super handy and easy to execute. I can integrate with SSIS packages and monitor them inside the SQL server itself. I can also connect to cloud azure SQL servers as well, I can tell many more best things about SQL server but I will stop here Review collected by and hosted on G2.com.

Unless I use rollback I can't undo the executed operation which I dislike about SQL server. While loading txt files it cannot detect delimiter and it can't detect datatypes if we are using CSV or txt file also sometimes the app crashes abruptly or it can't take correct inputs from the mouse and keyboard. Review collected by and hosted on G2.com.

Microsoft SQL is very developer friendly, has good performance, and is simple to install, the store procedure is what I like the most. Review collected by and hosted on G2.com.

design is not appealing, not a good solution for managing massive data since it lacks in performance, also incompatible with MacOS. Review collected by and hosted on G2.com.

I like your IDE, Manager Studio. I find the level of integration very useful, as it is a Microsoft software, with the possibility of integrating with Power BI Desktop, for example. Review collected by and hosted on G2.com.

The cost of the licenses, No, what I don't like about the software is the issue of the cost of the licenses. Make airplanes for students to use the software in costs and maybe it can be used in iOS. Review collected by and hosted on G2.com.

SQL is a tool where we can store, retrieve to get details for analysis and reporting purpose Review collected by and hosted on G2.com.

Too techincal, but powerful to use. need more IT experience to use Review collected by and hosted on G2.com.

Wide adoption, integration, low learning curve, fast and reliable. Able to deploy in the cloud. User management and integration with authentication services.

Production-ready and extensive support.

The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward.

Corrupt data is always a concern when power loss or improper shutdowns occur. Microsoft SQL Server has several features that promote data restoration and recovery. Although individual tables can't be backed up or restored, complete database restoration options are available. Through the use of log files, caching, and backups, Microsoft's product allows you to feel confident that disaster recovery options are plentiful. Review collected by and hosted on G2.com.

Price, and vendor lock, are not great for big data tasks. Upgrades sometimes require long downtime, backups are not the best. Replication. Support (unless paid).

Expensive compared to its competitors. Bug tracking is also tricky; must be simplified. The settings and adjustments can be improved a little more, so many naive users will also be able to use it.

Auto-shrink needed to stay for backward compatibility…The FULL recovery model is the default. I would guess that this is responsible for the majority of cases of transaction logs growing out of control.

RECOVERY is the default RESTORE option. The default should be NORECOVERY to stop people screwing up their restore sequences.

GUIDs can be clustered index keys. I shouldn't even have to explain this one. SQL Server should warn you that a PK is by default a clustered index and that GUID clustered PKs just suck.

The default data and log file growth rates of 1-MB and 10% respectively. Seriously, why did they change to 1-MB for the default auto-growth rate? However, the problem is – what should the defaults be? Answers on a postcard, please… Review collected by and hosted on G2.com.

Easy to use IDE for CRUD operation using SQL Server Management Studio. Follows SQL format Review collected by and hosted on G2.com.

Auto generating of tables and columns with specific data types is not possible Review collected by and hosted on G2.com.

Excellent relational database platform, we use MS SQL Server for all our backend databases from public safety to financials. We also use MS SQL Server as a robust reporting tool, analyzing data / updating data. Review collected by and hosted on G2.com.

Not really a lot I do not like, however if I would have to have a dislike it would be performance. Sometimes we have to issues for database locks which impacts end users. We have processes in place to mitigate the issues now, so all is well. Review collected by and hosted on G2.com.

Ease of use, integrates well into apps, available on multiple platforms. Review collected by and hosted on G2.com.

There are limited tuning options within the software itself. Review collected by and hosted on G2.com.