Microsoft SQL Server Reviews & Product Details

Integration of other monitoring software like fog light is very easy without time consumption. Great capability to handle all complex queries requirements. Suite of advance sql functions. Provide all excellent functionalities like Reporting Services, Integration Services, Job Scheduler, Resource manager, Query analyser and Profiler etc. Each of these modules are build perfectly and handles the tasks effectively. Configurable at each level. User permission is at every objects and other higher levels. Changes can be done for specific privileges at user level. Window service based Control to the server for starting and stopping the service. Review collected by and hosted on G2.com.

Scalability is great but not the best like other new Database there in the market. CPU memory consumption is always more than normal on production specifically by the sql server. Scope of improvement in profiler for most frequently used options. Review collected by and hosted on G2.com.

The top point that comes to my mind about SQL Server Integration Services is that it is a part of the SQL Server Data Tools which can be downloaded for free as mentioned here: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

+ I was able to download the SQL Server Data Tools for Free, and connect to our SQL Server Enterprise Edition and we never had to worry about the extra cost for buying an ETL Tool. Review collected by and hosted on G2.com.

I don't actually dislike anything in the tool in itself. However, as I've read in many online blogs, many of the ETL jobs break in SQL Server Integration Services when the datasets that we deal with are too large in size. I faced a similar issue during my graduate degree when I was using SSDT to connect to a remote server on a University of Cincinatti server. The jobs break from time to time but I felt most of the times, this was caused due to server disconnection. So, I cannot vouch for any cons of the Integration Services at least now. Review collected by and hosted on G2.com.

Microsoft product. We like the product because we are windows shop Review collected by and hosted on G2.com.

Expensive. It cost a lot to have an enterprise product comparing to open source Review collected by and hosted on G2.com.

MS SQL Server is very easy to use if you have some database knowledge as it provides UI it helps to build Query and manage Database. It is very easy to setup. Its features like Profiler, Execution Plan,etc are very helpful to troubleshoot the long time running Queries. There are so many other features which are very useful. Review collected by and hosted on G2.com.

CPU utilization is almost more than normal and uses more RAM. Profiler should get more improved. Data Achieving is difficult. Should have easy way to troubleshoot a failed SQL Query. Review collected by and hosted on G2.com.

What I like best about Microsoft Sel server is that it is compatible with a lot of other ms apps. Review collected by and hosted on G2.com.

What I dislike about Microsoft sql server is the graphic interface. Review collected by and hosted on G2.com.

Microsoft SQL is a robust relational database that is easy to configure and maintain. Review collected by and hosted on G2.com.

Microsoft SQL permissions are sometimes confusing and there is not a true equivalent to Oracle's materialized view. Review collected by and hosted on G2.com.

It is a very powerful tool to mine data and retrieve information you are looking for quickly and reliably. Review collected by and hosted on G2.com.

Writing SQL queries can be difficult if you do not do them frequently but once you learn the formatting it is all standardized across versions which is nice. Review collected by and hosted on G2.com.

Backup, restore performance and reliability Review collected by and hosted on G2.com.

redundancy available only on enterprise edition, but the cost is high when compare with standard Review collected by and hosted on G2.com.

This is just like icloud but more user friendly and is compactable with so many unlike icloud. Its available in different languages. Review collected by and hosted on G2.com.

Its quite slow at times and gets stucks while working on it. Review collected by and hosted on G2.com.

Interface is very person friendly and fast. Review collected by and hosted on G2.com.

It does take a while sometimes and quite frequently has updates Review collected by and hosted on G2.com.