Try our new research platform with insights from 80,000+ expert users
reviewer1566654 - PeerSpot reviewer
Database Operation Assistant Manager at a consumer goods company with 10,001+ employees
Real User
Plenty of features, flexible, but could be more scalable
Pros and Cons
  • "I have found the most valuable features to be the flexibility and the vast amount of features available."
  • "The scalability is adequate but could improve."

What is our primary use case?

I use the solution for analytics and reporting.

What is most valuable?

I have found the most valuable features to be the flexibility and the vast amount of features available.

For how long have I used the solution?

I have been using the solution for approximately three years.

What do I think about the stability of the solution?

The solution is stable.

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.
857,028 professionals have used our research since 2012.

What do I think about the scalability of the solution?

The scalability is adequate but could improve. We have approximately 100 people using the solution in our company.

How was the initial setup?

The installation is not difficult, it is quick. It took approximately 15 minutes to complete.

What about the implementation team?

We have four technicians that do the deployment and maintenance of the solution.

What other advice do I have?

I recommend this solution to others.

I rate SQL Server a seven 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
reviewer1556808 - PeerSpot reviewer
ASM at a healthcare company with 51-200 employees
Real User
A relational database management system that's easy to use, but performance could be better
Pros and Cons
  • "SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
  • "Performance could be better. But I don't know if it's a problem with my application or with my database."

What is our primary use case?

It's a database that we use for our commercial applications, and our ERP sits on it.

What is most valuable?

SQL Server is definitely easy to use, and with the volume that we have, it's also stable.  Maintenance is much easier compared to other products. I may not be comfortable with Oracle because I don't have much experience with it. But in this case, SQL Server is much better for me. 

What needs improvement?

Performance could be better. But I don't know if it's a problem with my application or with my database. Maybe it can have the capability, but I may not be using it to the extent that it could be used, or the configuration is not as per the standard.

For how long have I used the solution?

I've been using SQL Server for over ten years.

What do I think about the stability of the solution?

SQL Server is a stable solution.

How was the initial setup?

The initial setup is very easy.

What about the implementation team?

I implemented this solution by myself.

What other advice do I have?

I would recommend this solution to potential users. If they have their own in-house team, they can manage it very easily. Microsoft is always easy to manage. It's a product where no expert is required for its maintenance.

On a scale from one to ten, I would give SQL Server a seven.

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
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.
857,028 professionals have used our research since 2012.
reviewer1476273 - PeerSpot reviewer
Manager with 501-1,000 employees
Real User
Popular, works well, and easy to use and deploy
Pros and Cons
  • "It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner."
  • "It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."

What is most valuable?

It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner.

What needs improvement?

It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting.

For how long have I used the solution?

I have been using this solution for more than ten years.

What do I think about the scalability of the solution?

We have around approximately 600 or 700 users of this solution. Currently, everybody is using this solution, and we don't have a plan to increase its usage.

How are customer service and technical support?

We don't have a direct connection with Microsoft support. We have a support partner who is in contact with the official Microsoft support.

How was the initial setup?

Its initial setup is easy.

What other advice do I have?

I would recommend this solution. I would rate SQL Server 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
CEO at SkyNet
Real User
Easy to manage and configure, reliable, easy to expand, and good documentation
Pros and Cons
  • "What I like most is the management, as it is very easy compared with other products."
  • "Security is an issue."

What is our primary use case?

I am an IT professional, I write services for my clients. I provide support services for SQL, firewalls, and operating systems. IT infrastructure support in general is what I provide.

What is most valuable?

What I like most is the management, as it is very easy compared with other products.

What needs improvement?

Security is an issue. This is an area that needs to be improved.

There is security built-in, but most of the developers don't emphasize the security enough. When they are building the products or databases, they don't focus on the security of the database.

For how long have I used the solution?

I have been providing services for this solution to my clients for five or six years.

What do I think about the stability of the solution?

We have had no issues with stability. It's one of the most stable products.

What do I think about the scalability of the solution?

This solution is scalable. It is easy to expand.

How are customer service and technical support?

In the five or six years that I have been handling SQL Servers, I have not had to contact technical support. 

Their documentation is sufficient for troubleshooting and maintenance activity.

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

I am also using Sophos.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

We have our in-house team of more than 10 engineers for maintenance.

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

Pricing is a bit on the higher side. It could be reduced.

What other advice do I have?

To others who are interested in using this solution, I would say go for it. It's a stable database that is easy to configure and maintain. I would suggest this solution when compared with other databases.

I would rate SQL Server an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer1519596 - PeerSpot reviewer
Chief of Information Technology at a manufacturing company with 201-500 employees
Real User
Review about SQL Server
Pros and Cons
  • "We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use."

    What is most valuable?

    We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.

    What do I think about the stability of the solution?

    The solution has been really stable in my experience.

    What do I think about the scalability of the solution?

    We have approximately 20 to 30 users of the solution in my organization here in Colombia, Mexico.

    How was the initial setup?

    The initial setup is simple.

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

    The price of the solution could be reduced, it is expensive.

    What other advice do I have?

    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
    KopanoRamaphoi - PeerSpot reviewer
    Consultant at Rpc Data
    Real User
    Easy to set up and configure, integrates well with other components, and the support is good
    Pros and Cons
    • "The most valuable feature is that it is easy to use and you don't have to do a lot of configuration."
    • "More things in SQL Server need to be automated."

    What is our primary use case?

    We are a solution provider and this is one of the products that we implement for our clients.

    It can be used for different things such as data warehousing and online transactional processing (OLTP). This is a product that I have never used in production, however.

    What is most valuable?

    The most valuable feature is that it is easy to use and you don't have to do a lot of configuration. For example, there is no installation.

    When you want to insert data, it is easy to do. For example, if I want to test something then I log into my GitHub account, download what I want, and then upload it to the SQL server.

    The integration with other products like SQL Developer is really good. Connecting it to Visual Studio is also quite good.

    What needs improvement?

    More things in SQL Server need to be automated. We need to do a lot of things, especially on the cloud, and Oracle has better automation for handling these kinds of tasks. Automation is the key, these days.

    For how long have I used the solution?

    I have been using SQL Server for a couple of months.

    What do I think about the scalability of the solution?

    With respect to scalability, I can say that the cloud version is scalable. I don't have much to say about how an on-premises deployment scales. However, in general, both Oracle and Microsoft products scale really well.

    How are customer service and technical support?

    Technical support is responsive and quite good.

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

    I also have experience with Oracle Database. When I compared pricing between the two products, I found that Microsoft was more expensive.

    How was the initial setup?

    There is no installation. Everything is done by Microsoft and all you have to do is deploy it. The process takes less than five minutes.

    What about the implementation team?

    I have done the installation many times by myself.

    As a cloud-based product, there are no special resources required for maintenance. Once you deploy it, you just want to make sure that the data is displayed or presented in the way that you want it. Most of the technical work is handled by Microsoft.

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

    There is a charge for this product if you are using it in production. For development, there is no cost. The pricing from Microsoft is quite expensive compared to Oracle.

    What other advice do I have?

    In summary, this is a good product, I plan to continue using it, and I definitely recommend it.

    I would rate this solution an eight 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.
    PeerSpot user
    reviewer1362099 - PeerSpot reviewer
    Software Engineer at a comms service provider with 51-200 employees
    Real User
    Top 5Leaderboard
    Easy to use, with good performance but could have better pricing
    Pros and Cons
    • "The performance is good."
    • "The pricing in general could be better."

    What is our primary use case?

    The solution is primarily used for studying data and statistics. We have some services that we are monitoring and keeping records and doing reports, and we use it for that.

    What is most valuable?

    The solution is quite stable.

    The solution has the capability of scaling.

    The performance is good. 

    It's very easy to use.

    What needs improvement?

    The solution was delivered to us, and we really don't interface with the solution directly. I can't speak to any features that are missing.

    The only people that can use it directly are developers. It's not for everyday users.

    The pricing in general could be better.

    For how long have I used the solution?

    We've used the solution for about five years or so. It's been a while.

    What do I think about the stability of the solution?

    The solution is stable. It's reliable. We do not deal with bugs or glitches. It doesn't crash or freeze.

    What do I think about the scalability of the solution?

    The solution can scale, however, it's dependant on the hardware. It's not limitless.

    There are about ten users using the solution at this time.

    We do have plans to increase usage in the future.

    How are customer service and technical support?

    We don't interface with Microsoft support. We always go to the vendor that performed the integration for us.

    How was the initial setup?

    We did not implement the solution. We had it delivered to us.

    I've done an installation in the past, however, not at this company. It's straightforward. It's simple due to the fact that it's going to be installed on the Microsoft operating system, not like MySQL that's used on a Linux server.

    Deployment may take about 15 minutes or so.

    We have a technical team of about eight people that can handle maintenance as necessary.

    What about the implementation team?

    We had an integrator deliver the solution to us, as we are not ourselves developers.

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

    I don't have any details on the licensing in terms of any details or costs. It's not an aspect of the solution I directly deal with.

    What other advice do I have?

    We are just customers and end-users. We don't have any business relationship with the company.

    We use the express edition of the solution.

    It was delivered as part of a solution. We are not developers. It was a turnkey solution delivered to us by an integrator, and we are doing some maintenance, however, we are not developing the content of the database. It was used as part of our services for maybe five years or more.

    The database is on the back end. We are using it with our applications at the front end that we are interfacing with. In terms of the SQL server, we don't go and use it directly. We use it through the application. There's an application that is providing a user interface for us, and we work on that user interface. We don't work on the native interface of the SQL server.

    Overall, I would rate the solution at a seven out of ten. I've heard that Oracle is better.

    I'd recommend this solution to other 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
    Technical Director at Progetti e Soluzioni
    Real User
    Great integration with extensive documentation and a good community for support purposes
    Pros and Cons
    • "We've found it to basically be pretty problem-free."
    • "The interface could be updated to make it slightly more user-friendly."

    What is our primary use case?

    We primarily use the solution for recording transactions and information related to the reservation of a service. 

    What is most valuable?

    The product is very stable.

    It offers very good documentation. When there are some little issues, it's always very easy to go into the documentation for troubleshooting purposes. There's just so much documentation on hand and a really great community around the product that is very helpful.

    It's a very complete product.

    We've found it to basically be pretty problem-free.

    The integration with other products has always been quite good.

    The security of the product has never given us any issues.

    What needs improvement?

    We're quite satisfied with the solution. There aren't any outstanding features we would like to add.

    The interface could be updated to make it slightly more user-friendly.

    For how long have I used the solution?

    We've been using the solution for more than ten years. It's been a while. It's been more than a decade at this point.

    What do I think about the stability of the solution?

    The solution is very stable. there are no bugs or glitches. It doesn't crash or freeze. it's excellent.

    What do I think about the scalability of the solution?

    We haven't really scaled the solution all that much. At the moment, we have measured the scalability in a horizontal way. When we needed to have more installation and more capacity, we split the database into a different SQL Server instance.

    In the future, we'll likely need to consider scalability more. We are also moving in the last two years, also to a different architecture from a monolithic to a more microservice architecture. Maybe the scalability can be more easily handled in the applications that are talking to each other and leaving the database out of the equation.

    While end-users are hard to quantify, I can say that likely half a million users have come through our system for transactions.

    In the near future, we will continue to use the solution. We might use it for the next four or five years, although it is hard to say.

    How are customer service and technical support?

    We've always been able to rely on the fantastic documentation and great community around the product in order to troubleshoot problems. It's very easy to fix issues as they arise due to the public knowledge available to everyone.

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

    We've mostly always used this solution. Last quarter, we moved a little bit to a NoSQL database. We have done a little experiment on Cassandra however, previously, it has always been on SQL Server.

    We're considering moving away from the solution right now and trying something new. The owner of the company wants to experiment with other technologies and see what is out there, which is why there is talk of change. However, it's not a reflection on this product, which has been largely quite good.

    How was the initial setup?

    The initial setup is not overly difficult. It's pretty straightforward. A company shouldn't have any issues with the process.

    We have 12 technical people on our team that can handle the implementation.

    What other advice do I have?

    The last version we used is 2015 if I'm not mistaken. We don't jump immediately to the latest version due to the fact that, usually, we look for stability. We make the move to the next version in case of some integration or limitation. We prefer not to move onto something that might have bugs or glitches that need to be patched. It's more secure for us that way. 

    I'd recommend the solution to other companies.

    I'd rate the solution at a ten out of ten. It's doing exactly what we need it to do. We've very happy with it.

    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: March 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.