No more typing reviews! Try our Samantha, our new voice AI agent.
reviewer1037115 - PeerSpot reviewer
senior system integrator at a retailer with 10,001+ employees
Real User
Jan 13, 2022
Easy to expand and a nice backend server, but requires active-active options
Pros and Cons
  • "We have found the solution to be scalable."
  • "The scalability is very good."
  • "There are a few use cases where we do need the Active-Active options instead of Active-Passive, yet those kinds of options are not available for Microsoft."
  • "The stability of the product needs to be improved. It's really not stable enough."

What is our primary use case?

We primarily use the solution as a backend server.

There are a few applications of the Oracle product for our data sitting on the SQL Server as well. 

What is most valuable?

It's useful as a backend server.

We have found the solution to be scalable. 

What needs improvement?

The stability of the product needs to be improved. It's really not stable enough.

In Microsoft, the Active-Active options are not available. There are a lot of requirements that are coming right from the customer, which may not be provided by Microsoft. There are a few use cases where we do need the Active-Active options instead of Active-Passive, yet those kinds of options are not available for Microsoft.

For how long have I used the solution?

We've been working with the solution for going on five years.

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

What do I think about the stability of the solution?

We've struggled with the stability of the product. We'd like for it to be more stable and reliable. 

What do I think about the scalability of the solution?

The scalability is very good. If a company needs to expand, it can do so.

What other advice do I have?

We are a customer and an end-user.

I would rate the solution at a seven out of ten. While the scalability is there, the solution is lacking a few aspects that customers really need.

Disclosure: My company has a business relationship with this vendor other than being a customer. Implementer
PeerSpot user
reviewer1595568 - PeerSpot reviewer
Technical Content Writer at a computer software company with 51-200 employees
Real User
Jan 11, 2022
Reliable with a simple setup but requires a knowledgable user
Pros and Cons
  • "The solution is stable. It's reliable."
  • "Since MongoDB, we have come up and there are lots of tools that do enhance the database management system or keep an eye on our data."
  • "The scalability could be better."
  • "It's not scalable. It hinders your performance as it's slow in nature and you need experienced people to work on it."

What is our primary use case?

We primarily use the solution to store databases. 

What is most valuable?

Since MongoDB, we have come up and there are lots of tools that do enhance the database management system or keep an eye on our data. People can easily access it. 

The solution is stable. It's reliable. 

The initial setup is simple. 

What needs improvement?

MongoDB is a bit better. A traditional database system, like the SQL Server, is failing to catch up.

You need an experienced person to use that piece of technology so that you can store everything in a logical manner. We'd like it to be easier to store in a logical manner.

The scalability could be better. 

For how long have I used the solution?

We've been using this solution since 2012. It's been a while at this point. 

What do I think about the scalability of the solution?

It's not scalable. It hinders your performance as it's slow in nature and you need experienced people to work on it. That is why it's not very scalable.

We currently have ten to 15 users on the solution. 

At this time, we have no plans to increase usage. We are focusing more on MongoDB.

How are customer service and support?

We don't have any experience with Microsoft technical support. Therefore, I wouldn't be able to rate how responsive or helpful they are.

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

We did not previously use a different solution. We are currently moving towards MongoDB, however.

How was the initial setup?

The installation is easy, especially since the new version has come up. Now, with the latest versions, installation is easy.

I cannot remember the time it took to complete the installation.

What about the implementation team?

Earlier, we had to bring in a technical team, however, our own technical team is quite experienced now. They can now do it themselves.

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

We pay a yearly subscription fee. 

What other advice do I have?

We use both cloud and on-premises deployment models. We're using the latest version of the solution. 

I'd recommend the solution to other users and organizations. If there are people who can't afford MongoDB or if an organization doesn't want to migrate to MongoDB, it's important to keep in mind the users would have to learn the fundamentals of the SQL server first. Knowledge of it is a necessity.

I'd rate the solution at a six 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
Buyer's Guide
SQL Server
May 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
900,644 professionals have used our research since 2012.
it_user646602 - PeerSpot reviewer
IT Officer at a manufacturing company with 201-500 employees
Real User
Jan 10, 2022
Easy to set up with ample online documentation to resolve issues independently
Pros and Cons
  • "Stability and usability, which is quite simple, are two of the solution's most valuable features."
  • "The solution could be better when it comes to security."

What is our primary use case?

While we were still using the solution, we employed version 2008, which is a bit on the old side. 

We basically used the solution for hosting the database for Sage ERP.

What is most valuable?

Stability and usability, which is quite simple, are two of the solution's most valuable features. 

What needs improvement?

The solution could be better when it comes to security. 

The solution is part of Windows services, which means that if these should stop running, the database system, too, would be affected. This makes it very crucial to constantly monitor the SQL Server, something which reflects on cheap personnel time. 

Scalability could be better.

Although it comes with a cost, using the most recent version is highly advisable, since it would ensure a certain measure of bug fixes and stability. The sole issue would involve the cost, as this is expensive. 

When it comes to integratable features, the monitoring should be addressed. 

For how long have I used the solution?

We used SQL Server for nearly six years, although we have since moved to another platform. We have used the solution at some point within the last 12 months. 

What do I think about the stability of the solution?

The solution has good stability, although my advice is to use the most recent version towards this end, to provide for bug fixes. This will ensure some stability. 

What do I think about the scalability of the solution?

The scalability could be improved. 

How are customer service and support?

As support would have involved a licensing fee, we opted not to make use of this. 

We find there is ample documentation online to allow us to resolve issues through independent research.

How was the initial setup?

The initial setup was straightforward.

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

Although it comes with a cost, using the most recent version is highly advisable, since it would guarantee a measure of bug fixes and provide some stability. The pricing is expensive, though, this being the sole issue. 

We chose not to make use of support, as this would have incurred a licensing fee. 

What other advice do I have?

I rate SQL Server as an eight 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_user1752759 - PeerSpot reviewer
Data Analyst
Real User
Jan 6, 2022
Its lead and lag functions have helped us reduce a lot of code needed when comparing rows
Pros and Cons
  • "I love SQL Server's Common Table Expression, and in addition to that, I like its lead and lag functions, which helped us reduce a lot of code when comparing rows in SQL Server."
  • "The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions."

What is our primary use case?

We primarily use SQL Server for reporting.

What is most valuable?

I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.

What needs improvement?

The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions. 

For how long have I used the solution?

I've been working with SQL Server for the past seven years. 

What do I think about the stability of the solution?

SQL Server is stable.

What do I think about the scalability of the solution?

SQL Server is scalable. I can't say if we'll increase usage in the future because I'm only working here as an analyst. It's a company decision. If necessary, then I can make a recommendation. I can go for that if the client wants, so it depends entirely on our client. If the client wants Oracle instead of Microsoft, I don't have an option.

How are customer service and support?

I never contacted Microsoft support about SQL Server, but I have called about Power BI one or two times. It was great support.

What other advice do I have?

I rate SQL Server eight out of 10. 

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1233759 - PeerSpot reviewer
Deputy Manager at a computer software company with 10,001+ employees
Real User
Dec 12, 2021
Helpful support, scales to our requirements, and handles our critical applications
Pros and Cons
  • "I have contacted technical support, and overall my experience with technical support was okay."
  • "SQL Server has scaled as per our requirements."
  • "I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements."

What is our primary use case?

We are business consults. We use SQL Server to ensure that critical applications remain operational by performing BCM activities across application and database servers.

What is most valuable?

SQL Server has scaled as per our requirements.

What needs improvement?

I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements.

For how long have I used the solution?

From a restoration perspective, I have been working with SQL Server for a few years.

What do I think about the stability of the solution?

The stability of the SQL Server needs improvements.

What do I think about the scalability of the solution?

We have over 2,000 users in our organization.

How are customer service and support?

I have contacted technical support, and overall my experience with technical support was okay.

How was the initial setup?

The installation took a few days to complete.

We have a team of three or four admins to maintain this solution.

What about the implementation team?

We had assistance from an integrator.

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

Licensing fees are paid on a yearly basis.

Which other solutions did I evaluate?

We were evaluating other solutions for a specific requirement in our organization. The requirement is now complete.

What other advice do I have?

I would recommend this solution to others who are interested in using it.

I would rate SQL Server an eight 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_user1711269 - PeerSpot reviewer
Technical Systems Support Manager at a hospitality company with 201-500 employees
Real User
Nov 30, 2021
Has a reliable database
Pros and Cons
  • "The solution has a reliable database."
  • "Microsoft support is an issue unto itself."

For how long have I used the solution?

We have been using SQL Server for more than 10 or 15 years. 

How are customer service and support?

Microsoft support is an issue unto itself. We mainly benefit from common support, such as a forum or Microsoft support, of which I don't have that much experience.

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

As with Oracle Database, the solution has a reliable database. I do not see much difference between the two when it comes to usage and the program decision to use one solution over another varies with the appropriateness of a given product, some utilizing Oracle, others Scale.

What other advice do I have?

I am an SQL partner. 

As with Oracle, SQL Server is deployed on private cloud. 

I rate SQL Server as a nine out of ten. 

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer938061 - PeerSpot reviewer
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
Real User
Nov 29, 2021
Easy-to-use interface for building queries
Pros and Cons
  • "The interface for building the queries or writing the store procedures is good."
  • "The solution is very easy to use, because even the technical engineers that we get are able to use it more efficiently."
  • "Additional interfaces would be an improvement."
  • "If I compare the solution with current technology needs, like NoSQL, that have been prevailing now, they could improve it so there could be a single solution, where we could deal with a single database for both transactional as well as for the in-memory needs that we have."

What is our primary use case?

SQL Server is the database for the transactional database that is being used.

The solution can be used for the BI, the data warehouse part as well, but mostly I have seen it used for the transaction data being stored by the DBMS part of it.

What is most valuable?

The solution is very easy to use, because even the technical engineers that we get are able to use it more efficiently. I like the programming interface they have where they help us get the table names that we are dealing with, and the field names in that particular table. 

The interface for building the queries or writing the store procedures is good.

What needs improvement?

If I compare the solution with current technology needs, like NoSQL, that have been prevailing now, they could improve it so there could be a single solution, where we could deal with a single database for both transactional as well as for the in-memory needs that we have.

For the integration part, additional interfaces would be an improvement. If SQL Server could expose certain APIs or certain interfaces which can be used for integration with the warehouse solution, then it would be great.

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 solution is scalable.

How was the initial setup?

The team needed for implementing the solution depends on the project size and functionalities needed. But as far as the DB administrator, generally, we use a single resource for each project. One database engineer is sufficient for optimizing the query or indexes or building any database scripts.

What other advice do I have?

I would rate the solution 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
CEO at netison
Real User
Nov 9, 2021
Simple to use and in demand among our customers
Pros and Cons
  • "SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
  • "Microsoft has a very broad landscape of products that they provide—almost everything that you need."

    What is our primary use case?

    We manage backups for our customers, so we are not developers and we don't use SQL to provide a service. We are a managed service provider focused more on IT support and SQL configuration. So we don't use SQL as a product by ourselves. Instead, we provide instructions for how to back up SQL and do maintenance on it for our customers who need a SQL server for their CRM and ERP products. Their products need to have a SQL server to use in order to use their services. So we handle the maintenance for our customers.

    What is most valuable?

    Microsoft has a very broad landscape of products that they provide—almost everything that you need. SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer. And even if you don't like Microsoft, you should know how to use it because just about every customer uses Microsoft, so you have to use it. So it doesn't matter if I like it. It's everywhere, so you have to know how to use it.

    For how long have I used the solution?

    I've been using Microsoft SQL Server for 25 years now.

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

    We are a reseller of Microsoft. We also signed the SPLA agreement, which stands for Services Provider License Agreement. So we are able to use Microsoft products in our data center in order to provide cloud services to our customers.

    What other advice do I have?

    I rate SQL Server nine out of 10.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer1707912 - PeerSpot reviewer
    System Analyst and Team Lead at a tech services company with 11-50 employees
    Real User
    Nov 9, 2021
    Stable, scalable, and simple installation
    Pros and Cons
    • "Many developers like SQL Server."
    • "SQL Server is stable."
    • "The solution could improve by having more integration with other operating systems and other platforms."
    • "I would not recommend this solution."

    What is our primary use case?

    I am a professional and I use this SQL Server in different companies. One of the companies I worked for was in the automotive industry. They had automobile products which they developed the SQL Server and database. At that time it was the first time I used SQL Server. I have also used Suprema which is a biometric system that also had an SQL Server. Our main products for data we have used SQL Server. However, my main application is developed on Oracle and MySQL, not any other database solution.

    All of our systems use this solution, it can control security, data management, and integration. 

    What is most valuable?

    Many developers like SQL Server.

    What needs improvement?

    The solution could improve by having more integration with other operating systems and other platforms.

    For how long have I used the solution?

    I have used SQL Server within the past 12 months.

    What do I think about the stability of the solution?

    SQL Server is stable.

    What do I think about the scalability of the solution?

    The solution is scalable.

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

    I have used MySQL.

    How was the initial setup?

    If you follow the restoration policy, the installation is not a problem. If you want connectivity in the application then you have to open the ports and configure them. Otherwise, I'm very pleased it is very simple.

    What about the implementation team?

    I can do the implementation myself.

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

    SQL Server is under a license from Microsoft.

    What other advice do I have?

    I would not recommend this solution.

    I rate SQL Server a six 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
    reviewer1703928 - PeerSpot reviewer
    Enterprise Solutions Architect at a comms service provider with 501-1,000 employees
    Real User
    Nov 2, 2021
    Good Support, and easy to install
    Pros and Cons
    • "SQL Server scales well."
    • "While this is a reliable product, it has room for improvement."

    What is our primary use case?

    We use SQL Server as a database management system for all of our projects.

    What needs improvement?

    While this is a reliable product, it has room for improvement.

    Although Microsoft SQL was accessible in some projects, we did not use it everywhere. It is determined by the project. It's quite beneficial in some circumstances, but it couldn't support SQL databases in others, consequently, we used other suppliers like Oracle, Informix DB, PostgreSQL, MySQL, and others.

    For how long have I used the solution?

    We have been using SQL Server for quite some time now.

    We use it both on-premises and in the cloud. It is dependent on the projects.

    What do I think about the stability of the solution?

    SQL Server is a stable solution.

    What do I think about the scalability of the solution?

    SQL Server scales well.

    In the future, we may expand our usage.

    How are customer service and support?

    I don't have any issues with the technical support.

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

    We evaluated each product after using it, starting with Informix DB and ending with Oracle.

    Oracle, Informix DB, PostgreSQL, and MySQL are among the products we use.

    How was the initial setup?

    It's quite easy to install.

    Completing the installation is not an issue.

    What about the implementation team?

    My position is not related to installation, but if it is necessary, I am capable of doing it.

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

    It requires the purchase of a license. Our company's products all have licenses.

    What other advice do I have?

    It is appropriate for small and medium-sized businesses.

    I would recommend this solution to others.

    I would rate SQL Server an eight 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: May 2026
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.