We just raised a $30M Series A: Read our story
2018-07-19T09:31:00Z

What do you like most about SQL Server?

11

Hi Everyone,

What do you like most about SQL Server?

Thanks for sharing your thoughts with the community!

ITCS user
Guest
7373 Answers

author avatar
Top 5Real User

The ease of administration, in general, is the solution's most valuable aspect.

2021-09-21T19:40:20Z
author avatar
Top 5LeaderboardReal User

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.

2021-09-20T10:53:41Z
author avatar
Top 10Consultant

It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups.

2021-09-17T18:45:00Z
author avatar
Top 5Real User

SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.

2021-08-25T16:10:51Z
author avatar
Top 20Real User

The solution is stable.

2021-08-21T09:02:59Z
author avatar
Top 10Reseller

In Poland, SQL Server is the most popular database engine, and overall, our customers like it.

2021-08-19T14:50:58Z
author avatar
Top 5LeaderboardReal User

Similar to Microsoft SQL, it is easy to scale.

2021-08-18T12:34:26Z
author avatar
Top 20Real User

I love the developer version. Microsoft tells you about all the cool things they provided for everybody. You can develop and do anything with it. It's really good to learn. Oracle will not give you that much freedom, and Microsoft really kills it.

You don't do anything with it but develop, learn, break, and push it to its limits. If there are problems, you show Microsoft or ask them, "what's going on here?" There is good community support for the developer edition, and that's what I really appreciate. You can teach people about it without limitations. You can have small databases created. You can keep it for a year and then work on it. It's a good thing for learners and developers.

2021-07-31T01:45:43Z
author avatar
Top 5LeaderboardReal User

The solution is easy to use and provides similar features to other competitors.

2021-07-16T12:04:20Z
author avatar
Top 20Real User

The scalability of the product is great.

2021-07-13T16:18:52Z
author avatar
Top 20Real User

The main feature of this solution is ease of use.

2021-07-11T12:41:09Z
author avatar
Top 5LeaderboardReal User

The most valuable features of this solution are easy queries and straightforward programming for beginners.

2021-07-11T12:39:11Z
author avatar
Top 5LeaderboardReal User

The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application.

2021-07-09T12:40:31Z
author avatar
Top 5LeaderboardReal User

SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well.

2021-07-09T10:16:58Z
author avatar
Top 5Real User

I like that it's relatively stable.

2021-06-18T07:34:42Z
author avatar
Top 5MSP

Scalability, cluster ability, ease of use, ease of implementation — these are all great.

2021-06-03T09:43:04Z
author avatar
Top 5Real User

It is a stable product, and it runs seamlessly. It is not complex.

2021-06-02T15:44:56Z
author avatar
Top 20Real User

It is integrated with Microsoft tools.

2021-05-31T15:41:02Z
author avatar
Top 5LeaderboardReal User

The performance of SQL Server is perfect.

2021-05-29T17:22:34Z
author avatar
Top 5LeaderboardReal User

Since we can automate most of our tasks, it means that the management is very easy.

2021-05-27T21:04:00Z
author avatar
Top 5LeaderboardReal User

We have found the feature that allows us to publish web applications to be valuable.

2021-05-27T15:16:00Z
author avatar
Top 5LeaderboardReal User

It's a good option for those that have a lot of Microsoft solutions in use.

2021-05-13T12:18:00Z
author avatar
Top 20Real User

Very easy to use, and it's very democratic in the enterprise.

2021-05-08T15:48:08Z
author avatar
Top 20Real User

Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.

2021-05-07T23:13:07Z
author avatar
Top 5LeaderboardReal User

It's a flexible solution.

2021-05-05T14:15:13Z
author avatar
Top 20Real User

What I like most is the management, as it is very easy compared with other products.

2021-04-06T13:38:19Z
author avatar
Top 5LeaderboardReal User

The performance is good.

2021-04-01T10:10:32Z
author avatar
Top 10Real User

The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query.

2021-03-30T19:25:39Z
author avatar
Top 5Real User

We've found it to basically be pretty problem-free.

2021-03-27T19:05:32Z
author avatar
Top 5LeaderboardReal User

It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.

2021-03-11T01:58:50Z
author avatar
Top 10Real User

The solution has the capability to scale.

2021-03-06T07:29:37Z
author avatar
Top 5LeaderboardReal User

It is easy to use and easy to perform a backup.

2021-03-05T16:15:31Z
author avatar
Top 20Real User

The initial setup isn't overly complex.

2021-03-05T09:38:33Z
author avatar
Top 20Real User

We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.

2021-03-04T04:45:30Z
author avatar
Top 5Real User

Stability is one of the most valuable features.

2021-02-24T11:06:46Z
author avatar
Top 20Real User

I like that the new version has a memory-optimized table to improve the performance.

2021-02-18T14:03:20Z
author avatar
Top 5LeaderboardReal User

The most valuable feature is easy installation. It was very easy to install.

2021-02-18T09:56:02Z
author avatar
Top 5LeaderboardReal User

The solution offers very high performance.

2021-02-14T14:42:24Z
author avatar
Top 10LeaderboardReal User

The security and vulnerability management are well-managed through the vendor.

2021-02-12T14:21:00Z
author avatar
Top 20Real User

It is the latest technology and pretty powerful in terms of the high availability of the virtual server.

2021-02-11T18:46:53Z
author avatar
Top 5Real User

The interface is user friendly.

2021-02-11T11:56:34Z
author avatar
Top 20Real User

Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.

2021-02-09T19:41:58Z
author avatar
Top 5LeaderboardReal User

It's more user-friendly than most databases.

2021-02-08T09:45:20Z
author avatar
Top 20Real User

The pricing of the solution is okay. It's less expensive than Oracle, for example.

2021-02-02T07:46:00Z
author avatar
Top 5LeaderboardReal User

If you need to, you can scale the solution very easily.

2021-01-27T11:24:04Z
author avatar
Top 20Real User

The product has very good online documentation that can be used for troubleshooting.

2021-01-26T08:40:56Z
author avatar
Top 5LeaderboardReal User

It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale.

PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades.

Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching.

2021-01-23T13:47:39Z
author avatar
Top 20Real User

SQL Server is quite stable. And now we are using the Lattice 2017 version.

2021-01-06T07:14:00Z
author avatar
Top 5LeaderboardReal User

I have seen that this is a very stable product.

2020-12-30T13:34:32Z
author avatar
Top 20Real User

As a data warehouse and storage solution, it's quite good.

2020-12-29T10:05:47Z
author avatar
Top 20Real User

The solution seems to be pretty flexible.

2020-12-28T10:53:51Z
author avatar
Top 5LeaderboardReal User

It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it.

2020-12-24T07:39:41Z
author avatar
Top 20Real User

Technical support is very good.

2020-12-09T17:43:34Z
author avatar
Top 20Real User

The columnstore index feature is useful for us, and we also use the integration services. It is also very stable.

2020-12-08T18:22:46Z
author avatar
Top 5LeaderboardReal User

The pricing of the product is very good.

2020-12-08T15:13:05Z
author avatar
Top 5Real User

The most valuable features are programmability and reliability.

2020-12-06T10:59:48Z
author avatar
Top 10Real User

The documentation and manuals are very good.

2020-12-03T12:47:24Z
author avatar
Top 5LeaderboardReal User

We have many users, between 50 and 100 using the SQL Server product.

2020-11-30T11:06:00Z
author avatar
Top 20Real User

The technical support is good.

2020-10-28T19:12:04Z
author avatar
Top 20Real User

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.

2020-09-03T07:49:44Z
author avatar
Top 5Real User

The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful.

2020-08-06T12:29:00Z
author avatar
Top 5Real User

The features that we have found the most valuable are reliability, availability perspective, and current scalability.

2020-08-02T08:16:00Z
author avatar
Top 5LeaderboardReal User

It helps with moving the design of the database into reality.

2020-07-26T08:18:59Z
author avatar
Top 10Real User

Very good security features.

2020-07-22T08:17:25Z
author avatar
Top 5LeaderboardReal User

SQL Server is a stable product.

2020-07-16T06:21:10Z
author avatar
Top 10Vendor

The feature that I have found most valuable is that it is easy to code.

2020-07-16T06:21:00Z
author avatar
Top 20Real User

SQL is very easy to manage.

2020-06-15T07:33:50Z
author avatar
Top 10Real User

The availability is the most valuable feature. It has high availability. It also has good performance.

2020-04-19T07:40:00Z
author avatar
Real User

The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.

2019-09-22T17:46:00Z
author avatar
Real User

It is one of the most stable relational databases out there.

2019-03-24T08:52:00Z
author avatar
Real User

I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient.

2018-11-18T07:31:00Z
author avatar
Real User

Tuning Advisor suggests where to add indexes and from where to remove them. It works like an adviser.

2018-08-10T00:57:00Z
author avatar
User

This solution has proven stability and operational power.

2018-07-19T09:31:00Z
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,608 professionals have used our research since 2012.