Try our new research platform with insights from 80,000+ expert users
Karoly Krokovay - PeerSpot reviewer
CEO at Informula Ltd
Real User
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.

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.
846,549 professionals have used our research since 2012.

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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Ariful Ambia - PeerSpot reviewer
Executive Director at a manufacturing company with 5,001-10,000 employees
Real User
Intuitive features, low maintenance, and reliable
Pros and Cons
  • "SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
  • "Since this is a relational order system, scalability has a limit. If your system is very big, you need bigger servers and you have to spend more money. We scale a system up to a certain level, and then we move or shift data to the warehouse, which is NoSQL. We then do not have any bottleneck in scaling. For using this technique we are happy with it."

What is our primary use case?

We have a few transitional systems in our large company that we maintain with Microsoft SQL Server.

What is most valuable?

SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server.

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. However, every product has limitations. It is stable for a certain amount of workload. Beyond the capabilities of this solution, you will need other data solutions, such as Oracle. A solution that is more secure.

What do I think about the scalability of the solution?

Since this is a relational order system, scalability has a limit. If your system is very big, you need bigger servers and you have to spend more money. We scale a system up to a certain level, and then we move or shift data to the warehouse, which is NoSQL. We then do not have any bottleneck in scaling. For using this technique we are happy with it.

It is hard to tell or count how much data we are using because being one of the leading companies in Bangladesh, we have many teams who work on it. Different teams work on many different technologies.

We have not had an issue with the scalability SQL Server.

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

For databases, we have used a lot of data tests with other solutions, such as Oracle. We have used all Oracle data, Postgres, and a few others.

How was the initial setup?

The initial setup is very straightforward. You do not have to worry about the management of the SQL Server instance.

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

To scale the solution there are additional costs.

What other advice do I have?

I rate SQL Server 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
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.
846,549 professionals have used our research since 2012.
Owner at 2 Bit
Real User
Very fast with reliable, easy-to-access data
Pros and Cons
  • "For me, the initial setup is very easy as I have years of experience with the product."
  • "With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries."

What is most valuable?

The solution is very fast. 

The data is reliable and I can normalize the database and normalize the data so that I can collect whatever information I need. If I collect the data correctly, then I can share whatever report I want.

Normally, when the data is in the database, it will always be a long-term information holder, instead of putting it in Excel or something like a spreadsheet or something like that. 

For me, the initial setup is very easy as I have years of experience with the product.

What needs improvement?

I could use some more guidelines about making the correct queries to understand the structure better. I'd like to have a better idea and to understand how to make a nice query, which is good for the system and good for the hardware.

Sometimes you have to have different data in different tables and you want to merge them into something together. I'd like to be able to do this in a different way. 

Sometimes I need to have more optimization. I want to understand how can I optimize this or that? Especially now, when we're working with a lot of camera information, where we are using a lot of cameras for photogrammetry, we need to take this data and put it into the SQL Server and we would like to be more flexible with the data.

With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries. 

Those who are not familiar with the solution can find the initial setup intimidating and difficult. 

For how long have I used the solution?

I've been using the solution for 30 years at this point. 

What do I think about the scalability of the solution?

I don't have so much experience with scaling. It's my understanding that that task is a specialist job.

How are customer service and technical support?

I have dealt with technical support in the past. I'm happy with them. They have been helpful.

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

I'm not only working with SQL Server. When I need the database, I will always do it in SQL Server or Maria Database or something like that.

How was the initial setup?

For me, the initial implementation is easy, however, I know a lot of people can't set it up and believe everything is hard. It's difficult if you didn't know how to do it. You have to know, in the beginning, how to define what hardware you need and how many disks, for example. You need to understand if it should be a cluster disk or not. Long ago, it used to be hard disk access only. Things have changed. 

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

The solution does come at a cost.

What other advice do I have?

I'm a customer and an end-user.

This solution is one of my favorites and I would rate it at a nine out of ten. I'm very pleased with its capabilities. 

Microsoft has a freeware option that might be called something like SQL Server Express. I'd advise new users to try to put that one up. It's easy to implement. If you need more data, then buy the correct server. The SQL Server is expensive, however, when you see how nice data is installed and how easy you can get access to it, it may be worth it. If new users need help, they can always go to YouTube to find answers for the freeware.

SQL Server has a steep learning curve, however, it's worth it to learn about it and understand it. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Solution Architect at KIAN company
Real User
Highly scalable, easy to use, but better performance and monitoring needed
Pros and Cons
  • "The solution is very easy to use."
  • "SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."

What is our primary use case?

I have been working on SQL Server for installations, configuring for developers, and for creating backup jobs from the MBF files.

What is most valuable?

The solution is very easy to use.

What needs improvement?

SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable.

For how long have I used the solution?

I have been using this solution for approximately three years.

What do I think about the stability of the solution?

I have found the SQL Server stable.

What do I think about the scalability of the solution?

The solution is highly scalable. You are able to implement a SQL cluster mechanism for replicating the data between two nodes of the SQL Server. If one of the nodes is down the second node becomes active.

We have approximately 20 developers working directly with SQL Server and approximately 1,000 end-users that are working on the application that is behind the SQL Server.

How are customer service and technical support?

The technical support is good. We had a big problem and after an investigation, we could not find the solution. We needed to make use of Microsoft support team and open a specific case on the Microsoft panel. They were able to provide solutions for solving this issue.

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

I have used MySQL.

How was the initial setup?

The installation is not very complex. However, the process could take a long time because you have to follow the step-by-step instructions for the installation. The time it takes to do the installation is approximately two days.

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

There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford.

What other advice do I have?

I would recommend this solution to others.

I rate SQL Server a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Database Administration Team Leader at a transportation company with 10,001+ employees
Real User
A stable relational database management system with a valuable Always On feature
Pros and Cons
  • "I believe Always On is the most valuable feature. It's also easy to use and not very tricky."
  • "Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit."

What is our primary use case?

We use it for both database services and analysis services.

What is most valuable?

I believe Always On is the most valuable feature. It's also easy to use and not very tricky.

What needs improvement?

Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit.

For how long have I used the solution?

I have been using SQL Server for about 15 years.

What do I think about the stability of the solution?

It's stable. The database service is better than the analysis service, but it's quite stable. It's as stable as the support it has. If it has a good infrastructure and good machines with disks, it's quite stable.

What do I think about the scalability of the solution?

SQL Server is vertically scalable. We have about 3,000 people using this solution.

How are customer service and technical support?

We haven't used their technical support a lot. I would say it depends on the scope of the help you need. On a scale from one to ten, I would give technical support a seven.

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

I don't know the exact prices because my focus is essentially technical and not on the bills. A few years ago, they changed the billing policy for the Enterprise Edition, and it became less attractive. But I believe they are still cheaper than Oracle. SQL Server isn't cheap, but it's not expensive either. 

What other advice do I have?

I would tell potential users that it's important to have a good infrastructure, but my advice is for any database, not only SQL Server. It's important to have a good infrastructure and a good network if you're planning to use Always On and clusters. I believe the most important thing is the infrastructure where the SQL Server will be based.

On a scale from one to ten, I would give SQL Server an eight.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
IT manager at IRPC PCL
Real User
Top 10
An easy initial setup with good pricing and good stability
Pros and Cons
  • "The pricing of the product is very good."
  • "The solution could offer better integration with other solutions - specifically Microsoft."

What is our primary use case?

We primarily use the solution as a WAP server and we have it on-premises.

How has it helped my organization?

It's helped us connect to our company's machines.

What is most valuable?

The pricing of the product is very good.

We've found the stability to be very reliable.

The initial setup isn't too complicated. It's pretty straightforward.

What needs improvement?

Overall, the solution could be improved in future releases. We hope to improve the way we use it ourselves in our next project.

The solution could offer better integration with other solutions - specifically Microsoft.

For how long have I used the solution?

I've been using the solution for about five years at this point. It'd been a while.

What do I think about the stability of the solution?

Thus far, the solution has been quite stable. It doesn't crash or freeze. there aren't bugs or glitches. It works well for us overall and we find it to be reliable.

What do I think about the scalability of the solution?

I'm not sure about the capability of the solution's scalability. We've never really tested its capabilities, and it's therefore hard to gauge.

How are customer service and technical support?

We have a department that handles support. I find them knowledgeable. They respond in a reasonable amount of time. 

How was the initial setup?

The initial setup wasn't complex. It was pretty straightforward. We didn't have any issues with the implementation process at all.

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

The licensing is reasonable. It's not too expensive. We are charged on a yearly basis, however, I don't know the exact amount we are charged. I'm not a part of the billing and payments department.

What other advice do I have?

I believe we are using the 2019 version of the solution.

In general, I would recommend the solution to other organizations. We've mostly been pretty happy with its performance.

We're not Microsoft partners. We are just customers.

Overall, I would rate the solution eight out of ten. If it had better integration capabilities with Microsoft, I might rate it higher.

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
Technical Department Manager at Direcbusiness Technologies, Inc.
Real User
Straightforward setup and good stability
Pros and Cons
  • "We have many users, between 50 and 100 using the SQL Server product."
  • "Right now we don't get much technical support from Microsoft"

What is our primary use case?

We use it mostly for integration into an ERP system. We also use it for our internal development of products.

How has it helped my organization?

We have many users, between 50 and 100 using the SQL Server product.

What is most valuable?

We have been using SQL Server from the start, so it's a stable product.

What needs improvement?

I think a web console for the management studio, I think that would be a good thing. I think also on load balancing. I think that's something that we can use.

For how long have I used the solution?

We've been using SQL Server for 12 years. We are currently using the latest version. It is deployed on-premise and cloud.

What do I think about the stability of the solution?

The product is stable.

What do I think about the scalability of the solution?

The product is scalable.

How are customer service and technical support?

Right now we don't get much technical support from Microsoft. I think for all issues we encounter, we do the solutions by ourselves. I think if there should be some avenue for us to raise some issues that we are encountering, so maybe that would be something that's good for us as well. It is not easy to contact Microsoft support for this product.

How was the initial setup?

Setup required two engineers to deploy it. It was pretty straightforward and took one to two days.

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

We didn't have any licensing costs for SQL Server.

What other advice do I have?

I would recommend this product to others and give it an 8 out of 10.

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: Implementer
PeerSpot user
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.

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