Try our new research platform with insights from 80,000+ expert users
Marketo Consultant at Webtech software servies
Real User
Easy to query, straightforward for beginners, and extensive online support community
Pros and Cons
  • "The most valuable features of this solution are easy queries and straightforward programming for beginners."
  • "SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."

What is our primary use case?

We use SQL Server for web application and website development.

What is most valuable?

The most valuable features of this solution are easy queries and straightforward programming for beginners.

What needs improvement?

SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server.

For how long have I used the solution?

I have been using this solution within the past 12 months.

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

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 scalability is good for simple applications. However, the problem with scalability is if the application is too large, it cannot handle it. We have to depend on other database servers. 

How are customer service and support?

I have not used technical support but I have used the open forums online that provide all the information that we have needed. There is a large online community for support. 

How was the initial setup?

The installation is straightforward.

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

There is a license required for this solution and we pay monthly. The price is reasonable compared to other solutions.

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?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1503438 - PeerSpot reviewer
Specialist Systems Engineer at a tech services company with 51-200 employees
Real User
Easy to install and helps us to keep customer data safe
Pros and Cons
  • "I use the menu on the management view credit section to get information from the database."

    What is our primary use case?

    We use SQL Server for database integration as we sometimes use queries to take information from the database. For example, if I need a couple of information that is archived or not indexed, I will inform the SQL Server team to help.

    What is most valuable?

    I use the menu on the management view credit section to get information from the database.

    For how long have I used the solution?

    I have been using SQL Server for eight to ten years, but I still check Google for things that aren't clear to me. For service delivery, we use on-premises solutions for our customers.

    What do I think about the scalability of the solution?

    We don't use SQL Server as our primary product. Our focus is on safe customer SQL admin as we don't want problems with customer data in our system.

    How are customer service and technical support?

    I think we consulted once for support in the active directory. We requested the support of Integration Engineers for installation, and their service was very good. However, in the last eight years, we have also used Microsoft support with satisfaction.

    How was the initial setup?

    For the initial installation process, I did an installation for database testing using SQL Server Express. Sometimes, the trials for the samplers are not allowing the SQL Server Express. So, when I was doing the installation, I just selected database management because it isn't the default and it has helped me not to fill out the same details for future use.

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

    I cannot answer that question concerning pricing and licensing because I'm just a technical staff member. However, we are just a customer of Microsoft and some of our clients say SQL Server is very high in price.

    What other advice do I have?

    SQL Server is a very good product and we use Microsoft SQL Server software that runs on Windows as most of our clients make use of the Windows operating system. But I don't have a hundred percent trust in Microsoft products. Why am I saying that? This is not a security issue. I am just... We are hitting this kind of issue because, as you know, Windows servers sometimes get corrupted or we need to restart them.

    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
    SQL Server
    November 2024
    Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
    824,106 professionals have used our research since 2012.
    Engineer / MS SQL DBA at Solvinity
    User
    This solution has proven stability and operational power
    Pros and Cons
    • "This solution has proven stability and operational power."
    • "Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."

    What is our primary use case?

    The database is primarily used as back-end storage.

    How has it helped my organization?

    As an engineer working for multiple organisations, MS SQL has proven stability and operational power.

    What is most valuable?

    The additional tools, like SSIS and reporting services, make this solution useful.

    What needs improvement?

    Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.

    For how long have I used the solution?

    More than five years.

    What other advice do I have?

    MS SQL is constantly improving their products. New options, such as managing with PowerShell, are good improvements.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Brazil IT Coordinator at a transportation company with 1,001-5,000 employees
    Real User
    You can share the results of an integration without having to share the file. The performance could be better.

    What is most valuable?

    The most valuable feature is the easy installation. The user just needs to know how to read.

    How has it helped my organization?

    The SQL Server is helping us with the most feared corporate problem: Excel spreadsheets. The individual user can perform an integration and share the same results with others without the necessity to "share" the file. This reduces the data traffic on my company network.

    What needs improvement?

    Table partition and memory management. The performance could be better.

    For how long have I used the solution?

    I have used it for more than 10 years.

    What do I think about the stability of the solution?

    The SQL Server has a big issue when some systems use Java as a primary software interface. This database loses the ability to manage memory, consequently locking the processes and losing performance in the execution of some robust queries.

    What do I think about the scalability of the solution?

    Unfortunately, this database doesn't have a good concept of partition table. If you need to create monthly (Jan. to Dec.) partitions in one table, this action creates 12 different files for the same table. In others databases, this process is more transparent and capable to create partitions inside the same database.

    How are customer service and technical support?

    The technical support team for the SQL Server is very friendly, if we compare with others commercial database products. Not only with Microsoft, but this database has more technical information published on the internet, books, and self-taught users to help.

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

    I am still using other commercial solutions, but the price of this database is much less expensive than others. It is about four times less expensive.

    How was the initial setup?

    The initial setup is one of the good things about MS SQL. It is very easy to do and start the development that you need to use after the installation.

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

    In my point of view, the MS SQL is the most inexpensive database commercial solution. If do you need to build a consistent ERP for example, with a medium to hard capability, and don't have much budget to spend it, this is your solution.

    Which other solutions did I evaluate?

    Of course, I evaluated other options! I never choose the first option and I always try to look around to find competitive vendor options. I already know and have expertise with IBM/DB2 and Oracle solutions. For this new architecture, MS SQL was the best option at the moment for being a pilot project.

    What other advice do I have?

    I suggest that you are first familiar with the bundle functions and plan some of the functions before starting the project. Find more information about the routines and how easy or hard it might be to start the development when you are thinking about cascade and constraints.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    SAP NetWeaver Implementer at a tech services company
    Consultant
    With it, we've been able to tune individual queries by optimizing the database server, but the speed is inconsistent.

    Valuable Features

    It allows for performance tuning to maximize performance. With the enhancements to the tuning wizard indexes are added to the needs of the system structure and use. I find this helps prevent locking of the system.

    Improvements to My Organization

    It cuts down on the variable speed of queries, and individual queries can be tuned by optimizing the database server.

    Room for Improvement

    The speed is inconsistent.

    Deployment Issues

    N/A

    Stability Issues

    N/A

    Scalability Issues

    N/A

    Customer Service and Technical Support

    Customer Service:

    N/A

    Technical Support:

    N/A

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    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.

    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
    CEO at netison
    Real User
    Simple to use and in demand among our customers
    Pros and Cons
    • "SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."

      What is our primary use case?

      We manage backups for our customers, so we are not developers and we don't use SQL to provide a service. We are a managed service provider focused more on IT support and SQL configuration. So we don't use SQL as a product by ourselves. Instead, we provide instructions for how to back up SQL and do maintenance on it for our customers who need a SQL server for their CRM and ERP products. Their products need to have a SQL server to use in order to use their services. So we handle the maintenance for our customers.

      What is most valuable?

      Microsoft has a very broad landscape of products that they provide—almost everything that you need. SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer. And even if you don't like Microsoft, you should know how to use it because just about every customer uses Microsoft, so you have to use it. So it doesn't matter if I like it. It's everywhere, so you have to know how to use it.

      For how long have I used the solution?

      I've been using Microsoft SQL Server for 25 years now.

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

      We are a reseller of Microsoft. We also signed the SPLA agreement, which stands for Services Provider License Agreement. So we are able to use Microsoft products in our data center in order to provide cloud services to our customers.

      What other advice do I have?

      I rate SQL Server nine out of 10.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      PeerSpot user
      Pre-Sales/System Architect at a tech services company with 5,001-10,000 employees
      MSP
      Top 10
      Provides many ways to help us organize data and process information.

      What is most valuable?

      The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.

      How has it helped my organization?

      MS SQL is a recognized data tool, it provides many ways to help us organize data and process information.

      What needs improvement?

      MS SQL need to improve the big data functions and also own market share.

      For how long have I used the solution?

      since 1999

      What was my experience with deployment of the solution?

      few problems

      What do I think about the stability of the solution?

      no

      What do I think about the scalability of the solution?

      i didn't use it like admin, i don't know.

      How are customer service and technical support?

      great product

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

      Oracle, some times i used others solutions, but working by compatibility.

      How was the initial setup?

      easy.

      What was our ROI?

      never calculate.

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

      according you need

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