No more typing reviews! Try our Samantha, our new voice AI agent.
Information Technology Division Director at Ethiopian Roads Administration
Real User
Top 5Leaderboard
Aug 4, 2024
Stores data from applications and helps to query data
Pros and Cons
  • "We use SQL Server for various data management scenarios. It allows us to query data, some of which spans over twenty years. We generate reports and perform analyses using this tool. It also comes with backup and recovery tools, which are essential features of the database engine."
  • "Regarding integration, the solution works well for different courses without any issues. However, if we want to add machine learning and AI capabilities for business analytics, that's an area where improvements could be made."

What is our primary use case?

Our main use cases involve using the tool for the database engine. We have a small team in our environment that develops and uses this database for data storage. The data collected by our application is stored in this database.

What is most valuable?

We use SQL Server for various data management scenarios. It allows us to query data, some of which spans over twenty years. We generate reports and perform analyses using this tool. It also comes with backup and recovery tools, which are essential features of the database engine.

What needs improvement?

Regarding integration, the solution works well for different courses without any issues. However, if we want to add machine learning and AI capabilities for business analytics, that's an area where improvements could be made.

As for security features, I believe additional security enforcement is needed. You have to implement extra measures on top of what's already there. We understand that the built-in security isn't as robust as expected, so additional solutions are necessary to enhance security.

For how long have I used the solution?

I have been using the product for 16 years. 

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

What do I think about the stability of the solution?

Regarding performance and scalability, we've been using this tool with over 20 years of data. Despite the large amount of data, it's still efficient and effective. We can query the data and perform various tasks without problems, as it serves as our main repository. For our specific use case, it's very effective in decision-making. Depending on their requirements, other organizations might choose different solutions like SQL, Oracle, Postgres, or MongoDB. They can use whatever solution fits their use case best, but this one works very well for us. The solution is stable. 

What do I think about the scalability of the solution?

The solution is globally well-known. It's scalable and has good integrability. You can interface with it using different APIs; some solutions can connect directly with the engine. So, from that perspective, we don't face any issues.

How are customer service and support?

The tool has vendor and partner support. However, we support ourselves. 

How was the initial setup?

SQL Server's deployment is easy. 

What about the implementation team?

We did the deployment in-house. 

What was our ROI?

The tool is very profitable for us. We initially acquired this solution for development purposes. We have small teams that develop applications using SQL Server as the back-end database engine.

What other advice do I have?

I rate the overall product a ten out of ten since it meets our requirements. Advice for others considering this solution depends on their specific requirements. They must consider whether they need Microsoft SQL Server, Oracle Database, SAP Database engine, or something else. Their particular needs will determine the best choice. In general, though, I would recommend Microsoft SQL Server. Anyone can acquire and use it based on their requirements. However, as I mentioned earlier, some security and performance improvements may be needed.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
HaiPham - PeerSpot reviewer
Managing Director at sea-solutión
MSP
Top 5Leaderboard
Jul 30, 2024
Provides effective security features, but the scalability needs improvement
Pros and Cons
  • "The setup process is straightforward."
  • "The product performance can become slow when the data reaches sizes like a terabyte."

What is most valuable?

SQL Server is easy to use. As a Microsoft product, it has an intuitive and user-friendly interface.

What needs improvement?

The product performance can become slow when the data reaches sizes like a terabyte.

What do I think about the stability of the solution?

The product is stable. 

What do I think about the scalability of the solution?

Our organization has a maximum of 100 SQL Server users. The scalability needs improvement.

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

We have used other solutions such as PostgreSQL, MySQL, and Oracle. 

SQL Server is often chosen for Windows platforms due to its compatibility. For other development environments, like PHP or Java, we might select MySQL or PostgreSQL, respectively.

How was the initial setup?

The setup process is straightforward. It involves running the setup file, configuring general settings, setting up a user account, and creating a database. After that, you can create tables within the database and start using it.

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

The product's price is reasonable. It requires a one-time license purchase, unlike Azure SQL, which operates on a subscription basis.

What other advice do I have?

SQL Server's performance is good enough for medium-sized applications. The security features are adequate and effective.

I rate it a seven 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
SQL Server
March 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
886,468 professionals have used our research since 2012.
IT Manager at a construction company with 51-200 employees
Real User
Top 5
Jul 27, 2024
Allows to set up redundant databases and replication in the databases
Pros and Cons
  • "The solution's most valuable feature is that we can set up redundant databases and replication in the databases."
  • "The solution’s pricing is high."

What is our primary use case?

We use SQL Server to query our database for specific reports we need to write for our clients.

What is most valuable?

The solution's most valuable feature is that we can set up redundant databases and replication in the databases. SQL Server has very good integration capabilities.

What needs improvement?

The solution’s pricing is high.

For how long have I used the solution?

I have been using SQL Server for ten years.

What do I think about the stability of the solution?

SQL Server is a very stable solution,

I rate the solution’s stability a nine out of ten.

What do I think about the scalability of the solution?

The solution’s scalability is quite good. Around 30 users use the solution in our organization. Currently, I use SQL Server about once a week.

I rate the solution an eight out of ten for scalability.

How was the initial setup?

On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup a nine out of ten.

What about the implementation team?

The solution was implemented by an in-house team in a couple of hours.

What was our ROI?

SQL Server has dramatically improved our ROI. We couldn't do without it, and it's been a very valuable tool.

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

On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing a seven out of ten.

What other advice do I have?

I would recommend the solution to users looking for any form of transactional database or commercial database.

Overall, I rate the solution 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
Matt Hardy - PeerSpot reviewer
Infrastructure Manager/Deployment Manager at Hivedome Consultancy Services
Real User
Top 20Leaderboard
Apr 15, 2024
An easy to use solution with third-party integrations
Pros and Cons
  • "It integrates well with other platforms."
  • "Running multiple instances on the same box would be beneficial."

What is our primary use case?

We use the solution as the backend for the application.

How has it helped my organization?

SQL Server is a backend for software products that our company writes and distributes.

What is most valuable?

SQL Server is easy to use, but there is a great deal of complexity that you can dive into to use it to its best. Also, it integrates well with other platforms.

What needs improvement?

SQL Server should make the pricing simpler. It should add simplified load-balancing features.

For how long have I used the solution?

I have been using SQL Server for 24 years.

What do I think about the stability of the solution?

There's a reporting database feature in SQL Server, but running multiple instances on the same box would be beneficial. That's one limitation we've encountered. Many of our customers utilize a hosting provider that offers multi-tenant SQL Servers, but we cannot implement a multi-tenant reporting database. 

What do I think about the scalability of the solution?

The solution’s scalability is good.

How was the initial setup?

There are a lot of different deployment options. The default options will work pretty well. We have to change a few things for our setup. Deployment is not at all long. It takes a couple of minutes. It took a long time for the first time because I had to go back and redo it and change the configuration, but it runs pretty smoothly now.

The deployment process follows: mount the ISO and run a script. That script retrieves some entries from a table and creates several instances based on that table using active directory SQL Server accounts, which is an out-of-the-box option. There are a lot of features that you can add to the setup to make it quieter. We've automated it so we can spin up an instance as needed for development processes.

What about the implementation team?

Deployment was done in-house.

What other advice do I have?

Overall, I rate the solution a 9 out of 10.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Domenico Beneventano - PeerSpot reviewer
Professor at University of Modena and Reggio Emilia
Real User
Apr 2, 2024
Users need to go through a simple initial setup process to use it
Pros and Cons
  • "The product's initial setup phase was simple."
  • "The interface of the tool has certain shortcomings, making it an area where improvements are required."

What is our primary use case?

There are no specific use cases attached to the solution. From an academic point of view, I make the tool available to the students for some training or tests. I also used it to compare the functionalities of Oracle Data Integrators with other data integration systems.

What is most valuable?

I can't comment on the valuable features of the product right now since I recently downloaded some whitepaper and manuals. I downloaded the documentation related to the tool, but I haven't used much of the system. I know that SQL Server is a good system, based on a report I read on the Gartner website.

What needs improvement?

The interface of the tool has certain shortcomings, making it an area where improvements are required.

For how long have I used the solution?

I have been using SQL Server for ten to twenty years.

What do I think about the stability of the solution?

It is a stable solution.

What do I think about the scalability of the solution?

I haven't tested the system for scalability. I use it for simple tasks.

As per our company's agreement with Microsoft, some of the software from Microsoft 10 was included in SQL Server when there were about 1,000 students attending database classes using it.

How was the initial setup?

The product's initial setup phase was simple.

What other advice do I have?

There were no specific projects for which I used the tool. I conduct classes related to data integration. I need to use some products attached to the data integration area having a Python framework. I wanted to compare the tool with some commercial tools such as Oracle Data Integrator.

I recommend the product to those who plan to use it.

SQL Servers and Power BI Report Servers can integrate well.

I rate the tool a seven to eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Senior General Manager at Worly Plumbing Supply, Inc.
Real User
Mar 26, 2024
Easy to use and provides good speed and data recovery
Pros and Cons
  • "Agent service is a good feature of SQL Server, where you can schedule certain tasks."
  • "SQL Server is an expensive solution"

What is our primary use case?

Most of our clients use SQL Server as a back-end source.

What is most valuable?

Agent service is a good feature of SQL Server, where you can schedule certain tasks. The solution's encryption feature allows the data to be encrypted while transferring from one place to another. The solution's performance and speed are also good. Indexing and Magic Tables are very good features of SQL Server. We have a different transition style with the solution.

What needs improvement?

SQL Server is an expensive solution, and its pricing should be reduced.

For how long have I used the solution?

I have been using SQL Server for 18 years.

What do I think about the stability of the solution?

SQL Server is a highly stable solution.

What do I think about the scalability of the solution?

The solution’s performance and scalability are very good. Our clients for SQL Server are enterprise businesses.

I rate the solution a 9 out of 10 for scalability.

How was the initial setup?

The solution’s initial setup is easy.

What about the implementation team?

The solution can be deployed within a few minutes.

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

SQL Server is an expensive solution.

On a scale from 1 to 10, when one is cheap and ten is expensive, I rate the solution's pricing a 9 out of 10.

What other advice do I have?

The solution has a good data recovery feature. There are a lot of ways you can recover data. You can manage the recovery, resilience, and disaster management with SQL Server. I would recommend SQL Server to other users because it's easy to use, stable, and has a lot of features. The solution is suitable for different types of companies as per the requirement, including small, medium, and large enterprises.

Overall, I rate the solution 10 out of 10.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Implementer
PeerSpot user
Sumeet  Zalpuri - PeerSpot reviewer
Data engineer at ASR Nederland N.V.
Real User
Mar 26, 2024
The restoration of data is very easy compared to any other database
Pros and Cons
  • "The solution is very intuitive and easy to use."
  • "The performance degrades when the data is huge."

What is our primary use case?

We extracted data from SAP and stored it in SQL Server. We created a connection between the Data Services Server and the SQL Server. If anything went wrong, there were SQL Server experts who took care of everything. So, we extracted data from our ERP system and stored it in SQL Server.

What is most valuable?

Whenever we had to restore the data, it was not as difficult as restoring the database to any other RDBMS. The restoration of data is very easy compared to any other database. The solution is very intuitive and easy to use. It is one of the best relational database systems in the market. The restore and backup strategy was not complicated. The ease of use was excellent compared to any other databases.

What needs improvement?

The performance degrades when the data is huge. It also degrades when there is a flux of data.

For how long have I used the solution?

I used the solution for four to five years.

What do I think about the stability of the solution?

The tool is stable. I rate the stability a seven out of ten.

What do I think about the scalability of the solution?

The tool is pretty scalable. We had 100 users in our organization. We can scale the tool vertically and horizontally.

What other advice do I have?

SQL Server is the best database when the data is not huge or when we know that the data is coming in at a specific rate. I rate the integration of the product with SAP BusinessObjects Data Services nine out of ten. It is easy. We did not come across any issues or delays. Every organization uses Microsoft. SQL Server is one of the oldest RDBMSs on the market. It is easy to use and intuitive. A lot of people know about it. The ease of use is greater than any other server in the market. Overall, I rate the solution an eight and a half 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
AhmadTalha - PeerSpot reviewer
Product owner at Digitt Plus (AFT)
Real User
Mar 22, 2024
A robust and secure solution that helps to store data
Pros and Cons
  • "SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
  • "The GUI needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening."

What is most valuable?

SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational.

The solution's security features are good. 

What needs improvement?

The GUI  needs improvement. From a technical perspective, it's quite complex, which may not be a problem for individuals with technical backgrounds like ours, especially since we've encountered similar interfaces. However, navigating the GUI can be challenging for newcomers or product owners without technical experience. For example, as someone transitioning from a developer role to a product management role, I find it relatively easy to use the GUI. But for those without a technical background, it's much more challenging to grasp what's happening. 

For how long have I used the solution?

I have been using the product for six years. 

What do I think about the stability of the solution?

I rate the tool's stability a nine out of ten. 

What do I think about the scalability of the solution?

The solution's scalability and performance depend on application size and data size. Overall, the performance is pretty good and decent. My company has 20-30 users. 

How are customer service and support?

I haven't contacted the technical support. Our DBA manages it. 

How was the initial setup?

SQL Server is easy to deploy. A five-member technical team maintains it. 

What other advice do I have?

I rate SQL Server a nine out of ten. It is robust, secure, scalable, and can store data. It can handle multiple users with good customer support. We have integrated it with IDE and Git. 

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