We just raised a $30M Series A: Read our story
Mohammed Habeeb
System Administrator at ARTIc
Real User
Easy query creation, scalable, and reliable

Pros and Cons

  • "We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables."
  • "If you are a new user then this solution could be difficult, they could improve by making the overall usage easier."

What is our primary use case?

We are using SQL Server for the backend of our SAP and are planning on moving to a cloud version soon.

How has it helped my organization?

This solution has helped our organization by providing a backbone for our SAP. We would not be able to operate without it.

What is most valuable?

We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.

What needs improvement?

We are using an older version of SQL Server and the migration to a newer version could be made easier.

If you are a new user then this solution could be difficult, they could improve by making the overall usage easier.

In an upcoming release, they could improve the ability to customize the solution.

For how long have I used the solution?

I have been using SQL Server for approximately ten years.

What do I think about the stability of the solution?

We have not experienced any problems with the stability of this solution.

What do I think about the scalability of the solution?

SQL Server is scalable.

How are customer service and technical support?

We have not used the support from Microsoft. However, we did have freelance support a few times.

How was the initial setup?

The installation is very easy. We did not have any challenges.

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

The price of the solution is very expensive. If I went with the cloud version of SQL a license would cost me approximately 11,000 Riyals per month.

Which other solutions did I evaluate?

We have a team that has evaluated other solutions before we chose SQL Server, such as Oracle.

What other advice do I have?

I would recommend this solution. However, Oracle has a good reputation for quality that might be a better choice.

I rate SQL Server 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
Flag as inappropriate
ST
Director at a tech services company with 10,001+ employees
Real User
Top 5
Stable and able to process a lot of data, but it is expensive and integration needs improvement

Pros and Cons

  • "Stability is one of the most valuable features."
  • "Indexing, as well as integration, are areas of this product that need improvement."

What is our primary use case?

We use SQL Server to process a lot of data. We are using versions and 2015 and 2018.

What is most valuable?

We like the whole product and we use most of the features.

What needs improvement?

Indexing, as well as integration, are areas of this product that need improvement.

For how long have I used the solution?

We have been using SQL Server for approximately five years.

What do I think about the stability of the solution?

It's a stable solution. Stability is one of the most valuable features.

What do I think about the scalability of the solution?

It's somewhat scalable.

How are customer service and technical support?

We don't have any issues with technical support.

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

We have used SQL Server from day one, along with OpenSQL. We used them both regularly.

We don't use Oracle often but we do have a few areas where it is used.

How was the initial setup?

The initial setup was straightforward. 

We have experience and did find it to be challenging.

We do multiple deployments which require three or four teams.

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

The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions.

Which other solutions did I evaluate?

We have evaluated MongoDB and are in the process of transforming ourselves.

What other advice do I have?

We will continue using SQL Server for some things but not everything. Most of our applications will be migrated to MongoDB and others.

I am not in the position to recommend SQL Server to anybody. Rather, I am more in the area of quality assurance. 

I would rate this solution a seven 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.
Flag as inappropriate
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
554,148 professionals have used our research since 2012.
RogerMorera
Digital Transformation Architect at Comdata
Real User
Top 5Leaderboard
Very stable, user-friendly, easy to troubleshoot, and easy to manage databases

Pros and Cons

  • "It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
  • "The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient. It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages."

What is our primary use case?

We developed a product that is using five or six databases supported on SQL Server. 

What is most valuable?

It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.

What needs improvement?

The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient.

It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages.

For how long have I used the solution?

I have been using this solution for ten years.

What do I think about the stability of the solution?

It is very stable. I would rate it an eight out of ten in terms of stability.

What do I think about the scalability of the solution?

It is scalable. You can get scalability by using the link servers, or you can create another instance in another server and make a link with that server. It is very quick.

We have around 50 users of this solution.

How are customer service and technical support?

I have not interacted with them.

How was the initial setup?

Its initial setup is easy. It takes a week. One of the things that you need to pay attention to is the collection.

What other advice do I have?

It is a nice product. You can use it as you want. If you don't know how to use it, you will waste it. Oracle is more powerful than this, but it is great for our needs.

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.
Flag as inappropriate
Veerender Kumar
Product Owner at a tech services company with 201-500 employees
Real User
Top 5
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.
    Flag as inappropriate
    Gajanan Shalgar
    Software Engineer at a tech services company with 11-50 employees
    Real User
    Top 5
    Installation is straightforward, flexible-to-use and it has secure functions

    Pros and Cons

    • "SQL Server and their offers are very good. You can switch over, export, and do other things."
    • "The free version of SQL Server is time-limited before updating to the paid version."

    What is our primary use case?

    I use SQL Server for .NET. We have ERP software in the background and we use the SQL Server for its creation.

    What is most valuable?

    SQL Server and their offers are very good. You can switch over, export, and do other things. I got access from users and it is very flexible to use.

    What needs improvement?

    SQL Server is technically good. For questions or other queries, we go through the internet and they explain it there. I think the structure of their product is good.

    For how long have I used the solution?

    I have been using SQL Server for one year and a month.

    What do I think about the stability of the solution?

    It's stable. It was very easy for me to handle it.

    What do I think about the scalability of the solution?

    The free version of SQL Server is time-limited before updating to the paid version. So, sort of more access and more work in your database to help process most of the time. It's better to purchase it for more secure functions.

    How are customer service and technical support?

    We have a technical support engineer who handles maintenance and security for SQL Server. I think Microsoft's technical support is also very good.

    How was the initial setup?

    It's a straightforward installation. I installed SQL Server 2012, 2013 and 2016.

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

    The usability of the free version is limited. They also have some guidelines on how to use the paid ones. You still have to check your IT requirements after purchasing it. We are using a licensed one right now, which has more functionality than the free version.

    Which deployment model are you using for this solution?

    Hybrid Cloud

    If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

    Amazon Web Services (AWS)
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    Florent NOPOUDEM
    Senior Database Administrator at ITGStore
    Real User
    Top 5
    A stable, scalable and easily installable solution for saving and managing data and applications

    Pros and Cons

    • "Most valuable features include: high availability, clustering, save backup and recovery."
    • "Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication."

    What is our primary use case?

    We use the solution as a database for saving and managing data and applications.

    What is most valuable?

    Most valuable features include: high availability, clustering, save backup and recovery.

    What needs improvement?

    Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication.

    For how long have I used the solution?

    I have been working with SQL Server for four or five 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?

    The solution is scalable. 

    How are customer service and technical support?

    I am satisfied with the solution's partner support. 

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

    I am  satisfied with SQL Server.

    Use of alternative solutions varies with the client involved. Some make use of all that SQL Server has to offer, while others employ everything in Oracle Database. We have managed to resolve any issues they have encountered in the two cases in which they have approached us. 

    When examining Oracle or IBM db2, Oracle and SQL Server are generally the prefered products. 

    How was the initial setup?

    While I find the setup and installation to be easy, others may find it difficult. 

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

    I am only a technician and responsible for the installation, so I cannot comment on the licensing, although there are others in my company who are better qualified to do so. 

    What other advice do I have?

    The solution is mostly deployed for our clients on-premises. 

    We are satisfied with the documentation. 

    My advice is that one adhere to the documentation before doing installation. 

    I rate SQL Server as a nine out of ten. 

    Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
    Flag as inappropriate
    KG
    Associate Manager at a consultancy with 501-1,000 employees
    Real User
    Top 5Leaderboard
    Provides great CDC mechanism for adding data incrementally; simple installation

    Pros and Cons

    • "A big advantage is the ability to store any type of data in SQL Server."
    • "Performance could be improved."

    What is our primary use case?

    We use SQL Server to import data from different source systems. Depending on requirements, you act as the resource and can schedule jobs in the Azure environment. The server can be stopped when not required so there's no cost when it's not being used. We make use of the pipeline to put the data into the SQL Azure environment and extract it to the server. I'm the associate manager.

    What is most valuable?

    The best feature in SQL Server is the CDC mechanism for adding data incrementally. Another good feature is the ability to store any type of data in SQL Server, it's a big advantage.

    What needs improvement?

    You need to be careful if you have a very large amount of data, because the platform can be degraded if you're not on top of it. Oracle handles that issue better and it's the main problem I have with SQL Server. The performance should be better.

    What do I think about the stability of the solution?

    This is a stable product. 

    What do I think about the scalability of the solution?

    This product is scalable, we have between 20 and 30 users in our company. We'll continue to use this product. 

    How are customer service and technical support?

    We haven't needed to contact technical support. If there is an issue we use the different SQL forums and we can easily fix issues. 

    How was the initial setup?

    The initial setup is straightforward, you can install with basic knowledge. Installation doesn't take long at all, I did it myself. 

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

    There are no annual licensing fees, you pay when you use the product. 

    What other advice do I have?

    I rate this solution a nine out of 10.

    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.
    Flag as inappropriate
    Florent ADODO
    IT Assistant at Hotel 2 Fevrier
    Real User
    Top 5Leaderboard
    has an efficient configuration but is not sufficiently scalable in size for simultaneous connections

    Pros and Cons

    • "The initial setup is time-efficient and can be done independently."
    • "As SQL server could not support the number of connections we desired, we were forced to go with Oracle."

    What is our primary use case?

    We use SQL Server with Sage products.

    It is used by our finance team and also human resources.

    What is most valuable?

    the database management tool is very easy to use and largely meets expectations

    What needs improvement?

    As SQL Server could not support the number of connections we desired, we were forced to go with Oracle. This is an area that needs to be improved.

    For how long have I used the solution?

    for 04 Years now 

    What do I think about the stability of the solution?

    The solution could be more stable

    What do I think about the scalability of the solution?

    The performance in terms of simultaneous connection must be reviewed.

    How are customer service and technical support?

    We do not pay for technical support.

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

    No

    How was the initial setup?

    The initial setup is time-efficient and can be done independently.

    There is no need for developers or managers to deploy and maintain the solution. One or two systems' administrators are sufficient for its deployment.

    The deployment is on-premises. We installed the solution on a server and this on the Windows server. The user is provided an application for connecting to it.

    What was our ROI?

    great

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

    The licensing involves a one-time fee.

    Which other solutions did I evaluate?

    We evaluated Oracle as an alternative.

    What other advice do I have?

    For my part, SQL Server is aimed at small and medium-sized businesses, I would give it an eight out of ten.


    I would not recommend it for a large company that has to support more than 40 simultaneous bi-directional connections to the database


    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.
    Flag as inappropriate