The solution can be used for a host of applications.
IT Manager at Ducart
Scalable, stable and easy to use for a host of applications
Pros and Cons
- "The solution can be used for a host of applications."
- "The maintenance and tasks should be improved so as to reduce database files."
What is our primary use case?
What needs improvement?
The maintenance and tasks should be improved so as to reduce database files.
The complexity of the database should also be reduced, so that its size can be diminished.
For how long have I used the solution?
I have been using SQL Server for around ten years.
What do I think about the stability of the solution?
The solution from the 2008 version is stable. I like the defined database and the ease with which it can be used and that enquiries can be made.
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.
860,592 professionals have used our research since 2012.
What do I think about the scalability of the solution?
I believe the solution to be scalable and plan to increase our usage.
How was the initial setup?
Installation is relatively easy, although I do not recall how long it took.
What about the implementation team?
We made use of an integrator.
There is not much technical team required for the deployment and maintenance. It consists solely of engineers.
What's my experience with pricing, setup cost, and licensing?
The licensing is on an annual basis.
Which other solutions did I evaluate?
Prior to going with SQL Server I utilized the Oracle Database.
What other advice do I have?
There are around 15 people making use of the solution in our organization. Every computer processing unit has its own license.
I would recommend the solution to other users.
I rate SQL Server as an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Solutions Architect at One Click
Knocks ROI out of the park
Pros and Cons
- "Scalability, cluster ability, ease of use, ease of implementation — these are all great."
- "In terms of exceptionally large databases, it doesn't scale as well as Oracle."
What is our primary use case?
SQL Server is enterprise database software. It provides the back end for any number of different applications, including web applications, and other types of internal applications, and software-based applications. It also provides a back end for enterprise backup tools. It's incredibly diverse in terms of its use case.
What is most valuable?
Scalability, cluster ability, ease of use, ease of implementation — these are all great.
What needs improvement?
In terms of exceptionally large databases, it doesn't scale as well as Oracle. It scales excellently and it's flexible and it can provide a solution for exceptionally large databases, but it doesn't work as well as Oracle does for this particular use case. The performance starts to drag in the case of exceptionally large databases; especially where there's a lot more feature functionality. With Oracle, there's a lot more tunability.
For how long have I used the solution?
I have been working with this product for 20 years.
What do I think about the stability of the solution?
It's exceptionally stable. The ease of implementation and the ease of use can't be beaten. I think it's outstanding overall.
What do I think about the scalability of the solution?
Scalability-wise, it's outstanding. The one limitation it has is that at the very, very high end of petabytes-sized databases, it doesn't scale as well as Oracle. Still, you're not going to run into very many exceptionally large databases. Almost 100% of the use cases for it scale very well.
How are customer service and technical support?
Technical support is available for a separate cost. If you don't have a subscription or a support contract, then you don't get support. You'll be stuck with online forums — that's how you'll have to get answers to questions. Assuming you have a support contract with Microsoft, it's outstanding.
How was the initial setup?
The initial setup was straightforward.
What was our ROI?
This solution is available at a much lower price point than Oracle. Plus, it includes 99% of the same feature functionality. I'd say it knocks ROI out of the park.
What other advice do I have?
If you're interested in using this product, make sure that you have a good understanding of best practices for database implementation. Make sure to incorporate them in your deployment right off the bat. You won't want to have to go back and have to take production databases down because you have to change the configuration, post-implementation. Make sure you get all of these things done, pre-production implementation.
They've come a long, long way in the 20 years I've been working with them. Overall, on a scale from one to ten, I would give SQL Server a rating of nine.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
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.
860,592 professionals have used our research since 2012.
Domain architect at a financial services firm with 10,001+ employees
Rich feature sets, business oriented, and reliable
Pros and Cons
- "The solution is easy to use, has rich feature sets, and is business-oriented."
- "They could improve the solution by allowing more portability between on-premise and the cloud."
What is our primary use case?
There are many applications between Microsoft and SQL. Most are in the legacy direction, but some are more modern databases with those application requirements. We have used it for multi-purposes such as back-office products applications and cloud office environments.
What is most valuable?
The solution is easy to use, has rich feature sets, and is business-oriented.
What needs improvement?
They could improve the solution by allowing more portability between on-premise and the cloud.
More improvements can be brought around hyper-threading. Like we see in work engines of hyper-threading. It is very complex in terms of the way they do it. If it was via CPU or something else, it would be much easier.
In a future release, they could improve by expanding their form base capabilities.
For how long have I used the solution?
I have been using the solution for a couple of years.
What do I think about the stability of the solution?
I have found the solution to be very stable.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and technical support?
The support is good for the solution.
Which solution did I use previously and why did I switch?
We used Oracle and DB2 in the past.
How was the initial setup?
Initially, the installation took a while. We have started deploying configurations that are now standardized. We have automated it, but it can still be problematic. For the most part, the installation is now quite easy. Additionally, The way they have many configurable parameters that influence performance is in a way problematic.
What about the implementation team?
We did the deployment of the solution and we have a team of 15 people doing the deployment and maintenance.
What's my experience with pricing, setup cost, and licensing?
The licenses are really expensive. Their licensing model should be more simplistic.
What other advice do I have?
I would recommend this solution to others and we plan to keep using it in the future.
I 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.
BI Developer at a tech services company with 51-200 employees
Provides comprehensive functionality that makes tasks incredibly easy
Pros and Cons
- "The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
- "I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage."
What is our primary use case?
SQL Server is used to establish secure storage and protect databases from potential vulnerabilities, including those originating from Slack.
What is most valuable?
The most valuable aspect is the ability to use jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed.
What needs improvement?
I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved.
SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format.
I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage.
I have not seen significant returns thus far, but I am eager to enhance my experience by transitioning to work in Azure. This shift to Azure is something I am motivated to improve upon.
For how long have I used the solution?
I have been working with SQL Server since 2018.
What do I think about the stability of the solution?
We have not had any issues with the stability of SQL Server.
What do I think about the scalability of the solution?
Scalability is dependent on memory.
The matter at hand pertains to whether we are discussing an issue in general or specifically in the context of on-premises environments. However, it is clear that memory and capacity are significant factors in both scenarios.
Proper management of memory and capacity is essential to ensure smooth system operation and prevent any performance or stability issues.
As a result, it is essential to handle these issues completely and appropriately in order to meet the system's requirements.
How are customer service and support?
I have not contacted technical support.
How was the initial setup?
The installation process is not complex, but it requires attention to detail in terms of selecting the necessary services and configuring the Cisco server.
This ensures a proper setup and a tangible model for effective management. While it may not be complicated, it is important to choose the appropriate features during installation.
Working with ID was not my primary focus; however, I have had the opportunity to work with it for several companies.
What about the implementation team?
It can take an hour to an hour and a half to deploy.
Maintaining it is more challenging than the initial setup. One of the main concerns is ensuring sufficient memory allocation. The default capacity is typically set around sixty, but it can be increased if needed. If there is insufficient memory, it can lead to server downtime and cancellation of transactions, as exceeding the memory limit poses a risk. Therefore, it becomes crucial to address this issue by allocating more memory resources. Additionally, backups and restores play a significant role in ensuring data safety and recovery in case of any issues.
What's my experience with pricing, setup cost, and licensing?
For a brief period, approximately one year before 2018, I had experience working with the open-source version of SQL Server. During that time, I found SQL Server to be the preferred choice, in my opinion.
What other advice do I have?
I developed an application for specific purposes related to McDonough. Using Microsoft SQL Server, I constructed the entire database and implemented supporting stored procedures. This application was commissioned by the European Union to enhance government institutions and similar entities.
Additionally, I worked on financial-related stored procedures specifically related to Serbia Card, as part of a project for the USA.
We acted as a subcontractor for S&P within your company. I have extensive experience in SQL Server, particularly within the Microsoft environment.
They should think twice before they do anything and double-check. Definitely.
I have explored different options such as SonicWall and open-source solutions, but my preference lies with SQL Server. I find SQL Server to be fantastic, as it provides comprehensive functionality and makes tasks incredibly easy.
Working with Postgres is also simpler compared to other databases like Oracle. Perhaps my familiarity with Excel has made SQL Server more intuitive for me. While I understand that Oracle is known for its complexity, I appreciate that its code and syntax bear similarities.
Overall, I have a strong affinity for Microsoft products.
I would rate SQL Server a ten out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Sr. Systems Analyst at a maritime company with 10,001+ employees
Low-cost product that does what you want and is easy to set up
Pros and Cons
- "Microsoft is less demanding because everything is GUI, unlike Oracle, where you need to use command lines."
- "SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems."
What needs improvement?
Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
For how long have I used the solution?
I've been using SQL Server for thirteen to fourteen years.
What do I think about the stability of the solution?
SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems.
How was the initial setup?
The initial setup was very easy - much, much easier than Oracle - and took about a day to complete. Microsoft is less demanding because everything is GUI, unlike Oracle, where you need to use command lines.
What's my experience with pricing, setup cost, and licensing?
This is a very cheap product.
What other advice do I have?
SQL's performance is good enough if you have a low amount of data. For those looking into implementing SQL Server, I would advise first analyzing your requirements and whether your system is critical or non-critical. If it is non-critical, go for SQL as it will save you in terms of cost, but if it is critical, avoid SQL as it will bring you down in one day. I would rate this solution as eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
IT Manager at Drukarnia Interak sp. z o.o.
Has good stability
Pros and Cons
- "We're satisfied with the stability."
- "We pay a license fee, it could always be cheaper."
What is our primary use case?
This is the main database for our financial system. I'm the IT manager and we are customers of SQL server.
For how long have I used the solution?
We've been using this solution for many years.
What do I think about the stability of the solution?
We're satisfied with the stability.
What do I think about the scalability of the solution?
We have around 100 users. The database isn't used directly, so users are not even aware that there is a SQL Server underneath.
How are customer service and support?
There are some local companies that have direct relations with Microsoft. We use them regularly when we need some support.
How was the initial setup?
I don't recall, it's been many years since we implemented this product.
What's my experience with pricing, setup cost, and licensing?
We pay a license fee, it could always be cheaper.
What other advice do I have?
I recommend this solution and rate it 10 out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
ESM Specialist at LetsCloudIT
Synchronization of nodes is very useful and there is no downtime for maintenance needs
Pros and Cons
- "It's great that the nodes are synchronized so if you lose one it automatically moves to another."
- "Could have additional security."
What is our primary use case?
We use this solution to store our data and for running queries, simple select queries that enable me to create the views I need and report from those views. I'm an ESM specialist and we are customers of SQL Server.
What is most valuable?
I like the stability of the solution, the fact that you have two, three, four nodes replicating at any given time at different locations, and they're all synchronized; if one is lost it automatically moves to another. The other advantage here is that when it comes to application maintenance, you switch onto another node while you maintain another server and there's no downtime.
What needs improvement?
The solution could have additional security.
What do I think about the scalability of the solution?
The solution is easily scalable because of its flexibility.
How was the initial setup?
I don't do the installation, but it appears straightforward according to those who carried out the implementation. These days deployment takes about an hour. We have 1,200 or so users. With the onboarding of more customers, we'll be increasing our use of SQL Server. For now, we have one person dealing with maintenance.
What other advice do I have?
I rate this solution nine out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Chief Information Officer at SYNOVA CONSULTANCT
High performance, setup straightforward, but priced high
Pros and Cons
- "The most valuable feature of SQL Server is the performance."
What is our primary use case?
We use SQL Server for developing systems.
What is most valuable?
The most valuable feature of SQL Server is the performance.
For how long have I used the solution?
I have been using SQL Server for years.
What do I think about the scalability of the solution?
We have approximately three people who are using this solution.
How are customer service and support?
The technical support from Microsoft has been good.
How was the initial setup?
The initial setup of SQL Server is straightforward.
What about the implementation team?
We have two administrators that did the implementation of the solution.
What's my experience with pricing, setup cost, and licensing?
The price of SQL Server could be reduced, the license is expensive. We have an annual subscription.
What other advice do I have?
I would recommend SQL Server to others.
I rate SQL Server a seven out of ten.
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.

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 ToolsPopular Comparisons
Teradata
MySQL
Oracle Database
SAP HANA
MariaDB
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
Citus Data
Oracle Database In-Memory
IBM Informix
YugabyteDB
SAP IQ
SAP Adaptive Server Enterprise
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Microsoft sql2017 VS SAP Hana
- SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
- SQL Server 2012 - can I make OLTP transactions from my ERP run in memory?
- How does NuoDB compare to MySQL and SQL Server?
- What are the main architectural differences between Microsoft SQL Server and Oracle Multitenant?
- Would you say the price of SQL Server is high compared to that of similar products?
- Has using SQL Server helped your organization in any way?
- Which authentication mode is best for SQL Server?
- Which solution do you prefer: Microsoft SQL Server's enterprise edition or Oracle Database's enterprise edition?
- Which is better: SQL Server or SAP HANA?