Try our new research platform with insights from 80,000+ expert users
reviewer2356620 - PeerSpot reviewer
Development Associate & Manager at a educational organization with 501-1,000 employees
Real User
Top 20
Mar 28, 2024
Offers good performance, but scalability feature needs to improve
Pros and Cons
  • "The solution can be deployed in a few minutes."
  • "There are certain shortcomings in the scalability of the product, making it an area where improvements are required."

What needs improvement?

There are certain shortcomings in the scalability of the product, making it an area where improvements are required.

From an improvement perspective, the price of the product needs to be reduced.

For how long have I used the solution?

I have been using SQL Server for more than ten years. My company is a gold partner of Microsoft.

What do I think about the stability of the solution?

It is a stable solution. Stability-wise, I rate the solution a seven or eight out of ten.

What do I think about the scalability of the solution?

It is quite a scalable solution. Scalability-wise, I rate the solution a seven out of ten.

My company's clients who use the solution are mostly enterprise businesses.

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

How are customer service and support?

I rate the technical support a seven out of ten.

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

I am using Amazon Cognito for the first time in my company.

What was our ROI?

I rate the product's initial setup phase a seven to eight on a scale of one to ten, where one is difficult, and ten is easy.

The solution is deployed on the cloud and on-premises models.

The solution can be deployed in a few minutes.

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

The product is expensive.

What other advice do I have?

In our company's daily operations, we use SQL Server for our enterprise applications.

Speaking about how SQL Server played a critical role in a recent project, I would say that in my company, we used it for full management since we had a three-tier architecture and an enterprise application.

SQL Server was beneficial for data management needs, considering the fact that it was used as a part of SSIS packages, which was helpful for importing the data from legacy software.

The performance of the solution was good.

Though I can't elaborate on the valuable security features, I can say that I did not face any security concerns when using the product.

In SQL Server, I manage data recovery and backup with the help of database mirroring.

I recommend the product to those who plan to use it since it is easy to use.

I rate the tool a seven 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
ChristineSpence - PeerSpot reviewer
Software Solutions Account Manager at First Technology
Reseller
Mar 12, 2024
Helps users to manage their data but improvement is needed in pricing and support
Pros and Cons
  • "SQL Server is easy to manage."
  • "The tool needs to improve its pricing and technical support."

What is most valuable?

SQL Server is easy to manage. 

What needs improvement?

The tool needs to improve its pricing and technical support. 

For how long have I used the solution?

I have been working with the product for ten years. 

What do I think about the stability of the solution?

I rate the product’s stability a seven out of ten.

What do I think about the scalability of the solution?

I rate the tool's scalability a seven out of ten. 

How was the initial setup?

I rate the tool's deployment a seven out of ten. Deployment time depends on the customer's environment. 

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

I rate the product’s pricing a six out of ten.

What other advice do I have?

Our clients are from small, medium, and enterprise businesses. It helps users to manage their data. 

I rate the overall product an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer. Reseller
PeerSpot user
Buyer's Guide
SQL Server
February 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: February 2026.
884,797 professionals have used our research since 2012.
IT Analysis at Kirkby (Tyres) Ltd
Real User
Jan 8, 2024
Stores and retrieves data as requested by other software applications
Pros and Cons
  • "Having everything in one centralized set of databases is the most valuable feature."
  • "I think just having everything in one centralized set of databases where there is easily managed manageable."

    What is our primary use case?

    The solution is used as our backend database for our in-house applications. 

    How has it helped my organization?

    It's consolidated all of our Microsoft Access databases.

    What is most valuable?

    Having everything in one centralized set of databases is the most valuable feature.

    What needs improvement?

    Over the years additional features, data warehousing, cubing, just better performance and better manageability in terms of the actual Microsoft SQL Server AppLINK console.

    For how long have I used the solution?

    I have experience with SQL Server. 

    What do I think about the stability of the solution?

    It is a highly stable solution. It was our database of choice because of its reliability. It just does what it says on the tin. We've never experienced any issues with it. I've never experienced any issues with it crashing or anything like that. 

    What do I think about the scalability of the solution?

    The solution is very scalability. I rate the scalability a ten out of ten. 

    How are customer service and support?

    Their technical team is very efficient. 

    How would you rate customer service and support?

    Positive

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

    We switched to SQL for the reliability and scalability.

    How was the initial setup?

    The initial setup is cumbersome as it's very menu-driven. The deployment takes half a day's time. We run it on a virtual machine or virtual service. We build a virtual server. We downloaded the ISO from Microsoft's licensing website.

    I rate the setup an eight out of ten. 

    What about the implementation team?

    The deployment was done by a single person, in-house. 

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

    The SQL server is affordable. I rate the pricing a five out of ten. 

    What other advice do I have?

    I rate the overall solution a ten 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
    Alvaro Callupe Arias - PeerSpot reviewer
    Key Account Manager at Sumteccorp
    Real User
    Sep 10, 2023
    Easy-to-learn product with good scalability features
    Pros and Cons
    • "The product’s most valuable features are flexibility and scalability."
    • "SQL Server could be more robust than one of its competitors."

    What is our primary use case?

    We use SQL Server for tuning data transactional language.

    How has it helped my organization?

    The product helps me tune the transactional language with the databases of our organization.

    What is most valuable?

    The product’s most valuable features are flexibility and scalability.

    What needs improvement?

    SQL Server could be more robust than Oracle.

    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 product could be more stable than Oracle.

    What do I think about the scalability of the solution?

    It is a scalable product.

    How are customer service and support?

    The technical support services need improvement in terms of communication. It is difficult to understand the accents of the executives from different countries.

    How was the initial setup?

    The initial setup is easy. The deployment services cost around $2000 to $3000.

    What was our ROI?

    SQL Server generates more return on investment than Oracle servers.

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

    The product’s price depends on the specific server requirements.

    What other advice do I have?

    I rate SQL Server an eight out of ten. It is easy to learn Microsoft products. There is a lot of information available about it on the internet.

    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 Cybersecurity and Compliance Coordinator at Plaenge
    Real User
    May 22, 2023
    Exceptional performance and robust stability, ensuring a highly secure environment
    Pros and Cons
    • "The most valuable feature of SQL Server is that it is easy to set up."
    • "There is room for improvement in terms of pricing for SQL Server."

    What is our primary use case?

    I use SQL Server for my SharePoint environment.

    How has it helped my organization?

    It offers exceptional performance and robust stability, ensuring a highly secure environment.

    What is most valuable?

    The most valuable feature of SQL Server is that it is easy to set up.

    What needs improvement?

    There is room for improvement in terms of pricing for SQL Server.

    For how long have I used the solution?

    I have been working with SQL Server for ten years.

    I am working on the most updated version.

    What do I think about the stability of the solution?

    I would rate the stability a nine out of ten.

    What do I think about the scalability of the solution?

    I would rate the scalability a nine out of ten.

    I plan to increase my usage in the future.

    How are customer service and support?

    I would rate the technical support a ten out of ten.

    How was the initial setup?

    The initial setup is straightforward.

    It is easy to install.

    What was our ROI?

    There is a return on investment. The cost benefits are good.

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

    The cost associated with SQL Servers is on the higher side.

    Which other solutions did I evaluate?

    While there are other options available such as Oracle Database, Firebird, and MySQL, we specifically chose SQL Server to fulfill our needs for Microsoft services.

    We opted for SQL Server as our scalable server solution to meet the requirements of our Microsoft services.

    What other advice do I have?

    It's a good solution.

    I would 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
    System Design Manager at a manufacturing company with 10,001+ employees
    Real User
    May 19, 2023
    A stable tool for any company that has got a Microsoft stack
    Pros and Cons
    • "I would say that it is a stable product."
    • "I would say that people should know how to get a SQL setup in place since it might be an area where they lack when it comes to the solution."

    What is our primary use case?

    We use the solution to provide the database layer for multiple applications.

    For how long have I used the solution?

    We have been using this solution for 10+ years.

    What do I think about the stability of the solution?

    I have had issues with SQL Server but Microsoft support has been able to resolve them quickly and most came down to configuration/design errors and not a stability of the product issue.

    How was the initial setup?

    SQL Server is quick to install < an hour.  Additional features increase the installation time.

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

    The SQL Server pricing model is based on CPU cores that your database server utilises.

    What other advice do I have?

    To others looking into using a SQL Server, I would say that it goes down to the application that you are developing and what funds you have available to run the total system.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Sr. Training Manager with 201-500 employees
    Real User
    Apr 6, 2022
    Stores all of our data, and there is nothing that it can't do
    Pros and Cons
    • "I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome."
    • "When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."

    What is our primary use case?

    It has all of our data. Our company sells contracts when you buy a car. We sell aftermarket insurance for the tyre, wheel, ding, dent, windshield, etc. When somebody buys a contract, we capture all of that data into a legacy database PostgreSQL, and my task is to incorporate that into our financial platform using T-SQL. So, I write queries, procedures, and views. I use SSIS, and I use SSRS. My job is to get the data into our financial system so that we can process claims, payments, cancellations, and refunds. 

    In terms of its version, we're up-to-date. We have version 2019.

    How has it helped my organization?

    This is the heart of the whole company. SQL Server is where all of our financials are. It has all of our data.

    What is most valuable?

    I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome.

    What needs improvement?

    When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that.

    For how long have I used the solution?

    I have been using this solution for 20 years.

    What do I think about the stability of the solution?

    We do clustering. If one SQL Server goes down, it automatically goes to another one.

    How are customer service and support?

    I don't ever need tech support. If it breaks, I can just rebuild it.

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

    They're now using a different database for contracting called Road Runner. I don't know what that is, and how it stores data. I don't know anything about it. 

    There is also Postgres. I like SQL Server more than Postgres. That's only because I know SQL Server. I don't know Postgres as well. So, I can't say which one is better because I don't have the same amount of experience in both.

    How was the initial setup?

    I can bring up a SQL Server in an hour or so and set it up.

    In terms of maintenance, the number of people required depends on the need. 
    We have a team of DBAs, developers, and UA analysts. We probably have 40 people in our IT area who are maintaining our solution. I'm just the developer. I'm the guy who makes the magic happen, but without other people collecting the information that I need to make the magic happen, I'm stuck. Without the guy who is an expert in permissions, partitioning, and performance tuning, I'm stuck. So, it's definitely a team effort. You can do it all, but you don't want to do it all because then you're running your head off, and you don't really get good at anything. It would be a jack of all trades, master of none type of scenario.

    What other advice do I have?

    You will seldom find a database that was designed correctly. Just because you got a poor-quality database doesn't mean that you're going to get a better database anywhere else. You rarely get to build a thing on your own. Usually, you inherit somebody else's stuff. So, the challenging thing is working with what you have while trying to implement a better solution. My only advice is to be patient.

    I would rate it a nine out of 10. I wouldn't give anything a 10 because I don't have that kind of knowledge, but right now, it does what I need it to do.

    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
    Karoly Krokovay - PeerSpot reviewer
    CEO at Informula Ltd
    Real User
    Mar 18, 2022
    Highly stable and secure, but stability could improve
    Pros and Cons
    • "The support from Microsoft has been good."
    • "SQL Server has good performance, but it could be better."

    What is our primary use case?

    We developed a product for banks and we store the data in SQL Server.

    What needs improvement?

    SQL Server has good performance, but it could be better.

    For how long have I used the solution?

    I have been using SQL Server for a couple of years.

    What do I think about the stability of the solution?

    The stability of SQL Server is very important for us because we provide services for banks. The banks need a secure and stable solution from us and we have requested from the cloud provider to give us this level of service.

    What do I think about the scalability of the solution?

    We have approximately 10 developers and architects using SQL Server. Additionally, we have approximately four end-users using the solution.

    How are customer service and support?

    The support from Microsoft has been good.

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

    I have previously used Oracle.

    How was the initial setup?

    The initial setup of SQL Server is not complicated. 

    What about the implementation team?

    We have four technicians that do the implementation and maintenance of the solution.

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

    There is a license required to use the solution and I am satisfied.

    What other advice do I have?

    I would recommend this solution to others.

    I rate SQL Server a seven out of ten.

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