Try our new research platform with insights from 80,000+ expert users
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.

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

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 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
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
Buyer's Guide
SQL Server
January 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,282 professionals have used our research since 2012.
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
    AhmedElbadry - PeerSpot reviewer
    NMS Service Automation & RPA Technical Lead at a tech vendor with 10,001+ employees
    Real User
    Jun 19, 2021
    Scalable with a straightforward setup and good stability
    Pros and Cons
    • "From a security perspective, we have no complaints."
    • "It would be ideal if the solution offered better integration capabilities."

    What is our primary use case?

    The solution is a part of a product. We use it for our database, among other items.

    What is most valuable?

    The solution is very stable.

    The product scales well.

    From a security perspective, we have no complaints. 

    The initial setup is very straightforward. 

    What needs improvement?

    The solution should work to improve its search functionality.

    It would be ideal if the solution offered better integration capabilities. In the future, we expect that our company will need to make more integrations with other systems.

    For how long have I used the solution?

    I've been using the solution for three years. It hasn't been that long.

    What do I think about the stability of the solution?

    So far, the stability has been very good. We haven't experienced any crashed or anything of that nature. There are no bugs or glitches. It's reliable and the performance is good.

    What do I think about the scalability of the solution?

    The solution is very scalable. The only thing that would limit its ability to expand is how your environment is designed. That said, a company should have no trouble scaling it if they would like to.

    There are only five of us using the solution right now.

    We do plan to increase usage in the future.

    How are customer service and technical support?

    While I haven't had a chance to open a ticket with technical support, I plan to open one next week, as I have an issue I need to ask them about. However, since I have yet to be in contact, I cannot evaluate their level of service.

    How was the initial setup?

    The initial setup is not complex or difficult. It's easy. It's very straightforward and the setup guide is available if you Google it. Anyone can search for the installation guide on whichever version you're installing.

    The deployment is quick. It only takes about 30 minutes or so.

    We have a technical team of five engineers. If any maintenance is needed, we can handle it. 

    What about the implementation team?

    I installed the product myself. I found an installation guide and just followed the directions. I didn't need the help of a consultant or integrator.

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

    We do not currently pay a licensing fee in order to use this product.

    What other advice do I have?

    I'm currently using the 2017 version. I am not using the latest version of the solution.

    In general, I would rate it at an eight out of ten. For the most part, we have been satisfied with its capabilities.

    I'd recommend the solution to other users and organizations.

    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
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
    Updated: January 2026
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.