No more typing reviews! Try our Samantha, our new voice AI agent.
it_user1790718 - PeerSpot reviewer
Architect of Solutions at Interbank
Real User
Feb 25, 2022
It's an inexpensive solution that integrates well with cloud-based tools
Pros and Cons
  • "SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation."
  • "Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."
  • "Our biggest problem with SQL Server is latency."

What is our primary use case?

I have SQL Server running in an on-premise environment, but we are testing it out on the cloud. We are trying out using APIs to access a database. SQL Server creates a lot of opportunities for us. While some of the larger companies have Oracle, SQL Server is more common in Peru. I'm responsible for administration and implementation, including configuration and data replication.

What needs improvement?

Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems.

For how long have I used the solution?

I have been working with SQL Server for 10 years. 

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

I worked on Oracle Database for four years. In the last year, I have been working with various cloud databases, including Cosmos DB and DynamoDB in AWS and Azure.

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

What other advice do I have?

I rate SQL Server nine out of 10. SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation.

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
Ferhat Alkan - PeerSpot reviewer
Kurucu, Bilgisayar Programcısı at Optimus Yazılım
Real User
Feb 21, 2022
Easy to use and there is great value having the database engine running continually
Pros and Cons
  • "It's great that the database engine is always on."
  • "The solution doesn't have too many surprises and is easy to understand."
  • "The solution is lacking a compound index for comparing values."
  • "For Turkey, the licensing costs are too high."

What is our primary use case?

We are an independent software vendor and users of this product. I'm a company founder. 

What is most valuable?

The most valuable feature for me is that the database engine is always on.

What needs improvement?

The solution is lacking a compound index for comparing values as you find in PostgreSQL. SQL Server doesn't support that feature so we need to build binary indexes to be able to compare those compound values. I'd also like to see AI capabilities. Oracle has a cloud solution which maintains its own indexes. If you buy a service from Oracle's cloud system, it keeps track of the queries that you have made to the database and it automatically implements its own indexes. It's such a good optimized database and I'd like to see an SQL Server that maintains its own indexes with AI capability. 

I have an issue with memory support: If you create a table and a third procedure followed by an additional procedure using that third procedure, and then wish to alter the original table with the two dependent objects, you have to drop those third procedures and alter the table and recreate dependencies. Those dependencies make it impossible to work in an online environment. If there's a problem, for example, in your implementation and you have to modify a production system, for example, it can't be done. SQL Server generates DLL files in this instance and you can't change DLLs of a running program. It should be easy for them to solve. 

For how long have I used the solution?

I've been using this solution for 20 years. 

What do I think about the stability of the solution?

I have the issue of memory support but the solution is stable. 

 

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

For Turkey, the licensing costs are too high. Previously, independent software vendors like us would buy the license from Microsoft and resell to our customers.
For vendors it was half the retail price, but that's no longer possible. Sometimes enterprise companies buying in bulk can get licenses at a better price, but we don't have that and it's impractical for us to sell this solution. 

What other advice do I have?

The solution doesn't have too many surprises and is easy to understand. It's all dependent on the architecture and implementation. Newer products use code-first solutions and I'm not sure people will continue to go down the SQL path. If I were starting my project now, I would have chosen another database. 

I rate the solution eight out of 10. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
SQL Server
August 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: August 2026.
912,565 professionals have used our research since 2012.
reviewer1162596 - PeerSpot reviewer
Data Analyst at a healthcare company with 10,001+ employees
Real User
Feb 15, 2022
Useful online community, helpful support, and powerful
Pros and Cons
  • "SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful."
  • "My advice to others is SQL Server is a good tool to work with and there are a lot of community resources available to help you out in case you are stuck anywhere."
  • "SQL Server backups could be better."

How has it helped my organization?

SQL Server has helped us make better decisions through the queries that we have built.

What is most valuable?

SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful.

What needs improvement?

SQL Server backups could be better.

For how long have I used the solution?

I have been using SQL Server for approximately three years.

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?

I have found SQL Server to be scalable.

The solution is suitable for all-sized businesses.

How are customer service and support?

The technical support from SQL Server is quite good.

How was the initial setup?

I was satisfied with the implementation of the solution.

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

The price of SQL Server is great. In my company, SQL Server is part of the Microsoft Suite, we don't have to pay for any additional license costs, it's quite cost-effective for us.

What other advice do I have?

My advice to others is SQL Server is a good tool to work with and there are a lot of community resources available to help you out in case you are stuck anywhere.

I rate SQL Server a ten out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
PeerSpot user
Al Fath Nuur Rochman - PeerSpot reviewer
Co-Founder at a logistics company with 1-10 employees
Real User
Feb 12, 2022
User-friendly and reasonably priced system for storing and managing information
Pros and Cons
  • "Easy to implement and user-friendly relational database management system. This product is stable and scalable."
  • "My advice for people looking into using SQL Server is that it's the best choice, especially for those who are beginners with databases."
  • "The UX design of this system needs improvement."
  • "The product needs improvement in its UX design."

What is our primary use case?

We're using SQL Server for database work.

What is most valuable?

What I find most valuable in SQL Server is that it's user-friendly.

What needs improvement?

The product needs improvement in its UX design. A newer interface is what I'd like to see in the next release of SQL Server.

For how long have I used the solution?

I've been working with SQL Server for two years.

What do I think about the stability of the solution?

SQL Server is a stable system.

What do I think about the scalability of the solution?

SQL Server is a scalable system.

How are customer service and support?

I'm satisfied with the technical support provided by Microsoft for this product.

How was the initial setup?

SQL Server is easy to implement, especially because it's a very common system that we use in the workplace.

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

Pricing for this product is very reasonable.

Which other solutions did I evaluate?

I evaluated Oracle Database.

What other advice do I have?

SQL Server is a common product that I use on a daily basis, and I'm using its latest version. Most of my colleagues use it for database work.

200 people use this system in the company.

My advice for people looking into using SQL Server is that it's the best choice, especially for those who are beginners with databases.

My rating for SQL Server is nine out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Admin at IEC (Electoral Commission of South Africa)
Real User
Feb 10, 2022
Stable and scalable data storage for enterprise applications
Pros and Cons
  • "SQL is stable."
  • "SQL is our main data store for enterprise applications, all applications that we have in the organization."
  • "SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."

What is our primary use case?

SQL is our main data store for enterprise applications, all applications that we have in the organization.

What needs improvement?

SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features.

For how long have I used the solution?

I've been using this solution for a few years.

What do I think about the stability of the solution?

SQL is stable.

What do I think about the scalability of the solution?

This solution is scalable.

How are customer service and support?

I am satisfied with Microsoft's technical support.

How was the initial setup?

The initial setup was ok, it met our requirements.

What about the implementation team?

We implemented SQL ourselves, and it took around a week to install.

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

Subscriptions are available on a yearly basis.

What other advice do I have?

I would give SQL a score of 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
reviewer1314546 - PeerSpot reviewer
Senior Systems Engineer at a energy/utilities company with 201-500 employees
Real User
Jan 24, 2022
It is easy to deploy and easy to maintain, but they should provide faster support
Pros and Cons
  • "It is easy to deploy and easy to maintain."
  • "They need to improve their support. It should be faster."

What is our primary use case?

We are using it for various applications.

What is most valuable?

It is easy to deploy and easy to maintain.

What needs improvement?

They need to improve their support. It should be faster.

For how long have I used the solution?

I have been using it for a couple of years.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is scalable. We have more than a thousand users who use this solution. It is being used heavily, and we don't have any plans to increase its usage.

How are customer service and support?

Their support needs improvement. It should be faster.

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

We didn't use any other solution previously. We have been using it for a long time.

How was the initial setup?

It was easy.

What about the implementation team?

I can install it myself. We also have a technical team of three admins.

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

Its licensing is yearly. There are no additional costs. There is only the subscription license.

What other advice do I have?

I would recommend this solution to others. I would rate it a seven out of 10.

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
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.

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