Microsoft SQL Server Reviews & Product Details

Support, documentation, versatility, and scalability are truly unmatched when it comes to data warehousing. You can make your server as big or as small as you'd like. Review collected by and hosted on G2.com.

I would like for functions introduced in newer versions to be fully importable into older versions. Review collected by and hosted on G2.com.

I love writing my SQL using microsoft! It's super easy to find all the controls I need, the debugging system they have is so helpful! Review collected by and hosted on G2.com.

When I run larger queries it sometimes crashes but this has been improving. Review collected by and hosted on G2.com.

His main tool SQL Server Management Studio it’s a great solution for DBA or Technology group, his GUI minimize tasks like backup, restore, change passwords or change security settings. For me as part of a security department it's important to audit a change user privileges with a single click. Another benefit allows us integration with other solutions (like antivirus, CRM, etc) with local solutions and cloud solutions.

For less known users try free version, then you can decided what to buy. Be part of Microsoft solutions it’s a plus, allowing us to do task with server configuration and upgrade without issues. Review collected by and hosted on G2.com.

His price could be a pain for IT departments, if you compared against other product or free editions. Sometimes customer support take too much time to solve an issue, it’s annoying that issue only can be solved by patching. You need an experienced Microsoft Partner to deploy large environments, those partners increase licensing and services price allot. As users we need better services with lower prices. Review collected by and hosted on G2.com.

Microsoft SQL has been a mainstay in data base query management for many years. It comes as no surprise that most companies with multiple systems will use Microsoft SQL to ease in searching, joining, table management and expect fast response times. Review collected by and hosted on G2.com.

Microsoft SQL Enterprise pricing has grown steadily over the years along with the processing power needed to run all of the different applications it supports. Review collected by and hosted on G2.com.

It has lots of functions, it’s easy to integrate with other systems. It’s also easy to implement and configure. Review collected by and hosted on G2.com.

It’s really ram consuming, more than other dB management systems Review collected by and hosted on G2.com.

It supports DBMS which most application required in development. SQL server supported all the application development tool. It also supports RDBMS which makes variety application support Review collected by and hosted on G2.com.

Every major version is having many sub versions. That makes some confusion in developer mind. Review collected by and hosted on G2.com.

The administration is fairly easy. A SQL Server can be set up quickly and run without much management from a DBA. Some work is needed to configure the instances, but the platform tends to run very smoothly for us. Backups, index maintenance, and security are smooth and easy to set up, and with the GUI, we can make adjustments quickly, while still saving the underlying code. Review collected by and hosted on G2.com.

One of the weaknesses of SQL Server is the lack of tooling in places. That sounds strange as Microsoft has been known for easy to use GUI tools, but a number of features in the last 4-5 versions of SQL Server (Service Broken, replication, Extended Events, and more) haven't received much help in the tooling areas. Review collected by and hosted on G2.com.

Maintaing data using SQL Server is a great experience. It is stable, secured and trusted. Best features of SQL server are - SQL profiler, Query automation, SSIS. Query optimization is also easy with SQL server. Review collected by and hosted on G2.com.

It takes huge CPU memory so system gets very slow sometimes. Reporting tool is also not so good, it requires some improvement. Review collected by and hosted on G2.com.

The license of Microsoft Sql Server allows you to have (in addition to an excellent engine of Relational DB) a complete package of tools that can develop ETL, reporting and multidimensional OLAP structures. Database skills must be very specific and people who need to work seriously on SQL Server must be passionate about data analysis, data manipulation, constant and careful monitoring of performance and Sql Server really makes available all the tools that can to do this.

Review collected by and hosted on G2.com.

It requires a knowledge and in-depth technical skills to make complex processes truly performing, especially if we are in very complex infrastructures. Raramenti is faced with problems that someone else has not already addressed and already solved, so (except for very rare cases) it is possible to go back to solving problems by documenting carefully, in cases where there is no documentation you need to contact Microsoft's support. Review collected by and hosted on G2.com.

MS-SQL is an Intuitive interface.Also very useful functions and methods not available on other platforms Review collected by and hosted on G2.com.

I wish it was easier to retrieve current instance settings and configurations without going through much of the installation process again Review collected by and hosted on G2.com.