Try our new research platform with insights from 80,000+ expert users
Mudasir Shafi - PeerSpot reviewer
Testing Lead at Enstoa
Real User
Integrates well, good support, and quick deployment
Pros and Cons
  • "The most valuable features of SQL Server are the speed, great support, and it is from a known vendor."
  • "The security features of the solution could be better."

What is our primary use case?

We are using SQL Server for data processing.

What is most valuable?

The most valuable features of SQL Server are the speed, great support, and it is from a known vendor.

What needs improvement?

The security features of the solution could be better.

For how long have I used the solution?

I have used SQL Server within the past 12 months.

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

What do I think about the scalability of the solution?

SQL Server is a scalable solution.

We have approximately 200 users using this solution. We increase the number of users every year.

How are customer service and support?

I have not contacted their technical support.

How was the initial setup?

The process for the deployment is straightforward. It takes approximately four hours to complete.

What about the implementation team?

We did the implementation of SQL Server in-house. We have eight people managing the solution. The team includes managers, technicians, and administrators.

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

There is a subscription that needs to be purchased to use the solution.

What other advice do I have?

I would advise others this is a good Microsoft solution.

I rate SQL Server a nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1159494 - PeerSpot reviewer
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
Real User
Gives you all the basic requirements and can be integrated with other applications
Pros and Cons
  • "The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases."
  • "Other than Synapse and the other version of SQL Server, they face some problems while processing the data."

What is our primary use case?

Our use case is creating data warehouses using the SQL Server database.

The solution is deployed on-premises and on public and private clouds.

What is most valuable?

The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases.

What needs improvement?

Other than Synapse and the other version of SQL Server, they face some problems while processing the data. For example, the one issue we face is that when we need to process the queue, it's costly with Azure and SQL Servers. We also face some memory issues with that.

For how long have I used the solution?

I have been using this solution for more than eight years.

What do I think about the stability of the solution?

The solution is very stable.

What do I think about the scalability of the solution?

The solution is scalable.

How are customer service and support?

We have a different technical team that deals with issues. So we only communicate the issue to them, and they communicate with the team.

How was the initial setup?

Setup is very easy, especially compared to Oracle.

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

Synapse is a bit costly. If I compare it with different databases, I think it's a reasonable price. If I'm talking about licensing of the Oracle, it seems that normal organizations have it and some smaller organizations can also afford it, which is a good thing.

Which other solutions did I evaluate?

I have also evaluated Oracle.

What other advice do I have?

I would rate this solution 8 out of 10. 

I always recommend SQL Server. To whoever asks me, I will say, "Just go for it." The databases are good. In terms of pricing, SQL Server is good. In terms of functionality, it gives you all the basic requirements. You can also integrate it with different applications, which is an advantage.

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
Buyer's Guide
SQL Server
March 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
reviewer1566654 - PeerSpot reviewer
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees
Real User
Plenty of features, flexible, but could be more scalable
Pros and Cons
  • "I have found the most valuable features to be the flexibility and the vast amount of features available."
  • "The scalability is adequate but could improve."

What is our primary use case?

I use the solution for analytics and reporting.

What is most valuable?

I have found the most valuable features to be the flexibility and the vast amount of features available.

For how long have I used the solution?

I have been using the solution for approximately three years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The scalability is adequate but could improve. We have approximately 100 people using the solution in our company.

How was the initial setup?

The installation is not difficult, it is quick. It took approximately 15 minutes to complete.

What about the implementation team?

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

What other advice do I have?

I recommend this solution to others.

I rate SQL Server a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
System administrator at a mining and metals company with 10,001+ employees
Real User
Has high availability and good performance
Pros and Cons
  • "The availability is the most valuable feature. It has high availability. It also has good performance."
  • "In terms of improvement, it could use more integration with other products."

What is our primary use case?

My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.

What is most valuable?

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

What needs improvement?

In terms of improvement, it could use more integration with other products.

For how long have I used the solution?

I have been using this solution for around ten years. 

What do I think about the stability of the solution?

The stability is good. We don't have any issues with stability or scalability. 

How are customer service and technical support?

We have contacted support when we had Windows issues. They are okay, not the best but not the worst. They know what they're doing but they take a little too long. The response time isn't so good. 

How was the initial setup?

The initial setup is mostly straightforward. The time it takes to deploy depends on the circumstances. It takes around three or four hours. 

What other advice do I have?

I would recommend this solution. It's a good product. I am satisfied with it. It's familiar, we've been using SQL for a while. 

I would rate it a nine out of ten. There's always room for improvement. 

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user715902 - PeerSpot reviewer
CEO and Founder at a tech services company
Consultant
For Mission Critical Systems, Data Warehouses, And Big Data Solutions.

What is most valuable?

Performance improvements, optimizer enhancements. Most of our clients have high demands for performance, and this version of SQL Server delivers what we need.

How has it helped my organization?

We are a professional services company, so we use SQL Server to help our clients achieve their goals. Our clients use SQL Server 2016 for their most demanding mission critical systems, for data warehouses, and big data solutions.

What needs improvement?

The Query Store is a good start, but I expect the query processor to be a lot smarter and to use machine learning in order to improve and adjust execution plans automatically.

For how long have I used the solution?

One year.

What do I think about the stability of the solution?

Since we are working with a lot of clients on many edge cases, we encounter bugs and stability issues once in a while, but these are rare.

What do I think about the scalability of the solution?

If you know how to work with the product and leverage its various features and possibilities, then you can achieve great scalability.

How are customer service and technical support?

Microsoft offers several levels of technical support, which is OK, but not too good. But there is a wonderful community with lots of resources on the internet, so most issues can be solved without contacting Microsoft support.

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

No, I have been using SQL Server for the past 20 years.

How was the initial setup?

The initial setup is very clear and friendly. It has improved from the previous version.

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

Unfortunately, SQL Server licensing is a very complex topic. I advise people to consult with a licensing expert.

Which other solutions did I evaluate?

No.

What other advice do I have?

Download the Developer Edition for free, install it on your personal computer (it’s very easy), and start exploring. If you need help with something, just search for it on the internet, and you’ll find a wealth of resources about everything you need.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
IT Consultant & IT Project Manager Assistant with 10,001+ employees
Vendor
SSIS, SSRS, and DB help in everything.

What is most valuable?

The SSIS, SSRS, and DB are the most valuable features because they help in everything.

How has it helped my organization?

There is improvement in the performances and stability.

What needs improvement?

SSIS needs improvement.

I think that it should be easier in managing SQL packages, especially when we have multiple environments. With Kerberos Authentication, we had different issues on this and sometimes, we needed Microsoft Support too. Thus, a better and an organized SQL package review is needed.

What do I think about the stability of the solution?

When using HA (high availability), we experienced some stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

Technical support is the best, I would give them a 10/10 rating.

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

We were using a few other solutions such as MySQL, Oracle and Pervasive PSQL.

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

It’s okay as compared to the features that it has.

Which other solutions did I evaluate?

We evaluated the Oracle solution.

What other advice do I have?

If you want stability, then choose the best.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Craig Kona - PeerSpot reviewer
Chief Information Officer at SYNOVA CONSULTANCT
Real User
Top 5
High performance, setup straightforward, but priced high
Pros and Cons
  • "The most valuable feature of SQL Server is the performance."

    What is our primary use case?

    We use SQL Server for developing systems.

    What is most valuable?

    The most valuable feature of SQL Server is the performance.

    For how long have I used the solution?

    I have been using SQL Server for years.

    What do I think about the scalability of the solution?

    We have approximately three people who are using this solution.

    How are customer service and support?

    The technical support from Microsoft has been good.

    How was the initial setup?

    The initial setup of SQL Server is straightforward.

    What about the implementation team?

    We have two administrators that did the implementation of the solution.

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

    The price of SQL Server could be reduced, the license is expensive. We have an annual subscription.

    What other advice do I have?

    I would recommend SQL Server to others.

    I rate SQL Server a seven out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Senior Systems Engineer at Dimension Data
    MSP
    Top 5
    Good usability, satisfactory performance, and easy setup
    Pros and Cons
    • "Its usability is very good. Its performance is satisfactory."
    • "Their support could be better. There should be more visibility on the progress of the ticket, and their last line of support should be more knowledgeable. Other than that, we have nothing to complain about."

    What is our primary use case?

    It is for supporting our custom applications. We have a number of custom applications that we use that have SQL embedded.

    I am using the version before the latest one.

    What is most valuable?

    Its usability is very good. Its performance is satisfactory.

    What needs improvement?

    Their support could be better. There should be more visibility on the progress of the ticket, and their last line of support should be more knowledgeable. Other than that, we have nothing to complain about.

    For how long have I used the solution?

    I have been using this solution for seven to eight years.

    How are customer service and support?

    Their support could be better. Sometimes, you don't have much visibility of how your service request is progressing. There should be more visibility, and the last line of support should be more knowledgeable.

    How was the initial setup?

    It was straightforward. It took two to three hours.

    What about the implementation team?

    We have internal staff for its implementation. We have a team of about three or four people who are well-versed with SQL Server, and we have 30 to 40 users who use this solution.

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

    You need to pay for the license. It most probably has per-core licensing.

    What other advice do I have?

    I would recommend this solution to others. We are satisfied with the product in general. Overall, I'd rate it an eight out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
    Updated: March 2025
    Product Categories
    Relational Databases Tools
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.