Microsoft SQL Server Reviews & Product Details

Very Good Database Engine with simple Query language used to fetch data records from tables or stored procedures. Very high-level indexing and sorting can be seen when fetched query-based records with execution time very much faster. Easy and Understandable Structured Query Language support can be easily learned by everyone. Query Debugging is an added advantage and support for developers. Review collected by and hosted on G2.com.

most often, when tuning the procedures which were already created some time back, to improve the data retrieving we need to get some default suggestions highlighted by the usage of artificial intelligence and then review them internally and then decide if those are to be accepted or remain the way. Because as we move forward in time, there is a lot of data getting created in database tables and to make sure the data retrieval rate also be on stand by then this is the best default suggestion which MS SQL can provide rather than just integrating with 3rd party applications to detect the code redundancy. Review collected by and hosted on G2.com.

We can store the data that we're using throughout our project and fetch in case when we need it...like I'm an RPA Developer working on Uipath and ABBYY, in both tools we have option to connect to the database and select, insert, update or delete the data as our wish. Review collected by and hosted on G2.com.

Sometimes database management server takes time to load the database environment if the database contains more data like tables or stored procedures or something. Review collected by and hosted on G2.com.

Easy to install, maintain. Good,easy to use, intuitive GUI tools but which also offer the capability to dig into the database and really tune and optimize database operations. Easy to connect to. Review collected by and hosted on G2.com.

So many varieties, especially in Azure that is it can be hard to determine which version is right for you. Some of the more feature laden versions can be fairly expensive Review collected by and hosted on G2.com.

SQL Server is a widely used Database management system and Microsoft provides premier support for its product. Needless to say, it has great community support and the BI capabilities are too good with easy integration for SSIS packages. The interface is user-friendly and maintenance is low and easy to deploy to the cloud. Easy to store and retrieve data. Review collected by and hosted on G2.com.

Licensing cost is a challenge for many organizations. When the query gets complex, it takes a hit in the performance and the interface also acts laggy. Connectivity issue also occurs many a time while connecting to the DB. Recovery of corrupt data is a cumbersome process. Review collected by and hosted on G2.com.

Queries are faster and provide more flexibility. It is easy to drill down to row level data. Joins and Indexing are really helpful. Review collected by and hosted on G2.com.

No downsides as such. Everything is up to date. Review collected by and hosted on G2.com.

Always great compatibility , easy to sue and doc support for when you got a problem Review collected by and hosted on G2.com.

Honestly, nothing to hate, it's worldwide use so we have great community to have help Review collected by and hosted on G2.com.

I like the memory optimization feature that currently comes with sql server 2014 and json filter. Review collected by and hosted on G2.com.

Some of the features, like different types of data checking that are by default disabled in oracle, need to be disabled here Review collected by and hosted on G2.com.

It has many useful tools like SQL server profiler and SQL server management studio. It is easy, fast and user-friendly. I also like about recovery solutions of the ms SQL server. It's very reliable. Review collected by and hosted on G2.com.

The answer must be about operating system support. It has only supporting windows OS as I know. MS SQL can't be an option if I use Linux or Ubuntu. One more lousy side of ms SQL is that it's not an open source. Review collected by and hosted on G2.com.

Quick backing up and restoring of databases. Particularly useful when testing.

Easy installation process and setting up new databases.

I find triggers useful to keep the integrity of business logic. Review collected by and hosted on G2.com.

Managing user roles and security could be clearer it is confusing at first.

Integration Services is ok for the most part, but it lacks that Enterprise class level of robustness of an effective ETL tool. Review collected by and hosted on G2.com.

Microsoft Sql server is very easy to use and very easy to manage. Its one of best Relational database I have used. It provides lot of facilities like store procedure, function, Tigger, view etc. And best part I used is service broker. By this we are able to do lots of task asynchronous. Review collected by and hosted on G2.com.

Its licence cost is high. Need to work on more JSON part. Rset all good. Review collected by and hosted on G2.com.