No more typing reviews! Try our Samantha, our new voice AI agent.
IT Manager at a construction company with 51-200 employees
Real User
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.

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

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
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
Buyer's Guide
SQL Server
October 2026
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.
922,528 professionals have used our research since 2012.
Chief Technology Officer at a computer software company with 11-50 employees
Reseller
Top 10
Apr 10, 2024
Affordable and provides good integration and data analysis capability
Pros and Cons
  • "The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus."
  • "The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on."

What is our primary use case?

We use SQL Server for data warehousing or business-intelligent projects. When you leverage the solution with Azure, it's the only database you'll ever need. Oracle is overpriced, but Azure SQL and on-premise SQL are both great products.

What is most valuable?

The fact that SQL Server fully integrates within the entire Microsoft ecosystem is a plus.

What needs improvement?

The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on.

For how long have I used the solution?

I have been using SQL Server for 25 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?

Compared to other solutions like MongoDB and MySQL, SQL Server is a scalable solution.

How are customer service and support?

The solution’s technical support is okay.

How would you rate customer service and support?

Positive

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

Oracle is an expensive relational database, and its configuration can be overly complicated. Oracle is less user-friendly. MySQL is not a relational database, but it's a flat-file database. MongoDB is a free tool that allows you to get what you pay for.

How was the initial setup?

The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on. It could be complex, but any database platform will have some complexity.

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

Historically, SQL Server has been much more affordable than Oracle, which is overpriced.

What other advice do I have?

SQL Server can be used for web applications and Dynamics Business Central. Any Azure app will deploy some element of SQL Server. The solution's security features meet our data protection requirements. SQL Server integrates with Microsoft Active Directory, Microsoft Azure, and Microsoft Entra, making it secure. However, since SQL Server is the most popular product, it's also the most popular platform to be hacked.

The solution's data analysis capability, performance monitoring, and error logging are all pretty good. I would recommend SQL Server to other users.

Overall, I rate the solution ten out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Integration developer at Blackwoods
Real User
Apr 1, 2024
An easy-to-manage solution with good integration capabilities
Pros and Cons
  • "SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications."
  • "The tool's support needs to be improved."

What is our primary use case?

SQL Server, a widely adopted database management system, is utilized across numerous sectors. Initially competing with Oracle and Db2, SQL Server has gained popularity. It serves as the backend database for a variety of applications. 

What needs improvement?

The tool's support needs to be improved. 

For how long have I used the solution?

I have been using the product for 25 years. 

What do I think about the stability of the solution?

Performance issues are a common concern when using SQL Server. However, it's important to recognize that the problem may not solely lie with SQL Server. It is stable. My team has four members using it. 

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

I find that using SQL Server is more cost-effective than Oracle. Although Oracle remains the top choice regarding power and stability, SQL Server is steadily catching up. We still have dedicated administrators for Oracle maintenance, whereas SQL Server requires less maintenance. While I'm not entirely clear on all the technical features and comparisons, Oracle generally offers more advanced features, such as table-locking options.

How was the initial setup?

The tool's deployment is easy. 

What other advice do I have?

We also have a data warehouse. This warehouse feeds into Power BI for data presentation. Currently, we're in the process of transitioning because we have various teams and solutions in place.

The tool serves the purpose of managing all the data within a system. It is utilized extensively for storing, processing transactions, and conducting analysis.

I rate the overall product a nine out of ten. Its ability to integrate with other products is good. The tool is popular and easy to manage. You can find resources easily to manage it. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Database Administrator at Court of Audit Belgium
Real User
Mar 31, 2024
Stable and versatile option with a lot of capabilities
Pros and Cons
  • "The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities."
  • "Improvement in SQL Server should focus on lowering the high cost, especially for environments requiring extensive CPU and memory usage like data warehousing"

What is our primary use case?

In my data warehousing project, I use SQL Server alongside Power BI. SQL Server serves as the data storage solution, while Power BI is used for data visualization.

What is most valuable?

The most valuable features for database management in SQL Server are SQL Server Management Studio and Visual Studio Code with its administration capabilities.

What needs improvement?

Improvement in SQL Server should focus on lowering the high cost, especially for environments requiring extensive CPU and memory usage like data warehousing. While existing features are great, affordability is a significant concern, particularly for enterprise licenses. Additionally, enhancements in managing availability groups and clustering could be beneficial.

For how long have I used the solution?

I have been working with SQL Server for 20 years.

What do I think about the stability of the solution?

I would rate the stability of the solution as a nine out of ten.

What do I think about the scalability of the solution?

SQL Server is highly scalable, but the scalability comes with a price tag. Additionally, for on-premise deployments, hardware purchase is necessary, which can be a limiting factor. I would rate the scalability of the solution as an eight out of ten. We have approximately 500 users at our company.

How are customer service and support?

My experience with SQL Server's customer support has been positive in the past, but recently, I have noticed a decline in responsiveness, and now I would rate them as an eight out of ten instead of a perfect ten. While I used to receive prompt answers to my inquiries, I have had a question pending for several weeks now without a resolution. It seems that Microsoft's focus on Azure may be impacting their support for on-premise solutions like SQL Server.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup of SQL Server is straightforward and user-friendly and I would rate it at around an eight out of ten for ease of use. While the basic setup is simple, additional considerations for security may require some tweaking. 

Deploying a SQL Server for testing purposes typically takes around ten minutes, while for production, it can take an entire day due to the additional tweaking required for optimal performance and security.

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

SQL Server is generally more expensive than other solutions. I would rate the price of the enterprise version of SQL Server as a ten out of ten for being very expensive compared to the standard version. The enterprise version costs approximately 20 times more than the standard version.

What other advice do I have?

We use SQL Server Availability Groups for high availability. It supports our requirements well and is preferred over cluster solutions for its effectiveness.

SQL Server offers advanced security features like data masking, which allows users to restrict access to specific columns, enhancing data privacy and control. This capability is particularly useful for protecting sensitive information from even database administrators.

SQL Server is the primary technology we use, tightly integrated with our existing IT infrastructure and applications. We rely on Microsoft products for seamless compatibility and avoid unnecessary complexity by sticking to a single vendor ecosystem.

My recommendation for using SQL Server is that it is a stable and versatile option with a lot of capabilities. However, there are cheaper alternatives available on the internet that offer similar performance. It is essential to consider whether the cost difference justifies the added performance of SQL Server, especially when cheaper options can achieve comparable results with slightly slower hardware.

Overall, I would 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
ChristineSpence - PeerSpot reviewer
Software Solutions Account Manager at First Technology
Reseller
Mar 12, 2024
Helps users to manage their data but improvement is needed in pricing and support
Pros and Cons
  • "SQL Server is easy to manage."
  • "The tool needs to improve its pricing and technical support."

What is most valuable?

SQL Server is easy to manage. 

What needs improvement?

The tool needs to improve its pricing and technical support. 

For how long have I used the solution?

I have been working with the product for ten years. 

What do I think about the stability of the solution?

I rate the product’s stability a seven out of ten.

What do I think about the scalability of the solution?

I rate the tool's scalability a seven out of ten. 

How was the initial setup?

I rate the tool's deployment a seven out of ten. Deployment time depends on the customer's environment. 

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

I rate the product’s pricing a six out of ten.

What other advice do I have?

Our clients are from small, medium, and enterprise businesses. It helps users to manage their data. 

I rate the overall product an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer. Reseller
PeerSpot user
IT Analysis at Kirkby (Tyres) Ltd
Real User
Jan 8, 2024
Stores and retrieves data as requested by other software applications
Pros and Cons
  • "I think just having everything in one centralized set of databases where there is easily managed manageable."

    What is our primary use case?

    The solution is used as our backend database for our in-house applications. 

    How has it helped my organization?

    It's consolidated all of our Microsoft Access databases.

    What is most valuable?

    Having everything in one centralized set of databases is the most valuable feature.

    What needs improvement?

    Over the years additional features, data warehousing, cubing, just better performance and better manageability in terms of the actual Microsoft SQL Server AppLINK console.

    For how long have I used the solution?

    I have experience with SQL Server. 

    What do I think about the stability of the solution?

    It is a highly stable solution. It was our database of choice because of its reliability. It just does what it says on the tin. We've never experienced any issues with it. I've never experienced any issues with it crashing or anything like that. 

    What do I think about the scalability of the solution?

    The solution is very scalability. I rate the scalability a ten out of ten. 

    How are customer service and support?

    Their technical team is very efficient. 

    How would you rate customer service and support?

    Positive

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

    We switched to SQL for the reliability and scalability.

    How was the initial setup?

    The initial setup is cumbersome as it's very menu-driven. The deployment takes half a day's time. We run it on a virtual machine or virtual service. We build a virtual server. We downloaded the ISO from Microsoft's licensing website.

    I rate the setup an eight out of ten. 

    What about the implementation team?

    The deployment was done by a single person, in-house. 

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

    The SQL server is affordable. I rate the pricing a five out of ten. 

    What other advice do I have?

    I rate the overall solution a ten 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
    Isam Ahmed - PeerSpot reviewer
    System analyst at Ministry of Interior
    Real User
    Sep 6, 2023
    A reliable database management system that is able to handle significant volumes of data
    Pros and Cons
    • "The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables."
    • "There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."

    What is our primary use case?

    We use it for warehouse data management, as well as for statistical reports. It facilitates tabling and query processing while supporting multiple database operations. 

    What is most valuable?

    The solution is valuable because it seamlessly extracts reports and enables the collection of information from different tables.

    What needs improvement?

    There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets. Enhancing those two areas would significantly improve the operation. It is important to mention the licensing cost, as well. Optimization of the licensing options to fit different needs and businesses would be of great benefit. 

    For how long have I used the solution?

    I have used this solution for ten years. 

    What do I think about the stability of the solution?

    It is a robust and stable solution. Its tracking record is reliable and it can handle large volumes of data.

    What do I think about the scalability of the solution?

    SQL Server offers easy scalability, allowing databases to grow as the data and user base expand. 

    How are customer service and support?

    Their customer service is great. When we faced certain issues, they solved them fast. There were no problems with communication.

    How would you rate customer service and support?

    Positive

    How was the initial setup?

    The initial setup is easy, and integrating the system is okay. The only issue is regarding the customization of the business process of the organization, it might take some time. Ultimately, it depends on the client's specific needs.

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

    SQL Server is an expensive solution. Their pricing structure and licensing options are not budget-friendly, so I believe it is an essential factor to consider when choosing the right product.

    What other advice do I have?

    It proved to be a great fit for medium-sized enterprises, in terms of the variety of the tools it provides. For bigger projects and specific needs, there might be a need to employ different solutions such as Oracle, and ERP systems. But overall, it works great as a relationship database management system. I would rate it eight 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
    IT Cybersecurity and Compliance Coordinator at Plaenge
    Real User
    May 22, 2023
    Exceptional performance and robust stability, ensuring a highly secure environment
    Pros and Cons
    • "The most valuable feature of SQL Server is that it is easy to set up."
    • "There is room for improvement in terms of pricing for SQL Server."

    What is our primary use case?

    I use SQL Server for my SharePoint environment.

    How has it helped my organization?

    It offers exceptional performance and robust stability, ensuring a highly secure environment.

    What is most valuable?

    The most valuable feature of SQL Server is that it is easy to set up.

    What needs improvement?

    There is room for improvement in terms of pricing for SQL Server.

    For how long have I used the solution?

    I have been working with SQL Server for ten years.

    I am working on the most updated version.

    What do I think about the stability of the solution?

    I would rate the stability a nine out of ten.

    What do I think about the scalability of the solution?

    I would rate the scalability a nine out of ten.

    I plan to increase my usage in the future.

    How are customer service and support?

    I would rate the technical support a ten out of ten.

    How was the initial setup?

    The initial setup is straightforward.

    It is easy to install.

    What was our ROI?

    There is a return on investment. The cost benefits are good.

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

    The cost associated with SQL Servers is on the higher side.

    Which other solutions did I evaluate?

    While there are other options available such as Oracle Database, Firebird, and MySQL, we specifically chose SQL Server to fulfill our needs for Microsoft services.

    We opted for SQL Server as our scalable server solution to meet the requirements of our Microsoft services.

    What other advice do I have?

    It's a good solution.

    I would rate SQL Server a nine out of ten.

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Azizul Haque - PeerSpot reviewer
    AVP, IT Division at a financial services firm with 1,001-5,000 employees
    Real User
    Top 20
    Feb 12, 2022
    It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
    Pros and Cons
    • "It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature."
    • "It is secure, and it is fast."
    • "It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."
    • "Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."

    What is our primary use case?

    We use it for the banking database. It is for banking software, accounting software, and human resource software that we develop to run our bank.

    In our production environment, we are using SQL Server 2014 Enterprise, but we also have an installation of SQL Server 2019 for our development environment.

    How has it helped my organization?

    It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature.

    What is most valuable?

    We use SQL Server Reporting Services, and it is very good. We use scheduled jobs to transfer reports from one server to another server. 

    What needs improvement?

    It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness. 

    For how long have I used the solution?

    We have been using this solution since 2008.

    What do I think about the stability of the solution?

    For big organizations, like ours, SQL Server is very good in terms of reliability and security. It has the Always-On feature and many more features. I appreciate its reliability.

    What do I think about the scalability of the solution?

    I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size.

    In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

    How are customer service and support?

    So far, we didn't ask for any technical support.

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

    We used a flat-file database earlier, and since 2008, we have been using SQL Server. We started with SQL Server 2008 edition, and later on moved to 2012, 2014, and 2019.

    We switched because there were many problems in the flat-file database. There was so much inconsistency. Some files were updated, and some files were not. There were big network issues. SQL Server has eliminated such issues, so either all transactions happen or nothing happens. This is a Relational Database Management System, and this is at another level compared to the flat-file database.

    How was the initial setup?

    SQL Server is very user-friendly and very simple. It is very comfortable for us. We have been using it for a long time, so it is not a problem at all.

    The deployment of our production server took less than 15 days.

    What about the implementation team?

    It was done in-house with the help of our vendor. They have Microsoft-certified people. I have also worked on SQL Server for a long time, so we have an idea of how to migrate from one database to another. It was not a big issue for us.

    At present, we have five people for its maintenance.

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

    We are using licensed software for our environment. We have the Enterprise license, and we have a standard additional license.

    As compared to Oracle Database, SQL Server is less expensive. For mid-sized organizations, SQL Server is completely all right, but people say it can't support large organizations with more than 2,000 users.

    What other advice do I have?

    Before implementing SQL Server, you need to learn the concept, design, architecture, and data types of a relational database. You can learn it from YouTube. It is step-based, and you can install it. After that, you can migrate your existing SQL Server to the new SQL Server, depending on the size of the data, data architecture, and data type. 

    I would rate it an eight out of 10 because I'm satisfied with SQL Server. It is working fine.

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