Usually, we use a lot of the vendor software, like ManageEngine, and stuff like that. They use Postgres, however, I prefer to use Microsoft's SQL server. We have a couple of servers and we integrate that information into it. I can run reporting and analysis off of that.
Senior Developer at a government with 51-200 employees
Easy to scale, simple to set up, and offers many great features
Pros and Cons
- "The backups are excellent."
- "I would like to see better integration between their link server and other platforms, such as IBM."
What is our primary use case?
What is most valuable?
There's a lot of great features. I like T-SQL, which is wonderful. The backups are excellent. There's a lot of things that are much easier to manage. All of the features and functions within the SQL language itself, the store procedures, I really, really enjoy. The security has been excellent.
The initial setup is very straightforward.
The stability is very good.
We find it easy to scale if we need to.
What needs improvement?
I would like to see better integration between their link server and other platforms, such as IBM, due to the fact that, a lot of times, you want to set up a linked server so you can be on SQL and pull data off of another server using that link server. Sometimes they don't play well together. There just needs to be better integration for those types of situations.
For how long have I used the solution?
I've been using the solution for about eight or nine years at this point.
Buyer's Guide
SQL Server
January 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,138 professionals have used our research since 2012.
What do I think about the stability of the solution?
The stability is great. There are no bugs or glitches. it doesn't crash or freeze. It's very reliable. The performance is great.
What do I think about the scalability of the solution?
Scaling is easy if you need to do it. You simply set up a cluster and you can just grow it up.
In our organization, all the end-users are pretty much integrated into it and using it. As far as developers, there are two developers and me that are using it.
How are customer service and support?
We haven't used tech support as we used to have a business partner that wanted us to talk to them instead. Therefore, I can't speak to how helpful or responsive they would be if you need assistance.
Which solution did I use previously and why did I switch?
Here at the company, they used Postgres, and what I didn't care about it was that it was okay, but it didn't integrate with a lot of the other applications. I felt Microsoft did a better job of that.
How was the initial setup?
The setup is pretty straightforward. The only thing that sometimes gets weird is if you have somebody that's needing an ODBC driver from another type of application back to the SQL server. It's usually that other application trying to figure out what it needs to connect to SQL. It's not really SQL's fault.
What other advice do I have?
We are customers and end-users.
We are using both the latest version and a previous version of the solution. I don't have the exact version numbers on hand.
I would advise new users first to get help implementing it unless you know the solution well, as there's so much that it can do. A lot of times you can actually make a little mistake. Say if you're going to go in a certain direction, if you get some advice, you may be much happier going in another direction completely.
In general, I would rate the solution at a nine out of ten. I've been quite satisfied with its capabilities. It's an excellent product that still has room for growth.
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.
Information Technology Manager at OrchidaSoft
Reliable, easy to maintain, easy to develop, and easy to use
Pros and Cons
- "The performance of SQL Server is perfect."
- "Security is an area that can be improved."
What is our primary use case?
We develop software for another company. We mainly develop on-premises solutions.
We use this solution with our accounting ERP software. Our product is called Orchida ERP and we have many clients in Egypt who are using this software. Its database is SQL Server.
We mainly work in ERP.
We currently have a small project in SharePoint for Microsoft, but 80% of our work is with Orchida ERP
We have our software with SQL server for 20 years. Our software will not work without SQL Server.
We provide consultancy in installing this solution for our clients.
What is most valuable?
It is easy to maintain, and it's easy to set up.
It is also easy to develop. Overall, it's easy.
It can work with many different sizes of data, anywhere from 10 to 50 gigs of data.
The performance of SQL Server is perfect. It does not need to be enhanced.
What needs improvement?
If you work with more than 50 gigs of data, it will run slower than Oracle.
Security is an area that can be improved. It could be more secure; more security is needed.
We have some clients who have been exposed to the SQL injection virus.
We would like SQL to be able to manage this problem or to come up with an alerting system to alert the user that the server has been exposed. This has become more of an issue because of the Corona Virus and people are working from home.
Some have been infected by the SQL injection Virus and will lose their data.
For how long have I used the solution?
I have been using SQL Server for 20 years.
Most of our clients work with version 14 and version 19, which is the latest.
What do I think about the stability of the solution?
It's a stable solution.
What do I think about the scalability of the solution?
SQL Server is scalable. Our clients are medium-sized companies, not large. They don't have professional IT.
We have 20 people in our organization who are using this solution, but we have many clients who are using it. We sell our consultancy service to more than 200 clients every year.
How are customer service and technical support?
If we have any issues, we search Google and the internet to resolve them.
Our company has not used Microsoft Support.
Which solution did I use previously and why did I switch?
We have tried many versions of Oracle, including Oracle 11, Oracle 12, and the latest version, which is easy to maintain and similar to Microsoft.
Some of our clients are also using Express SQL. It is not good, but also not bad. If you have small amounts of data then it will meet the requirements.
How was the initial setup?
The installation is straightforward. It is easy, you continuously click the next button until you are done.
It takes 20 to 25 minutes to install. There are no issues with the installation, it is very basic.
What about the implementation team?
We did not use an integrator, we have an in-house team to install and implement this solution.
What's my experience with pricing, setup cost, and licensing?
Some of our clients purchase the license and others do not; they use Express SQL Server.
Which other solutions did I evaluate?
One of our clients is using an SQL Server on Linux. We don't use it but it is a very interesting product. It's a good trend, the Linux environment has become a market share that is growing in Egypt.
What other advice do I have?
I would recommend this solution to others who are interested in using it.
We can't compare this solution with other databases, as we do not have enough experience with other similar tools.
Overall, SQL Server is good. I would rate SQL Server an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
SQL Server
January 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,138 professionals have used our research since 2012.
Sr. Solution Architect at Team Computers
Very fast with an easy initial setup and reasonable pricing
Pros and Cons
- "The initial setup isn't overly complex."
- "The backup capacity needs to be bigger."
What is our primary use case?
We are primarily using the solution for pulling data and analysis.
In the auto industry, are the dealer management systems for which there is kind of portals from which the dealers are maintaining information can have access to retail data, bookings, and details surrounding individual customers.
We are fetching data and using it for analytics purposes, basically.
What is most valuable?
The basic features of the solution are excellent overall.
The initial setup isn't overly complex.
The pricing is reasonable.
The solution scales well.
The solutions very fast. It reads and writes six to eight times faster than any other tool.
What needs improvement?
The solution is very different from Oracle, which is a product we also use.
Mainly the data capacity needs to be improved. The data values are limited. They are smaller or medium scale. The MySQL is working fine, however, when it comes to large data sets or large data volumes, Oracle can handle them better. The backup capacity needs to be bigger.
What do I think about the stability of the solution?
When it's medium or small-scale data volume, people are referring to MySQL, however, when the data volume grows the people are referring to Oracle. In my estimation, the stability is fine.
What do I think about the scalability of the solution?
The scalability of the product is pretty good. It can scale effectively and expands better than other options.
We have around 40 users on the solution currently.
Our main usage is not for the database and we simply use basic aspects of the platform.
How are customer service and technical support?
Technical support isn't an aspect of the solution I know too much about. I've never been in direct contact with them. Therefore, I can't speak to how helpful or responsive they are.
Which solution did I use previously and why did I switch?
We also currently use Oracle.
How was the initial setup?
The initial setup isn't too complex or difficult. It's pretty straightforward. It's less complex of a process as compared to other solutions.
What's my experience with pricing, setup cost, and licensing?
The cost isn't overly expensive. It's very reasonable. Our customers are happy with the price. It's in a good range.
What other advice do I have?
We are partners with Microsoft. We use multiple deployment models, and typically those are private cloud or on-premises options.
Overall, I would rate the solution at an eight out of ten. We've been mostly very satisfied with the capabilities of the product. It's fast. It's our preferred product.
I'd recommend the solution to other users and organizations.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Information Systems Manager at a aerospace/defense firm with 51-200 employees
A scalable and easy-to-deploy solution that secures our data, saves time, and just runs
Pros and Cons
- "The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query."
- "They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
What is our primary use case?
It is used for the backend database for our ERP system and the document management system. We are using its latest version.
How has it helped my organization?
It saves time. Our data is also a lot more secure. Prior to SQL Server, things were run in a flat-file database that required a ton more maintenance to keep it running. SQL Server is pretty much bulletproof. It just runs.
What is most valuable?
The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query.
What needs improvement?
They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs.
They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption.
They might want to consider re-evaluating their pricing. It is expensive.
For how long have I used the solution?
I have been using this solution for 12 years.
What do I think about the stability of the solution?
It is pretty much bulletproof. We never had data corruption and database failure. We've had hardware failures, but that's not the fault of the software.
What do I think about the scalability of the solution?
It is very scalable, and you don't run into indexing issues like you would with a flat file. I don't think we've even scratched the surface in terms of its capabilities. Our databases are fairly small in comparison to others in our industry who are using the same software.
We've got about 40 users using it, and primarily, they don't touch the database directly. They're just using it through ERP and our document management system. They are just non-IT employees. They are office users.
We're using it fairly extensively for the core of our business software, and we will likely increase the usage of it. We've got some projects in the hopper that will take advantage of SQL Server. So, we plan on increasing our usage of it.
How are customer service and technical support?
I didn't have the need to contact Microsoft support.
Which solution did I use previously and why did I switch?
We haven't used any other solution prior to SQL Server. It was just a flat-file.
How was the initial setup?
It was pretty straightforward. It basically walks you through the process. It took a couple of hours.
What about the implementation team?
Initially, we used a consultant to set up our ERP system, but that was 12 years ago. Since then, we've upgraded it several times, and that was done in-house. Our experience with the consultant was overall positive.
For its maintenance, we are a department of two.
What was our ROI?
We have definitely seen a return on investment when it comes to SQL Server.
What's my experience with pricing, setup cost, and licensing?
It is expensive, especially when you have open-source products that are just about as functional and they're free. They might want to consider re-evaluating their pricing.
We purchased it in retail. It was somewhere in the neighborhood of 9,000. There is just the standard licensing fee. If they migrate this product the way they're trying to do everything else, eventually, it is going to be subscription-based, which is going to suck, but that's the way the industry is going, so it is what it is.
What other advice do I have?
If you've never done it before, Microsoft has plenty of documentation and online guides to walk you through it. Just take your time, and follow the steps. If you can do it in a virtual environment, it is better because it is easier to start over if you mess it up, but it is fairly user-friendly. If you have questions during the setup, stop and Google it. The information is out there.
I would rate SQL Server an eight out of ten because there is always room for improvement.
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.
Chief Technology Officer at KOLOK SA
Many licensing options, quick installation, and scalable
Pros and Cons
- "SQL Server is a very mature solution."
What is our primary use case?
We use SQL Server for storing all our company information, such as ERP, customer applications, and our wealth management systems. All of our data is stored in SQL Servers.
What is most valuable?
SQL Server is a very mature solution.
For how long have I used the solution?
I have been using SQL Server for approximately 20 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?
The scalability of SQL Server is good. It can scale up to thousands of times more data than I have.
We have approximately 250 people using this solution in my organization.
How are customer service and support?
I have not used the support from SQL Server.
How was the initial setup?
The initial setup is simple it takes approximately 10 minutes. You only need to run the setup and you have SQL installed.
What about the implementation team?
I have installed SQL databases and SQL Servers regularly. I did the implementation of this solution.
This solution requires one administrator for implementation and maintenance.
What's my experience with pricing, setup cost, and licensing?
Some of the licensing are very expensive, such as the Enterprise license.
The Express version is free. There are a lot of licensing options.
What other advice do I have?
I would recommend this solution to others.
I rate SQL Server a nine 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.
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
Scalable and stable with good overall performance
Pros and Cons
- "The scalability of the product is great."
- "The licensing is pretty expensive."
What is our primary use case?
We primarily use the solution mainly for databases on all types of applications.
How has it helped my organization?
SQL is the all around leading Database server
What is most valuable?
The solution is very stable.
The scalability of the product is great.
What needs improvement?
We'd like the deployment process to be better in the future.
The licensing is pretty expensive.
For how long have I used the solution?
I've been using the solution for 20 years at this point. It's been two decades. We've used it for a while now.
What do I think about the stability of the solution?
The solution is stable and the performance is great. There are no bugs or glitches. It doesn't crash or freeze.
What do I think about the scalability of the solution?
The product scales well. If you need to expand it, you can do so.
We have 900 to 1,000 people using it currently.
How are customer service and technical support?
I'm more on the architecture side and therefore do not directly deal with technical support. I cannot speak to how helpful or responsive they are.
Which solution did I use previously and why did I switch?
We also use Oracle. We've used it for over a decade already.
How was the initial setup?
The deployment could be easier.
While the deployment only takes about 15 minutes, you have to follow up with a lot of configuration.
What about the implementation team?
We handled the implementation ourselves. We did not enlist the assistance of any integrators or consultants. It was all handled in-house.
What's my experience with pricing, setup cost, and licensing?
We're paying too much for licensing at this time. They need to work on the pricing. They could be cheaper, however, it's also difficult to run the licenses in the right way.
We pay licensing fees on a yearly basis.
What other advice do I have?
We're a customer and an end-user. We don't have a business relationship with SQL.
While everything is currently on-premises, we're making moves to shift to the cloud.
We're using the 2019 and 2016 versions of the product.
I'd rate the solution at an eight out of ten. In general, we've been quite happy with its capabilities.
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.
Software Engineer at OMFYS Technologies India Pvt.Ltd
Installation is straightforward, flexible-to-use and it has secure functions
Pros and Cons
- "SQL Server and their offers are very good. You can switch over, export, and do other things."
- "The free version of SQL Server is time-limited before updating to the paid version."
What is our primary use case?
I use SQL Server for .NET. We have ERP software in the background and we use the SQL Server for its creation.
What is most valuable?
SQL Server and their offers are very good. You can switch over, export, and do other things. I got access from users and it is very flexible to use.
What needs improvement?
SQL Server is technically good. For questions or other queries, we go through the internet and they explain it there. I think the structure of their product is good.
For how long have I used the solution?
I have been using SQL Server for one year and a month.
What do I think about the stability of the solution?
It's stable. It was very easy for me to handle it.
What do I think about the scalability of the solution?
The free version of SQL Server is time-limited before updating to the paid version. So, sort of more access and more work in your database to help process most of the time. It's better to purchase it for more secure functions.
How are customer service and technical support?
We have a technical support engineer who handles maintenance and security for SQL Server. I think Microsoft's technical support is also very good.
How was the initial setup?
It's a straightforward installation. I installed SQL Server 2012, 2013 and 2016.
What's my experience with pricing, setup cost, and licensing?
The usability of the free version is limited. They also have some guidelines on how to use the paid ones. You still have to check your IT requirements after purchasing it. We are using a licensed one right now, which has more functionality than the free version.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Manager Digital Technologies at a real estate/law firm with 51-200 employees
Easy to use, simple to configure, and has a straightforward setup
Pros and Cons
- "The solution has the capability to scale."
- "Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster."
How has it helped my organization?
Most of the application what we use today are SQL-based applications. If you take a Microsoft ecosystem, there are many tools that connect easily with SQL - especially when it comes to reporting and analytics. Power BI is one of the good examples which can easily connect to SQL and then you can pull any report you want. SQL itself has its own tools like reporting services and transformation services. It also helps you to generate reporting and analytics and data transformation.
Overall, it helps our organization a lot. Again, it depends on what requirements and company has, and for what purpose you are using it. However, from an application relational database point of view that we are using today, it helps due to the fact that it comes with all that we need. Also, from a performance point of view, it configures well.
What is most valuable?
When you use the solution with Azure, for example, you get very good scalability. You can scale fast, whether it is horizontal or vertical.
If we use the product as a PaaS, Platform as a Service, it comes with all the security features you need - including against DDoS attacks.
The product offers good bloc storage, which you can buy at an additional cost. This allows you to have large object storage if you need it.
Over a period of time, their split engine has evolved and in the latest version, they've done a lot. Even from the management tool perspective, a lot of things have been done. A lot of functions have been added.
The initial setup is pretty straightforward.
Technical support has been good.
The solution has the capability to scale.
The pricing isn't as high as other options.
SQL is very easy to use. That's a very good thing about it in general.
What needs improvement?
Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster. There is no active-active cluster, which other tools, other database providers like Oracle, provide. If Microsoft can consider or probably come up with an active-active cluster, then it would be good. It will be more powerful in a scenario like that.
The pricing, while not the most expensive, is still quite high.
They have something called Parallel Queries, however, I don't know how it works. I've never tested it in a horizontal way. I'd like to understand a bit more about it and be able to use it horizontally.
For how long have I used the solution?
I'm new to my organization and have only been using the product for three or four months here, however, previously, I worked with SQL for a long time.
What do I think about the scalability of the solution?
In terms of direct users, there are only a few. However, there are applications that are using SQL and those application's users are 100 plus, or maybe 300 to 400 plus users.
This company is in the phase of growth. If it grows as expected, then definitely the chances are high in terms of the number of users - which means we will scale up a bit.
How are customer service and technical support?
We have direct support from Microsoft. We have Microsoft partners as well. I don't see any problem with technical support, as we ourselves are capable of troubleshooting. I'm a certified BBS developer. If there any related issues, we take care of them internally. If not, we raise a ticket from Microsoft and we get support from them. They are helpful and responsive. We are satisfied with the level of service they provide.
How was the initial setup?
The solution is very straightforward. It's not too complex. A company shouldn't have an issue implementing it. Once you install everything and get it configured as per your requirements if you are an SQL professional and an administrator, it's very straightforward.
It's doesn't take too long to set up. Within a week you can get it deployed. If you do a standalone module, a week likely is not required. If it is in a cluster module, of course, within a week you can set up a cluster and then get things done.
What's my experience with pricing, setup cost, and licensing?
SQL pricing is slightly high compared to where it was before. That said, compared to other products like Oracle, they are still cheap. It's not overly expensive in comparison to others.
The final price you can expect all depends on your requirements. A standard version of SQL is always cheaper than an enterprise. If you're going to go on a cluster, it's particularly expensive. However, when it comes to the value and what is provided, that is also important.
It all depends on what you need. I cannot just blindly say that it's expensive or cheap as it all depends on your requirement. Comparatively, SQL is cheaper than other products like Oracle. Oracle is really expensive compared to SQL.
What other advice do I have?
We are customers and end-users.
I'm certified in SQL. I have a pretty good understanding of the product.
Overall, I would rate the solution at a nine out of ten.
Whether or not it would work well for a company all depends on what purpose it is being used for. However, SQL is simple to use and simple to configure, and very powerful in terms of relational database and the SQL language and functions it comes with. If you configure it well and then use it well, the outcome will likely be very good.
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.
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Product Categories
Relational Databases ToolsPopular Comparisons
MySQL
Teradata
Oracle Database
MariaDB
SAP HANA
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
IBM Informix
Citus Data
Oracle Database In-Memory
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?