Try our new research platform with insights from 80,000+ expert users
reviewer1635153 - PeerSpot reviewer
VP Global Information Technology at a insurance company with 10,001+ employees
Real User
Aug 8, 2021
A scalable and stable solution with a flawless setup
Pros and Cons
  • "The initial setup is easy, flawless."
  • "I want to see one improvement and this involves the replication between the DC and DR."

What is our primary use case?

We are using the latest version.

We can use the solution for the same application. On the database side we have Microsoft SQL and on the operating system side we have 2019.

What needs improvement?

I want to see one improvement and this involves the replication between the DC and DR. We have limited options at the moment and it does not lend sufficient support for the number of databases. This means we have a huge number of databases, topping approximately 2,000. For the moment, this particular replication is not supported by SQL. 

The support number of databases needs to be increased, as well as the database number of databases that it supports. That support cannot be found when it comes to the replication between the DC and DR. 

For how long have I used the solution?

I have been using SQL Server for ten years. 

What do I think about the stability of the solution?

The solution is sufficiently stable. 

Buyer's Guide
SQL Server
December 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
880,901 professionals have used our research since 2012.

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and support?

When it comes to the speed, knowledge and customer-friendliness of the technical support, we feel these to be good. 

Which solution did I use previously and why did I switch?

We did not use other solutions prior to SQL Server. 

How was the initial setup?

The initial setup is easy, flawless. 

It lasts a single day. 

What about the implementation team?

We handed the implementation on our own. 

This involved a technical team of 15 people. 

What's my experience with pricing, setup cost, and licensing?

There is a need to pay for the license for SQL Server. We have an enterprise license, which we consider to be fine. 

What other advice do I have?

We have 10,000 customers. 

I would recommend the solution to others. 

SQL Server is good and I rate it as a nine out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user1641576 - PeerSpot reviewer
Principal Database And Cloud Architect at a financial services firm with 10,001+ employees
Real User
Aug 4, 2021
A relational database management system with a valuable developer edition, but the price could be better
Pros and Cons
  • "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."
  • "The price could be better. It costs a lot, and competing databases like Postgres are free."

What is most valuable?

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.

What needs improvement?

The price could be better. It costs a lot, and competing databases like Postgres are free.

For how long have I used the solution?

I have been using SQL Server for about ten years.

What do I think about the stability of the solution?

There are problems in all systems, and I don't see any difference between open source and proprietary solutions. SQL Server, Postgres, and Oracle are all vulnerable. There are no known issues per se, but any system can be broken. There is nothing special about this database.

What do I think about the scalability of the solution?

SQL Servers and other databases are all scalable. I just don't see any problem with scalability.

How are customer service and technical support?

Whenever we have issues, we talk directly with Microsoft. They are responsive, and they help.

Which solution did I use previously and why did I switch?

I'm more into open source solutions, and I love Postgres. I've worked as a database administrator as well. But I really hate all the tools used to manage performance or backup or just any of those disaster, recovery, and availability solutions. I hate them. They really impose a lot of overhead in a demonstration and aren't really flexible. When you're in the cloud, you don't have to worry about most of those things. 

Some of them still exist, but the cloud providers do provide them and you stick to that. You enhance them or add some more features, but really the most hated feature is, making sure that your database really can recover from many kinds of disasters. Resiliency, the most important part and when that is really managed by the cloud online, the overhead costs  are removed. The rest is really easy. Performance is okay, and there are indicated spots for data because I work with financial data and a lot of it is our important critical data. So, the cloud is really the best thing that happened to us.

How was the initial setup?

When it comes to the initial setup, most of them can be automated. For example, most setup settings for progressions, management, disaster and recovery, failover, and failback. Most of those things can be automated and provisioned into one kind of pipeline. Connecting that data to an application and even provisioning from the code repository through Jenkins. Those things are really easy to automate.

What's my experience with pricing, setup cost, and licensing?

It costs a lot.

What other advice do I have?

I would advise potential users to use SQL Server with Microsoft Azure. I don't recommend managing it locally.

On a scale from one to ten, I would give SQL Server a seven.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
SQL Server
December 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
880,901 professionals have used our research since 2012.
it_user1631745 - PeerSpot reviewer
Senior Developer at a government with 51-200 employees
Real User
Jul 28, 2021
Easy to scale, simple to set up, and offers many great features
Pros and Cons
  • "The backups are excellent."
  • "I would like to see better integration between their link server and other platforms, such as IBM."

What is our primary use case?

Usually, we use a lot of the vendor software, like ManageEngine, and stuff like that. They use Postgres, however, I prefer to use Microsoft's SQL server. We have a couple of servers and we integrate that information into it. I can run reporting and analysis off of that.

What is most valuable?

There's a lot of great features. I like T-SQL, which is wonderful. The backups are excellent. There's a lot of things that are much easier to manage. All of the features and functions within the SQL language itself, the store procedures, I really, really enjoy. The security has been excellent.

The initial setup is very straightforward. 

The stability is very good.

We find it easy to scale if we need to.

What needs improvement?

I would like to see better integration between their link server and other platforms, such as IBM, due to the fact that, a lot of times, you want to set up a linked server so you can be on SQL and pull data off of another server using that link server. Sometimes they don't play well together. There just needs to be better integration for those types of situations.

For how long have I used the solution?

I've been using the solution for about eight or nine years at this point. 

What do I think about the stability of the solution?

The stability is great. There are no bugs or glitches. it doesn't crash or freeze. It's very reliable. The performance is great. 

What do I think about the scalability of the solution?

Scaling is easy if you need to do it. You simply set up a cluster and you can just grow it up.

In our organization, all the end-users are pretty much integrated into it and using it. As far as developers, there are two developers and me that are using it.

How are customer service and technical support?

We haven't used tech support as we used to have a business partner that wanted us to talk to them instead. Therefore, I can't speak to how helpful or responsive they would be if you need assistance. 

Which solution did I use previously and why did I switch?

Here at the company, they used Postgres, and what I didn't care about it was that it was okay, but it didn't integrate with a lot of the other applications. I felt Microsoft did a better job of that.

How was the initial setup?

The setup is pretty straightforward. The only thing that sometimes gets weird is if you have somebody that's needing an ODBC driver from another type of application back to the SQL server. It's usually that other application trying to figure out what it needs to connect to SQL. It's not really SQL's fault.

What other advice do I have?

We are customers and end-users.

We are using both the latest version and a previous version of the solution. I don't have the exact version numbers on hand. 

I would advise new users first to get help implementing it unless you know the solution well, as there's so much that it can do. A lot of times you can actually make a little mistake. Say if you're going to go in a certain direction, if you get some advice, you may be much happier going in another direction completely.

In general, I would rate the solution at a nine out of ten. I've been quite satisfied with its capabilities. It's an excellent product that still has room for growth.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1624716 - PeerSpot reviewer
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
Real User
Jul 16, 2021
Scalable and stable with good overall performance
Pros and Cons
  • "The scalability of the product is great."
  • "The licensing is pretty expensive."

What is our primary use case?

We primarily use the solution mainly for databases on all types of applications.

How has it helped my organization?

SQL is the all around leading Database server

What is most valuable?

The solution is very stable. 

The scalability of the product is great.

What needs improvement?

We'd like the deployment process to be better in the future. 

The licensing is pretty expensive.

For how long have I used the solution?

I've been using the solution for 20 years at this point. It's been two decades. We've used it for a while now.

What do I think about the stability of the solution?

The solution is stable and the performance is great. There are no bugs or glitches. It doesn't crash or freeze.

What do I think about the scalability of the solution?

The product scales well. If you need to expand it, you can do so.

We have 900 to 1,000 people using it currently.

How are customer service and technical support?

I'm more on the architecture side and therefore do not directly deal with technical support. I cannot speak to how helpful or responsive they are.

Which solution did I use previously and why did I switch?

We also use Oracle. We've used it for over a decade already.

How was the initial setup?

The deployment could be easier.

While the deployment only takes about 15 minutes, you have to follow up with a lot of configuration.

What about the implementation team?

We handled the implementation ourselves. We did not enlist the assistance of any integrators or consultants. It was all handled in-house.

What's my experience with pricing, setup cost, and licensing?

We're paying too much for licensing at this time. They need to work on the pricing. They could be cheaper, however, it's also difficult to run the licenses in the right way.

We pay licensing fees on a yearly basis. 

What other advice do I have?

We're a customer and an end-user. We don't have a business relationship with SQL. 

While everything is currently on-premises, we're making moves to shift to the cloud. 

We're using the 2019 and 2016 versions of the product.

I'd rate the solution at an eight out of ten. In general, we've been quite happy with its capabilities.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Ravi-Upadhyay - PeerSpot reviewer
Founder at a tech services company with 1,001-5,000 employees
Real User
Top 20
Jul 11, 2021
User friendly, performs well, and backward compatibility
Pros and Cons
  • "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."

    What is our primary use case?

    The solution is an RDBMS and can be used to simplify customers' requirements for a back-end database. The main function of the solution is to store information from front-end users.

    What is most valuable?

    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. Additionally, the solution is simple and if it is configured properly it performs very well. 

    For how long have I used the solution?

    I have used the solution for approximately six years.

    What do I think about the stability of the solution?

    I find the solution to be very stable. 

    What do I think about the scalability of the solution?

    The solution is scalable. 

    How are customer service and technical support?

    The technical support is only provided to the customers having a subscription-based license with a Software Assurance server. For other forms of licensing the solution will not provide support. 

    Which solution did I use previously and why did I switch?

    I have previously used other RDBMS solutions, such as Oracle MySQL, Maria DB, PostgreSQL, and IBM DB2.

    When comparing PostgreSQL, Oracle MySQL, and Microsoft SQL, Microsoft SQL has an advantage over the other two server databases because it provides a graphical user interface by default.

    How was the initial setup?

    The initial setup of the solution is very easy and the time it takes depends on the architecture required. If the deployment of a cluster is required then the setup may take up to three hours, whereas standard environment deployment needs half an hour. 

    What about the implementation team?

    The solution can be installed by our selves but the use of an integrator makes it much easier. 

    What's my experience with pricing, setup cost, and licensing?

    The solution requires authorization in either the form of perpetual licensing or subscription-based licenses for two years. If a perpetual license version is purchased then customers have it to the end of life, whereas a subscription-based called server with Software Assurance, has to be renewed every two years. 

    The areas that need improvement are with regards to the commercial aspect of the solution, the licensing cost could be reduced in order to help customers to adopt it.

    What other advice do I have?

    I would recommend this solution. However, the customer has to make sure it fits their use case.

    I rate SQL Server a nine out of ten. 

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Managing Partner at a consultancy with 11-50 employees
    Real User
    Jul 9, 2021
    Stores and retrieves data requested by other applications
    Pros and Cons
    • "I haven't really experienced any issues that required the assistance of technical support."
    • "The ability to connect with other environments needs to be improved."

    What is our primary use case?

    We use this solution to manage our database and store information. I use another platform for more specific needs.

    Within our organization, there are roughly 10-12 employees using this solution. 

    What needs improvement?

    SQL Server consumes a lot of resources. You need to keep an eye on the number of resources involved. It expands and uses all of the memory available on the server. For this reason, I install it on separate machines.

    Also, the ability to connect with other environments needs to be improved. 

    For how long have I used the solution?

    I have been using SQL Server for nearly 10 years.

    What do I think about the scalability of the solution?

    Scalability-wise, it's okay.

    How are customer service and technical support?

    I haven't really experienced any issues that required the assistance of technical support. 

    Which solution did I use previously and why did I switch?

    I also use MySQL — the open-source version. I started using SQL Server because we required some special functionality for a specific project. 

    How was the initial setup?

    The initial setup was not complicated. You can do it without any external support. 

    What about the implementation team?

    I installed the entire solution myself within 20-50 minutes.

    What's my experience with pricing, setup cost, and licensing?

    The price could always be lower. 

    Which other solutions did I evaluate?

    I evaluated Oracle, but I didn't like it — I prefer Microsoft. 

    What other advice do I have?

    I would absolutely recommend this solution to others. Overall, on a scale from one to ten, I would give this solution a rating of eight. 

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    System Administrator at a construction company with 501-1,000 employees
    Real User
    Jul 9, 2021
    Easy query creation, scalable, and reliable
    Pros and Cons
    • "We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables."
    • "If you are a new user then this solution could be difficult, they could improve by making the overall usage easier."

    What is our primary use case?

    We are using SQL Server for the backend of our SAP and are planning on moving to a cloud version soon.

    How has it helped my organization?

    This solution has helped our organization by providing a backbone for our SAP. We would not be able to operate without it.

    What is most valuable?

    We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.

    What needs improvement?

    We are using an older version of SQL Server and the migration to a newer version could be made easier.

    If you are a new user then this solution could be difficult, they could improve by making the overall usage easier.

    In an upcoming release, they could improve the ability to customize the solution.

    For how long have I used the solution?

    I have been using SQL Server for approximately ten years.

    What do I think about the stability of the solution?

    We have not experienced any problems with the stability of this solution.

    What do I think about the scalability of the solution?

    SQL Server is scalable.

    How are customer service and technical support?

    We have not used the support from Microsoft. However, we did have freelance support a few times.

    How was the initial setup?

    The installation is very easy. We did not have any challenges.

    What's my experience with pricing, setup cost, and licensing?

    The price of the solution is very expensive. If I went with the cloud version of SQL a license would cost me approximately 11,000 Riyals per month.

    Which other solutions did I evaluate?

    We have a team that has evaluated other solutions before we chose SQL Server, such as Oracle.

    What other advice do I have?

    I would recommend this solution. However, Oracle has a good reputation for quality that might be a better choice.

    I rate SQL Server an eight out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company has a business relationship with this vendor other than being a customer. partner
    PeerSpot user
    Solution Architect at a tech services company with 51-200 employees
    Real User
    Jul 3, 2021
    Highly scalable, easy to use, but better performance and monitoring needed
    Pros and Cons
    • "The solution is very easy to use."
    • "SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."

    What is our primary use case?

    I have been working on SQL Server for installations, configuring for developers, and for creating backup jobs from the MBF files.

    What is most valuable?

    The solution is very easy to use.

    What needs improvement?

    SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable.

    For how long have I used the solution?

    I have been using this solution for approximately three years.

    What do I think about the stability of the solution?

    I have found the SQL Server stable.

    What do I think about the scalability of the solution?

    The solution is highly scalable. You are able to implement a SQL cluster mechanism for replicating the data between two nodes of the SQL Server. If one of the nodes is down the second node becomes active.

    We have approximately 20 developers working directly with SQL Server and approximately 1,000 end-users that are working on the application that is behind the SQL Server.

    How are customer service and technical support?

    The technical support is good. We had a big problem and after an investigation, we could not find the solution. We needed to make use of Microsoft support team and open a specific case on the Microsoft panel. They were able to provide solutions for solving this issue.

    Which solution did I use previously and why did I switch?

    I have used MySQL.

    How was the initial setup?

    The installation is not very complex. However, the process could take a long time because you have to follow the step-by-step instructions for the installation. The time it takes to do the installation is approximately two days.

    What's my experience with pricing, setup cost, and licensing?

    There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford.

    What other advice do I have?

    I would recommend this solution to others.

    I rate SQL Server a seven out of ten.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
    Updated: December 2025
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.