Try our new research platform with insights from 80,000+ expert users
PeerSpot user
IT Consultant & IT Project Manager Assistant with 10,001+ employees
Vendor
SSIS, SSRS, and DB help in everything.

What is most valuable?

The SSIS, SSRS, and DB are the most valuable features because they help in everything.

How has it helped my organization?

There is improvement in the performances and stability.

What needs improvement?

SSIS needs improvement.

I think that it should be easier in managing SQL packages, especially when we have multiple environments. With Kerberos Authentication, we had different issues on this and sometimes, we needed Microsoft Support too. Thus, a better and an organized SQL package review is needed.

What do I think about the stability of the solution?

When using HA (high availability), we experienced some stability issues.

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

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and support?

Technical support is the best, I would give them a 10/10 rating.

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

We were using a few other solutions such as MySQL, Oracle and Pervasive PSQL.

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

It’s okay as compared to the features that it has.

Which other solutions did I evaluate?

We evaluated the Oracle solution.

What other advice do I have?

If you want stability, then choose the best.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Al Fath Nuur Rochman - PeerSpot reviewer
Co-Founder at a logistics company with 1-10 employees
Real User
User-friendly and reasonably priced system for storing and managing information
Pros and Cons
  • "Easy to implement and user-friendly relational database management system. This product is stable and scalable."
  • "The UX design of this system needs improvement."

What is our primary use case?

We're using SQL Server for database work.

What is most valuable?

What I find most valuable in SQL Server is that it's user-friendly.

What needs improvement?

The product needs improvement in its UX design. A newer interface is what I'd like to see in the next release of SQL Server.

For how long have I used the solution?

I've been working with SQL Server for two years.

What do I think about the stability of the solution?

SQL Server is a stable system.

What do I think about the scalability of the solution?

SQL Server is a scalable system.

How are customer service and support?

I'm satisfied with the technical support provided by Microsoft for this product.

How was the initial setup?

SQL Server is easy to implement, especially because it's a very common system that we use in the workplace.

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

Pricing for this product is very reasonable.

Which other solutions did I evaluate?

I evaluated Oracle Database.

What other advice do I have?

SQL Server is a common product that I use on a daily basis, and I'm using its latest version. Most of my colleagues use it for database work.

200 people use this system in the company.

My advice for people looking into using SQL Server is that it's the best choice, especially for those who are beginners with databases.

My rating for SQL Server is nine out of ten.

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
PeerSpot user
Buyer's Guide
SQL Server
February 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,737 professionals have used our research since 2012.
IT Officer at a manufacturing company with 201-500 employees
Real User
Easy to set up with ample online documentation to resolve issues independently
Pros and Cons
  • "Stability and usability, which is quite simple, are two of the solution's most valuable features."
  • "The solution could be better when it comes to security."

What is our primary use case?

While we were still using the solution, we employed version 2008, which is a bit on the old side. 

We basically used the solution for hosting the database for Sage ERP.

What is most valuable?

Stability and usability, which is quite simple, are two of the solution's most valuable features. 

What needs improvement?

The solution could be better when it comes to security. 

The solution is part of Windows services, which means that if these should stop running, the database system, too, would be affected. This makes it very crucial to constantly monitor the SQL Server, something which reflects on cheap personnel time. 

Scalability could be better.

Although it comes with a cost, using the most recent version is highly advisable, since it would ensure a certain measure of bug fixes and stability. The sole issue would involve the cost, as this is expensive. 

When it comes to integratable features, the monitoring should be addressed. 

For how long have I used the solution?

We used SQL Server for nearly six years, although we have since moved to another platform. We have used the solution at some point within the last 12 months. 

What do I think about the stability of the solution?

The solution has good stability, although my advice is to use the most recent version towards this end, to provide for bug fixes. This will ensure some stability. 

What do I think about the scalability of the solution?

The scalability could be improved. 

How are customer service and support?

As support would have involved a licensing fee, we opted not to make use of this. 

We find there is ample documentation online to allow us to resolve issues through independent research.

How was the initial setup?

The initial setup was straightforward.

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

Although it comes with a cost, using the most recent version is highly advisable, since it would guarantee a measure of bug fixes and provide some stability. The pricing is expensive, though, this being the sole issue. 

We chose not to make use of support, as this would have incurred a licensing fee. 

What other advice do I have?

I rate SQL Server as an eight 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.
PeerSpot user
Principal JDE Business Analyst at a manufacturing company with 201-500 employees
Real User
It's working great for us with availability groups, columnstore indexes, and other features
Pros and Cons
  • "I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else."
  • "On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances."

What is our primary use case?

All of our .NET applications and some of our third-party applications require a single server database, AutoCAD, and things like that. Our custom apps are the largest estate of databases.

In our production environments, we're on version 17. I've worked with the most recent version but not in a production environment. 

What is most valuable?

I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else.

They've been adding a lot of great functionality such as columnstore indexes to improve the way indexes are rebuilt and to be able to do online index rebuilds. All those are great features.

What needs improvement?

On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances.

For how long have I used the solution?

I have been working with this solution for probably 18 years.

How was the initial setup?

Everything is pretty much scripted out, so it is pretty straightforward for us. 

What other advice do I have?

They've been adding a lot of great functionality, and hopefully, they continue down that path. We don't use a lot of the more advanced features at this point, but for what we're doing right now, it's working really great with availability groups and other features. 

Its usability has gotten a lot better after version 14. There were a lot of great updates after version 14 for SQL or query performance with the engine.

I would rate it an eight out of 10.

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
Veerender Kumar - PeerSpot reviewer
Product Owner at Software Technology
Real User
Top 20
Straightforward installation, easy database access, and scalable
Pros and Cons
  • "They have improved the UI and ease of accessing the database and server which is good. You can load it up and start using it from the very minute it is implemented."

    What is our primary use case?

    We use SQL Server to manage and store information.

    What is most valuable?

    They have improved the UI and ease of accessing the database and server which is good.
    You can load it up and start using it from the very minute it is implemented.

    For how long have I used the solution?

    I have been using SQL Server for two and a half years.

    What do I think about the stability of the solution?

    SQL Server is stable. We have more resources that are using it, I am more familiar with SQL Server. I have been using it for a long time. Most of the time it has been stable.

    What do I think about the scalability of the solution?

    The solution is scalable.

    We have approximately 30 people in my organization using this solution.

    How are customer service and support?

    The technical support is okay.

    How was the initial setup?

    The installation is straightforward.

    What about the implementation team?

    We have administrators and engineers that do support the solution.

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

    We are on a monthly subscription and the price could improve. However, the price has worked out well in some deployments. The problem is you never know what kind of services have been installed and you have to be in touch with many people, such as which servers are active or which are not. I did face a couple of issues in terms of subscriptions and the pricing model. They have improved over time.

    What other advice do I have?

    I would recommend this solution to others. My advice to others wanting to implement this solution is you have to consider the industry demand and the benefits or advantages of a solution before you choose, for example, Oracle or Microsoft.

    I rate SQL Server an eight out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Principal, Sr. IT Consultant at a consultancy with 51-200 employees
    Consultant
    It is fairly easy to work with
    Pros and Cons
    • "It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups."
    • "The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster."

    What is our primary use case?

    We set up SQL Servers for developers who develop applications for data mining. Our clients are generally small or medium-sized businesses. There's also a SQL Server Express that many software vendors use to support their applications. That gets installed often—usually as part of the application installation. 

    What is most valuable?

    It is fairly easy to work with. I like the high-availability options, like mirroring for example, and the high-availability groups. It's quite an interesting feature that enables high availability for the SQL Server. I think it's important. So that's the feature that I'm particularly interested in and it works pretty well.

    What needs improvement?

    The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster.

    For how long have I used the solution?

    "Using" is the wrong word. We mostly set it up for others. The last time we set up an SQL Server for a client was about a year ago.

    What do I think about the stability of the solution?

    We haven't had any experiences. The software hasn't been unstable or glitchy in our environment so far.

    What do I think about the scalability of the solution?

    In terms of scalability, it would be closed to a high-availability group. So I would say it varies in scale. 

    What other advice do I have?

    I would rate it nine out of 10. Nothing's perfect.

    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
    reviewer1653840 - PeerSpot reviewer
    Director -Data Architecture and Engineering
    Real User
    Beneficial for small businesses, good technical support, and reasonable priced
    Pros and Cons
    • "SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties."
    • "I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."

    What is our primary use case?

    We are using SQL Server to build and store our whole company's data in our data warehouse.

    What is most valuable?

    SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.

    For how long have I used the solution?

    I have been using SQL Server for approximately eight years.

    What do I think about the scalability of the solution?

    I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability.

    The scalability issue could be why many are moving to solutions, such as Teradata or other high-end on-premise solutions. Additionally, cloud solutions offer better scalability options.

    How are customer service and technical support?

    The technical support from Microsoft is very good.

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

    If you are looking for a small setup and do not want an open-source solution or invest too much money in your database then SQL Server is a very good choice.

    Which other solutions did I evaluate?

    I have evaluated other solutions, such as Teradata.

    What other advice do I have?

    I rate SQL Server an eight 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.
    PeerSpot user
    reviewer1642500 - PeerSpot reviewer
    Engineer at a manufacturing company with 10,001+ employees
    Real User
    Leaderboard
    The stability needs improvement but it is easy to scale
    Pros and Cons
    • "Similar to Microsoft SQL, it is easy to scale."
    • "It could be more stable."

    What is our primary use case?

    We use this solution as our database.

    What needs improvement?

    It could be more stable.

    For how long have I used the solution?

    I have been using SQL Server for four or five years.

    What do I think about the stability of the solution?

    SQL Server is a stable solution, but it could be improved.

    What do I think about the scalability of the solution?

    Similar to Microsoft SQL, it is easy to scale.

    We have a team of 300 people who are using this solution.

    How are customer service and technical support?

    I have not contacted technical support.

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

    Previously, I used MySQL.

    How was the initial setup?

    I was not involved in the installation.

    We have an IT team to complete the installation.

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

    There is no licensing cost for SQL Server.

    What other advice do I have?

    I am a user of this solution but I don't know that I understand it well enough to recommend it to others because I did not install it.

    I would rate SQL Server a five out of ten.

    Which deployment model are you using for this solution?

    Public Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
    Updated: February 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.