Try our new research platform with insights from 80,000+ expert users
reviewer1362969 - PeerSpot reviewer
IT Specialist at a government with 1,001-5,000 employees
Real User
A relational database management system that's relatively stable
Pros and Cons
  • "I like that it's relatively stable."
  • "It would be better if it had more integration with other systems."

What is our primary use case?

We use SQL Server for collecting and storing our data.

What is most valuable?

I like that it's relatively stable.

What needs improvement?

It would be better if it had more integration with other systems.

For how long have I used the solution?

I have been using SQL Server for over 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.
830,596 professionals have used our research since 2012.

What do I think about the stability of the solution?

I think it's scalable.

What do I think about the scalability of the solution?

It's relatively stable.

How are customer service and support?

Technical support is good. When I have a problem, they're responsive.

How was the initial setup?

I've tried to do the initial setup, and I don't think it's that easy. But I think the configuration is normal.

What about the implementation team?

I set up and deployed this solution myself.

What other advice do I have?

I would recommend this product to new users.

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

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
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
    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.
    830,596 professionals have used our research since 2012.
    reviewer1288086 - PeerSpot reviewer
    Project manager at a tech services company with 11-50 employees
    Real User
    A good choice in terms of price and quality, good speed, and good user interface
    Pros and Cons
    • "Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better."
    • "There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."

    What is most valuable?

    Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.

    What needs improvement?

    There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented.

    Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version.

    For how long have I used the solution?

    I have been using this solution for more than 15 years. Our clients are using its multiple versions, starting from SQL Server 2012.

    What do I think about the stability of the solution?

    It is stable.

    What do I think about the scalability of the solution?

    In general, it is scalable, but we are only using the single-server mode. We are not using any kind of clustering. Therefore, I cannot say anything from my personal experience about the scalability of Microsoft SQL Server.

    How are customer service and technical support?

    I do not have any experience with Microsoft support. We either use in-house knowledge professionals or third-parties for consulting services.

    How was the initial setup?

    Its initial setup is quite straightforward. A major upgrade is a bit more complicated. We had some issues with the upgrade.

    What other advice do I have?

    I would recommend this solution. It is a good choice in terms of price and quality.

    I would rate Microsoft 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
    PeerSpot user
    Management Trainee for Training at a tech services company with 11-50 employees
    Consultant
    It solved really complex situations

    What is most valuable?

    • Net integration is best for me
    • Better optimizer
    • Ease of use (admin tools)

    How has it helped my organization?

    We used this to solve many complex problems.

    What needs improvement?

    Overall, trying to make over with Oracle, it can be improved in usage for high data migration companies of large scale.

    For how long have I used the solution?

    I have experience using both the versions of SQL Server 2008, 2012 for more than two years.

    What do I think about the stability of the solution?

    Never had issues with stability, may be we were handling structured data well.

    What do I think about the scalability of the solution?

    No, federal vs clusters approach explains you well that you can search for them.

    How is customer service and technical support?

    Technical support rating would be around a seven and a half out of 10.

    How was the initial setup?

    Setup is easy as what we want the database to do for our problems, compared to Oracle latest versions you need to spend more time on the initial setting up where these cannot go wrong with partitioning and indexing and it needs to be perfect.

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

    Go for SQL and compare it with pricing and stability with other Microsoft products.

    Which other solutions did I evaluate?

    Definitely yes, with Oracle only if the needed situations cannot be met, mostly it covers better.

    What other advice do I have?

    Best practices are the always a better choice for implementing the solution, hire a good expert and consult a better person with huge experience in architecting database systems for decades.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Web Content Editor at a consumer goods company with 501-1,000 employees
    Vendor
    The most valuable feature for us is SQL Server Migration Assistant for Access.

    What is most valuable?

    SQL Server Migration Assistant for Access (AccessToSQL).

    How has it helped my organization?

    We migrated loads of access database into large scale SQL server.

    What needs improvement?

    Access validation rules and expressions need improvement while converting into SQL Server.

    For how long have I used the solution?

    I've been using it for 10 years, and was using previously older versions and now I'm on the latest one.

    What was my experience with deployment of the solution?

    We just needed to upgrade Windows.

    What do I think about the stability of the solution?

    It was average.

    What do I think about the scalability of the solution?

    It was average.

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

    I previously used Oracle 11G, I switched because of less hardware resources were needed to run heavy software.

    How was the initial setup?

    It's straightforward to do providing you've read the manual.

    What about the implementation team?

    We did it in-house.

    What was our ROI?

    It's beneficial in terms of what the business gains from it.

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

    It's average to purchase.

    Which other solutions did I evaluate?

    We also looked at Oracle 11G.

    What other advice do I have?

    First look into scalability issues before adopting the right product.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Cloud DBA at UNIT4
    Real User
    Its stability delivers performance and usability and it has good reporting services

    What is our primary use case?

    • Effectiveness in a production environment
    • New features test

    How has it helped my organization?

    Besides that, SQL Server has become very expensive like Oracle. Its stability delivers performance and usability.

    What is most valuable?

    • SSMS
    • SSIS
    • Reporting services
    • FCI clustering
    • AlwaysOn
    • Basic availability groups.

    What needs improvement?

    I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.

    For how long have I used the solution?

    Less than one year.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    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
    reviewer1561038 - PeerSpot reviewer
    Chief Technology Officer at a financial services firm with 11-50 employees
    Real User
    Stable, simple installation, but scalability could improve
    Pros and Cons
    • "The initial setup was straightforward."
    • "I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."

    What is our primary use case?

    The main use of this solution is to control and manage data storage information.

    What needs improvement?

    I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server.

    For how long have I used the solution?

    I have been using the solution for approximately two years. 

    What do I think about the stability of the solution?

    The solution is stable. 

    What do I think about the scalability of the solution?

    I find the solution not to be scalable. 

    There are approximately six people in our company using SQL Server.

    How are customer service and support?

    I have not needed to contact technical support.

    How was the initial setup?

    The initial setup was straightforward. 

    What about the implementation team?

    I did the implementation of the solution myself, it does not require any consultants or integrators.

    What other advice do I have?

    I rate SQL Server a six 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: 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.