Try our new research platform with insights from 80,000+ expert users
reviewer1524594 - PeerSpot reviewer
Senior Solutions Architect at a manufacturing company with 51-200 employees
Real User
User friendly, performs well, and backward compatibility
Pros and Cons
  • "The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."

    What is our primary use case?

    The solution is an RDBMS and can be used to simplify customers' requirements for a back-end database. The main function of the solution is to store information from front-end users.

    What is most valuable?

    The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application. Additionally, the solution is simple and if it is configured properly it performs very well. 

    For how long have I used the solution?

    I have used the solution for approximately six years.

    What do I think about the stability of the solution?

    I find the solution to be very stable. 

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

    What do I think about the scalability of the solution?

    The solution is scalable. 

    How are customer service and support?

    The technical support is only provided to the customers having a subscription-based license with a Software Assurance server. For other forms of licensing the solution will not provide support. 

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

    I have previously used other RDBMS solutions, such as Oracle MySQL, Maria DB, PostgreSQL, and IBM DB2.

    When comparing PostgreSQL, Oracle MySQL, and Microsoft SQL, Microsoft SQL has an advantage over the other two server databases because it provides a graphical user interface by default.

    How was the initial setup?

    The initial setup of the solution is very easy and the time it takes depends on the architecture required. If the deployment of a cluster is required then the setup may take up to three hours, whereas standard environment deployment needs half an hour. 

    What about the implementation team?

    The solution can be installed by our selves but the use of an integrator makes it much easier. 

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

    The solution requires authorization in either the form of perpetual licensing or subscription-based licenses for two years. If a perpetual license version is purchased then customers have it to the end of life, whereas a subscription-based called server with Software Assurance, has to be renewed every two years. 

    The areas that need improvement are with regards to the commercial aspect of the solution, the licensing cost could be reduced in order to help customers to adopt it.

    What other advice do I have?

    I would recommend this solution. However, the customer has to make sure it fits their use case.

    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.
    PeerSpot user
    Managing Partner at Bizz Advisers SRL
    Real User
    Stores and retrieves data requested by other applications
    Pros and Cons
    • "I haven't really experienced any issues that required the assistance of technical support."
    • "The ability to connect with other environments needs to be improved."

    What is our primary use case?

    We use this solution to manage our database and store information. I use another platform for more specific needs.

    Within our organization, there are roughly 10-12 employees using this solution. 

    What needs improvement?

    SQL Server consumes a lot of resources. You need to keep an eye on the number of resources involved. It expands and uses all of the memory available on the server. For this reason, I install it on separate machines.

    Also, the ability to connect with other environments needs to be improved. 

    For how long have I used the solution?

    I have been using SQL Server for nearly 10 years.

    What do I think about the scalability of the solution?

    Scalability-wise, it's okay.

    How are customer service and technical support?

    I haven't really experienced any issues that required the assistance of technical support. 

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

    I also use MySQL — the open-source version. I started using SQL Server because we required some special functionality for a specific project. 

    How was the initial setup?

    The initial setup was not complicated. You can do it without any external support. 

    What about the implementation team?

    I installed the entire solution myself within 20-50 minutes.

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

    The price could always be lower. 

    Which other solutions did I evaluate?

    I evaluated Oracle, but I didn't like it — I prefer Microsoft. 

    What other advice do I have?

    I would absolutely recommend this solution to others. Overall, on a scale from one to ten, I would give this solution a rating of eight. 

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Buyer's Guide
    SQL Server
    August 2025
    Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
    866,778 professionals have used our research since 2012.
    System Administrator at ARTIc
    Real User
    Easy query creation, scalable, and reliable
    Pros and Cons
    • "We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables."
    • "If you are a new user then this solution could be difficult, they could improve by making the overall usage easier."

    What is our primary use case?

    We are using SQL Server for the backend of our SAP and are planning on moving to a cloud version soon.

    How has it helped my organization?

    This solution has helped our organization by providing a backbone for our SAP. We would not be able to operate without it.

    What is most valuable?

    We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.

    What needs improvement?

    We are using an older version of SQL Server and the migration to a newer version could be made easier.

    If you are a new user then this solution could be difficult, they could improve by making the overall usage easier.

    In an upcoming release, they could improve the ability to customize the solution.

    For how long have I used the solution?

    I have been using SQL Server for approximately ten years.

    What do I think about the stability of the solution?

    We have not experienced any problems with the stability of this solution.

    What do I think about the scalability of the solution?

    SQL Server is scalable.

    How are customer service and technical support?

    We have not used the support from Microsoft. However, we did have freelance support a few times.

    How was the initial setup?

    The installation is very easy. We did not have any challenges.

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

    The price of the solution is very expensive. If I went with the cloud version of SQL a license would cost me approximately 11,000 Riyals per month.

    Which other solutions did I evaluate?

    We have a team that has evaluated other solutions before we chose SQL Server, such as Oracle.

    What other advice do I have?

    I would recommend this solution. However, Oracle has a good reputation for quality that might be a better choice.

    I 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
    PeerSpot user
    Solution Architect at KIAN company
    Real User
    Highly scalable, easy to use, but better performance and monitoring needed
    Pros and Cons
    • "The solution is very easy to use."
    • "SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."

    What is our primary use case?

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

    What is most valuable?

    The solution is very easy to use.

    What needs improvement?

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

    For how long have I used the solution?

    I have been using this solution for approximately three years.

    What do I think about the stability of the solution?

    I have found the SQL Server stable.

    What do I think about the scalability of the solution?

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

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

    How are customer service and technical support?

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

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

    I have used MySQL.

    How was the initial setup?

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

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

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

    What other advice do I have?

    I would recommend this solution to others.

    I rate SQL Server a seven out of ten.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    AhmedElbadry - PeerSpot reviewer
    NMS Service Automation & RPA Technical Lead at Vodafone
    Real User
    Top 10
    Scalable with a straightforward setup and good stability
    Pros and Cons
    • "From a security perspective, we have no complaints."
    • "It would be ideal if the solution offered better integration capabilities."

    What is our primary use case?

    The solution is a part of a product. We use it for our database, among other items.

    What is most valuable?

    The solution is very stable.

    The product scales well.

    From a security perspective, we have no complaints. 

    The initial setup is very straightforward. 

    What needs improvement?

    The solution should work to improve its search functionality.

    It would be ideal if the solution offered better integration capabilities. In the future, we expect that our company will need to make more integrations with other systems.

    For how long have I used the solution?

    I've been using the solution for three years. It hasn't been that long.

    What do I think about the stability of the solution?

    So far, the stability has been very good. We haven't experienced any crashed or anything of that nature. There are no bugs or glitches. It's reliable and the performance is good.

    What do I think about the scalability of the solution?

    The solution is very scalable. The only thing that would limit its ability to expand is how your environment is designed. That said, a company should have no trouble scaling it if they would like to.

    There are only five of us using the solution right now.

    We do plan to increase usage in the future.

    How are customer service and technical support?

    While I haven't had a chance to open a ticket with technical support, I plan to open one next week, as I have an issue I need to ask them about. However, since I have yet to be in contact, I cannot evaluate their level of service.

    How was the initial setup?

    The initial setup is not complex or difficult. It's easy. It's very straightforward and the setup guide is available if you Google it. Anyone can search for the installation guide on whichever version you're installing.

    The deployment is quick. It only takes about 30 minutes or so.

    We have a technical team of five engineers. If any maintenance is needed, we can handle it. 

    What about the implementation team?

    I installed the product myself. I found an installation guide and just followed the directions. I didn't need the help of a consultant or integrator.

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

    We do not currently pay a licensing fee in order to use this product.

    What other advice do I have?

    I'm currently using the 2017 version. I am not using the latest version of the solution.

    In general, I would rate it at an eight out of ten. For the most part, we have been satisfied with its capabilities.

    I'd recommend the solution to other users and organizations.

    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
    Dimitris Iracleous - PeerSpot reviewer
    Lead Technical Instructor at Code.Hub
    Real User
    Top 5Leaderboard
    A user-friendly, reliable solution for organizing data from subscribers and customers
    Pros and Cons
    • "The solution is user-friendly, is a robust tool and is always reliable to users."
    • "The interface integration could be better."

    What is our primary use case?

    We are a company that possesses data relating to the banking and telecommunications sectors. We use the solution to organize all data received from subscribers and customers. 

    What is most valuable?

    I feel that this is the simplest of solutions. It is user-friendly, is a robust tool and is always reliable to users. The solution is within the Windows environment. This means that all users, who are already accustomed to Windows, will naturally prefer to use this environment over that of Linux or another operating system. 

    What needs improvement?

    I would like to have a more directed modeling, to have the flexibility to design all databases using a graphic interface. In other words, the interface integration could be better. 

    To avoid the need to write code, many users like to use the database diagrams as an overall tool and, as such, the solution should be more flexible and user-friendly. 

    For how long have I used the solution?

    I have been actively using SQL Server for up to 10 years. I started with programming, moved to databases and am now concentrating on Power BI.

    What do I think about the scalability of the solution?

    The solution is quite scalable, as it can be extended to replicate many computers. It can be used in a virtual environment. One would, of course, make use of the cloud. We are now gaining experience in cloud programs such as Azure and AWS.

    How are customer service and technical support?

    There are two teams which provide technical support. The same team provides support for all these tasks. 

    How was the initial setup?

    The initial setup is not without certain problems. Many users prefer to use Docker in lieu of the original selection. This is more convenient for them owing to certain configurations it possesses. However, if one is incapable of doing this initially he will find it difficult to do at a later date. An example would involve the inclusion of TCP/IP support, which is quite cumbersome. While it is not very difficult, it does require a certain amount of expertise. 

    We have prepared many virtual machines. Each month we prepare these systems so that they may be ready to meet our needs. This task consumes three to four days per month. 

    What about the implementation team?

    We have a support team who helps our users with deployment. They provide these services to our customers.

    When it comes to deployment and maintenance, there are four people responsible for providing the administrative support to us and to our customers.

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

    Our customers do pay license fees for the MS SQL Server but the Rabbit is free, as it is open-source software.

    Some who pay for these prefer in-house, on-premises support, while others take a cloud-based approach. 

    What other advice do I have?

    I am also a consultant to SQL Server.

    I usually consult with databases, including the Power BI. I started with data business and now shifted to this.

    I strongly recommend the solution because we are doing consulting projects using Java applications.

    I rate SQL Server as a nine 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
    PeerSpot user
    Ali Yazıcı - PeerSpot reviewer
    IT Service Manager at Kuveyt Turk Participation Bank
    Real User
    Easy to set up, very stable, and quite scalable
    Pros and Cons
    • "The solution has proven to be very stable."
    • "The solution could offer more integration with other platforms."

    What is our primary use case?

    We primarily use the solution for our banking database.

    What is most valuable?

    Overall, it's a very good device.

    The solution has proven to be very stable.

    The scalability potential is very high.

    The initial setup is very straightforward and the deployment happens very quickly.

    What needs improvement?

    The solution could offer more integration with other platforms.

    For how long have I used the solution?

    I've been using the solution for about ten years or so. It's been about a decade. It's been a while. 

    What do I think about the stability of the solution?

    The product is very stable, from my experience. It doesn't crash or freeze. There are no bugs or glitches. I've used it for ten years with very few issues. The performance and reliability are very good.

    What do I think about the scalability of the solution?

    The solution can scale quite well. If your company needs to expand it, it can do so pretty easily. It's not hard.

    We currently have 5,000 users on the solution.

    We do plan to increase usage in the future.

    How are customer service and technical support?

    We've dealt with Microsoft technical support in the past and we were very satisfied with the level of service provided to us. They are knowledgeable and responsive. 

    How was the initial setup?

    The initial setup is straightforward. I wouldn't describe it as difficult or complex. It's actually very simple. A company shouldn't have too much trouble with the implementation.

    The deployment was fast and barely took two days.

    We have five people on staff who can handle the deployment and maintenance for us. They are administrators and engineers.

    What about the implementation team?

    We had a consultant that assisted us with the implementation. They were very helpful and made the implementation very simple.

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

    We pay a yearly license to Microsoft. I can't speak of the exact cost, however.

    What other advice do I have?

    We're likely using the latest version of the solution.

    I'd rate the product at a nine out of ten. We have been very satisfied with its capabilities over the last decade.

    I'd recommend the solution to other users and companies.

    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
    Irad Dukad - PeerSpot reviewer
    IT Manager at Ducart
    Real User
    Top 10
    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?

    The solution can be used for a host of applications.

    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. 

    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.
    PeerSpot user
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
    Updated: August 2025
    Product Categories
    Relational Databases Tools
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.