Try our new research platform with insights from 80,000+ expert users
reviewer977976 - PeerSpot reviewer
System Architect, SCRUM Product Owner at a tech company with 10,001+ employees
Real User
Easy to use, scalable, and reliable
Pros and Cons
  • "I have found SQL Server easy to use."
  • "SQL Server could improve by having better usability or user guidance."

What is our primary use case?

SQL Server is used for storing data.

What is most valuable?

I have found SQL Server easy to use.

What needs improvement?

SQL Server could improve by having better usability or user guidance.

For how long have I used the solution?

I have been using SQL Server for approximately five years.

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

What do I think about the stability of the solution?

The solution is stable and the performance is good.

What do I think about the scalability of the solution?

SQL Server is scalable.

How are customer service and support?

I have not needed to contact support.

How was the initial setup?

The implementation was done by our IT department.

What about the implementation team?

We did the implementation in-house.

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

The price of the solution is fine.

What other advice do I have?

I would recommend this solution to others.

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
reviewer938061 - PeerSpot reviewer
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
Real User
Easy-to-use interface for building queries
Pros and Cons
  • "The interface for building the queries or writing the store procedures is good."
  • "Additional interfaces would be an improvement."

What is our primary use case?

SQL Server is the database for the transactional database that is being used.

The solution can be used for the BI, the data warehouse part as well, but mostly I have seen it used for the transaction data being stored by the DBMS part of it.

What is most valuable?

The solution is very easy to use, because even the technical engineers that we get are able to use it more efficiently. I like the programming interface they have where they help us get the table names that we are dealing with, and the field names in that particular table. 

The interface for building the queries or writing the store procedures is good.

What needs improvement?

If I compare the solution with current technology needs, like NoSQL, that have been prevailing now, they could improve it so there could be a single solution, where we could deal with a single database for both transactional as well as for the in-memory needs that we have.

For the integration part, additional interfaces would be an improvement. If SQL Server could expose certain APIs or certain interfaces which can be used for integration with the warehouse solution, then it would be great.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable.

How was the initial setup?

The team needed for implementing the solution depends on the project size and functionalities needed. But as far as the DB administrator, generally, we use a single resource for each project. One database engineer is sufficient for optimizing the query or indexes or building any database scripts.

What other advice do I have?

I would rate the solution 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
Buyer's Guide
SQL Server
December 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
831,369 professionals have used our research since 2012.
PeerSpot user
CTO at a tech services company with 11-50 employees
Real User
Reliable and easy to use with good technical support
Pros and Cons
  • "The solution is very common. It's easy to use."
  • "The solution is expensive. The licensing costs are high."

What is our primary use case?

The solution is primarily used as a relational database. It's a great option for anyone who needs to still use a database.

What is most valuable?

The solution is very common. It's easy to use.

The product offers a lot of support. Technical support has been great.

It's a reliable solution currently in this space.

The solution doesn't take a long time to set up. It's pretty straightforward. 

What needs improvement?

The solution is expensive. The licensing costs are high. 

For how long have I used the solution?

I've been dealing with the solution for 20 years or so. It's been two decades. I've used it for a while. 

What do I think about the stability of the solution?

The stability is pretty good. I find it to be reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is good.

What do I think about the scalability of the solution?

We have 150 users on the solution currently.

How are customer service and technical support?

I've contacted Microsoft technical support in the past and have been satisfied with the level of service I get. They're good.

How was the initial setup?

We have a special database team that is running. Except for the initial installation of the hardware, they are doing everything as it's an in-house solution.

It took a day or two to implement. It might have even taken less time. 

What about the implementation team?

We have a team that can manage the implementation process. 

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

The licensing is a bit expensive. We'd like them to be more flexible in terms of costs.

We pay a yearly licensing fee.

Which other solutions did I evaluate?

We did not evaluate other solutions before implementing this solution. 

What other advice do I have?

I'm using either the 2018 or 2019 version of the solution. I don' know the exact number off-hand.

I'd rate the solution at an eight out of ten. It's a very good solution and I've been pretty happy with its capabilities. 

I would recommend the solution to other users.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user718458 - PeerSpot reviewer
    Corporate Data and BI Lead - Database Administrator at a logistics company with 10,001+ employees
    Real User
    Provides An Easy Way To Monitor And Troubleshoot Problems

    What is most valuable?

    Most of SQL Server High Availability and Disaster Recovery solutions. They are easy to configure and maintain.

    How has it helped my organization?

    It provides the best performance and an easy way to monitor and troubleshoot problems.

    What needs improvement?

    Indexing, execution plans, and the SQL Server Management Studio performance.

    For how long have I used the solution?

    Over seven years.

    What do I think about the stability of the solution?

    No.

    What do I think about the scalability of the solution?

    No.

    How are customer service and technical support?

    Medium.

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

    No.

    How was the initial setup?

    Complex design, easy configuration.

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

    It is not very expensive and is suitable for an international company, like what I am working with. Free licenses are suitable for small companies, too.

    Which other solutions did I evaluate?

    No.

    What other advice do I have?

    Stable and easy to administrate.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Technical lead/Senior embedded software engineer at a wireless company with 51-200 employees
    Vendor
    I've used SQL Server​ for most of the solutions I worked for, from web crawlers to logistic platforms and medical devices

    What is most valuable?

    Database Engine

    Integration Services

    Reporting Services

    How has it helped my organization?

    I am a Senior Software Engineer. I've used SQL Server for most of the solutions that I worked with, from web crawlers to logistic platforms and medical devices.

    What needs improvement?

    • The Server Objects area of SQL Server Management Studio
    • The SQL Server Configuration Manager

    For how long have I used the solution?

    Over 10 years.

    What do I think about the stability of the solution?

    Yes, I encountered issues only when using the Express editions during the development. SQL Server, generally speaking, is stable also in high transaction environments.

    What do I think about the scalability of the solution?

    Yes, I encountered issues in the CPU intensive application, like web crawlers. It was difficult to reach the desired scalability through the fine tuning options available.

    How are customer service and technical support?

    The support is good. The knowledge base is very good.

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

    I have experience with Sybase SQL Anywhere .

    I switched mainly because the SQL Server is widely deployed and known, for better XML support, and for better integration with .NET framework and its related technologies.

    How was the initial setup?

    It was straightforward for most of the installation, thanks to the wizards.

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

    I am not a direct purchaser, so I don’t know.

    Which other solutions did I evaluate?

    SAP/Sybase SQL Anywhere for the small footprint which makes it suitable for embedded solutions.

    SAP/Sybase SQL Anywhere for the built-in synchronization technologies available.

    What other advice do I have?

    Improve the built-in database replication technologies.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Sales Engineer at a tech consulting company with 11-50 employees
    Real User
    I have found SQL Server to be fast, secure and low cost

    How has it helped my organization?

    Security, lower cost, ease of maintenance and administration, performance. When all of these are considered, our business is able to run faster, more securely, with SQL as the back-end.

    What needs improvement?

    The Management Studio front end still needs work as does Indexing.

    For how long have I used the solution?

    14 years

    What was my experience with deployment of the solution?

    No, SQL installs well.

    What do I think about the stability of the solution?

    No, SQL was stable for our applications.

    What do I think about the scalability of the solution?

    No, scaling was easy with SQL. We never had an issue.

    How are customer service and technical support?

    Customer Service: Do not expect Microsoft to be in a hurry to get to you, but I have always found their support to be helpful.Technical Support: I would rate the support as average.

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

    We also used Oracle. We supported both with our application.

    How was the initial setup?

    SQL is very easy to setup.

    What about the implementation team?

    In-house.

    Which other solutions did I evaluate?

    We also used Oracle. We supported both with our application.

    What other advice do I have?

    Make sure you have your prerequisites installed and the proper amount of resources dedicated. You should not have a problem.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user103896 - PeerSpot reviewer
    it_user103896Sales Engineer at a tech consulting company with 11-50 employees
    Real User

    Some may not agree with my findings on the security portion, but according to National Institute of Standards and Technology, SQL had the fewest number of reported vulnerabilities.

    reviewer1233759 - PeerSpot reviewer
    Deputy Manager at a computer software company with 10,001+ employees
    Real User
    Helpful support, scales to our requirements, and handles our critical applications
    Pros and Cons
    • "I have contacted technical support, and overall my experience with technical support was okay."
    • "I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements."

    What is our primary use case?

    We are business consults. We use SQL Server to ensure that critical applications remain operational by performing BCM activities across application and database servers.

    What is most valuable?

    SQL Server has scaled as per our requirements.

    What needs improvement?

    I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements.

    For how long have I used the solution?

    From a restoration perspective, I have been working with SQL Server for a few years.

    What do I think about the stability of the solution?

    The stability of the SQL Server needs improvements.

    What do I think about the scalability of the solution?

    We have over 2,000 users in our organization.

    How are customer service and support?

    I have contacted technical support, and overall my experience with technical support was okay.

    How was the initial setup?

    The installation took a few days to complete.

    We have a team of three or four admins to maintain this solution.

    What about the implementation team?

    We had assistance from an integrator.

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

    Licensing fees are paid on a yearly basis.

    Which other solutions did I evaluate?

    We were evaluating other solutions for a specific requirement in our organization. The requirement is now complete.

    What other advice do I have?

    I would recommend this solution to others who are interested in using it.

    I would 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
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
    Updated: December 2024
    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.