Try our new research platform with insights from 80,000+ expert users
EverVidal - PeerSpot reviewer
Architect of Solutions at Interbank
Real User
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."

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
March 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
856,873 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
Serban Stancu - PeerSpot reviewer
Technical Director/ Project Manager / Consultant at SC Iceberg Data Intelligence SR
Real User
User-friendly and cost effective Server for ETL and reporting
Pros and Cons
  • "This solution is user-friendly and easy to understand."
  • "The stability of the solution should be improved in the next release. Sometimes it is great, sometimes it is troublesome. I would also like data conversion and the code pages to be a bit more straightforward."

What is our primary use case?

I am an integrator of this solution and my customers use this for ETL and reporting.

What is most valuable?

This solution is user-friendly and easy to understand.

What needs improvement?

The stability of the solution should be improved in the next release. Sometimes it is great, sometimes it is troublesome. I would also like data conversion and the code pages to be a bit more straightforward.

For how long have I used the solution?

I have been working with SQL Server for the past fifteen years.

What do I think about the stability of the solution?

Stability can be shaky.

What do I think about the scalability of the solution?

This is a scalable solution.

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

I use to work with Informatica via the Oracle package and switched to SQL because it is cheaper and a bit better than the others.

How was the initial setup?

This solution is pretty easy to deploy.

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

SQL Server has the best licensing price.

What other advice do I have?

There is a lot to learn about this solution when first using it, as with any other tool.

I would rate this solution an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
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.
856,873 professionals have used our research since 2012.
General Manager IT at a manufacturing company with 10,001+ employees
Real User
User-friendly database with excellent backup features
Pros and Cons
  • "The backup capabilities are extremely good."
  • "I would like to have the ability to restore backups in the next release."

What is our primary use case?

This application is used as a contact center and would be great for banks.

What is most valuable?

The backup capabilities are extremely good.

What needs improvement?

I would like to have the ability to restore backups in the next release.

For how long have I used the solution?

I have been working with SQL server for the past ten years.

What do I think about the stability of the solution?

This solution is very stable from what we have seen.

What do I think about the scalability of the solution?

This is a scalable solution.

How are customer service and support?

Technical support is very good. I am able to easily contact them and they are very informative.

How was the initial setup?

The initial setup was straightforward.

What other advice do I have?

This is a great solution for anyone with basic knowledge of DNS who wants to build up a database. There are many videos to help you navigate the platform.

I would rate this solution a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
PeerSpot user
Team Lead, Process Improvement at Fidelity Bank Plc
Real User
Easy to use, reliable and simple to set up
Pros and Cons
  • "Backups hardly get corrupt."
  • "The pricing could be more affordable."

What is our primary use case?

I use the client, however, I can also use the server, the Microsoft SQL Server Studio. I can use both, both the client and the studio.

We connected Automation Anywhere to the DB. Our reporting tool is also connected to that DB. Our financial application is also connected to the DB and some other databases too as well as some of our APIs.

What is most valuable?

I like the way it can manage the users from the security section where you can change their roles. 

SQL is simple to manage, as long as you know the script, and know the tables that you make reference to. If there are errors, you can easily debug them. 

You can easily debug and resolve your issues. 

The ease of backup, how you can back up and call up your backups too is great. Backups hardly get corrupt, except if maybe you have some bad hard drive clusters or bad hard drive sectors.

It is stable.

It's an easy-to-use product.

I find the solution to be scalable.

What needs improvement?

The pricing could be more affordable.

It's like to see less frequent updates. They should be once a month.

For how long have I used the solution?

I've been using SQL Server for a very long time.

What do I think about the stability of the solution?

The stability is great. It's very reliable. 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.

We have around 50 users on the solution right now. 

How are customer service and support?

The solution is pretty problem-free and therefore it would be rare to have to reach out to support.

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

We've always used SQL. I also use SQLite.

How was the initial setup?

The initial setup is very simple, very straightforward. It's not too complex. 

The time it takes to set up isn't long. The time of installation is determined by the local system or the server where you are installing it to. That said, it's a light solution. For me, it took maybe ten minutes. 

We have eight people who are technical and can handle deployment or maintenance tasks. 

What about the implementation team?

I did the installation myself. It's not hard to do. You don't need a consultant or integrator.

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

We pay a monthly subscription fee. 

What other advice do I have?

I'm an end-user.

I would recommend the solution to other users and organizations.

Overall, I would rate it at a 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
Al Fath Nuur Rochman - PeerSpot reviewer
Co-Founder at a logistics company with 1-10 employees
Real User
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."
  • "The UX design of this system needs improvement."

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
Ashif  Shaikh - PeerSpot reviewer
Senior Database Administrator at a tech services company with 501-1,000 employees
Real User
Secure, good GUI, and easy to use
Pros and Cons
  • "Its security is good. The GUI of SQL Server is also very good."
  • "It is very costly, and that's the reason people are moving away from SQL Server."

What is our primary use case?

We are using it for storing important data. 

What is most valuable?

Its security is good. The GUI of SQL Server is also very good.

What needs improvement?

It is very costly, and that's the reason people are moving away from SQL Server. 

They have started using Linux, and Linux is the way forward for SQL Server. They have to invest a lot in that.

For how long have I used the solution?

I have been using this solution for almost 10 years.

What do I think about the stability of the solution?

Its stability is good.

What do I think about the scalability of the solution?

Its scalability is good.

How are customer service and support?

I haven't spoken to their support team in the last three years, but prior to that, their support was good.

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

I also have experience with Postgres. The main difference between SQL Server and Postgres is that Postgres is open source. The Community version of Postgre is basically free. Postgres is very easy to set up and very easy to scale. It is quite a good database.

How was the initial setup?

It is very easy.

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

It is expensive in terms of licensing costs and pricing. If you want to scale SQL Server, it is very expensive.

We probably have to pay extra for technical support. We also have to pay for the license of Windows on which the SQL Server resides, which is an extra cost.

What other advice do I have?

I would recommend SQL Server for its stability, scalability, and ease of use. I would rate it an eight out of 10.

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
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
Alaa T Alhorani - PeerSpot reviewer
Sr. Consultant (Enterprise Architect) at Devoteam
Real User
Secure with great out-of-the-box functionality and works well as a database
Pros and Cons
  • "If we want to expand to other servers and create an extra node, it's expandable."
  • "It would be great if we were able to run it on multiple operating systems and not only stick with Windows."

What is our primary use case?

We use the product as a database, a data tool for everything. 

What is most valuable?

SQL Server, as a database, is great.

When it comes to the governmental sector, it is easily dealt with and can handle a big load of data. Specifically, after they added the capability of building a big data cluster from the SQL Server itself it's been great. 

If it was a database developer who was working with it or database admin, it provides a lot of tools and potential utilization that helps in doing the work in the right way.

Stability-wise, it's stable. 

If we want to expand to other servers and create an extra node, it's expandable. If you want to connect it with another, let's say, cloud node, it's also expandable with the cloud node. 

Security-wise, it provides most of the required security aspects in the market suchg as hashing, or encrypting, or hiding some data in tables (according to privileges and tools of the users). That can be done throughout it easily. 

It's an out-of-the-box solution. Lately, after they created the SQL Azure, if you use the Azure SQL Explorer, or SQL Server Management Studio, both of them can connect to the same database easily. It's natively built on the same core.

What needs improvement?

In my experience, while working with multiple sectors, such as banking, services, et cetera, there are some limitations for some sectors when dealing with the data.

It would be great if we were able to run it on multiple operating systems and not only stick with Windows. 

For how long have I used the solution?

I've been using the solution for five or maybe six years. It's been a while. 

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. Its performance is reliable. 

What do I think about the scalability of the solution?

It's very easy to scale the solution in multiple ways. If a company needs to expand, it can do so easily.

How was the initial setup?

I can't say it is easy to deploy as it depends on the admin, however, it is doable. Most of the databases, in general, require configuration. Therefore, if the admin knows what he's doing, then it's super easy.

A full deployment, depending on what is needed, might take anywhere from 15 to 30 minutes. It's fast.

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

I can't speak to the pricing. I don't have any information on that.

It's my understanding that we pay for licensing on a yearly basis. 

What other advice do I have?

There is also another added product they created, called Synapse, Azure Synapse Analytics. Both of them are similar to Microsoft PowerBI on-prem with SQL Server on-prem.

I would rate the solution at an eight out of ten. There are other competitors that are also doing a very good job as well.

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