VP Global Information Technology at a insurance company with 10,001+ employees
Real User
Top 5
A scalable and stable solution with a flawless setup
Pros and Cons
  • "The initial setup is easy, flawless."
  • "I want to see one improvement and this involves the replication between the DC and DR."

What is our primary use case?

We are using the latest version.

We can use the solution for the same application. On the database side we have Microsoft SQL and on the operating system side we have 2019.

What needs improvement?

I want to see one improvement and this involves the replication between the DC and DR. We have limited options at the moment and it does not lend sufficient support for the number of databases. This means we have a huge number of databases, topping approximately 2,000. For the moment, this particular replication is not supported by SQL. 

The support number of databases needs to be increased, as well as the database number of databases that it supports. That support cannot be found when it comes to the replication between the DC and DR. 

For how long have I used the solution?

I have been using SQL Server for ten years. 

What do I think about the stability of the solution?

The solution is sufficiently stable. 

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

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and support?

When it comes to the speed, knowledge and customer-friendliness of the technical support, we feel these to be good. 

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

We did not use other solutions prior to SQL Server. 

How was the initial setup?

The initial setup is easy, flawless. 

It lasts a single day. 

What about the implementation team?

We handed the implementation on our own. 

This involved a technical team of 15 people. 

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

There is a need to pay for the license for SQL Server. We have an enterprise license, which we consider to be fine. 

What other advice do I have?

We have 10,000 customers. 

I would recommend the solution to others. 

SQL Server is good and I rate it as a nine 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 SkyNet
Real User
Top 10
Easy to manage and configure, reliable, easy to expand, and good documentation
Pros and Cons
  • "What I like most is the management, as it is very easy compared with other products."
  • "Security is an issue."

What is our primary use case?

I am an IT professional, I write services for my clients. I provide support services for SQL, firewalls, and operating systems. IT infrastructure support in general is what I provide.

What is most valuable?

What I like most is the management, as it is very easy compared with other products.

What needs improvement?

Security is an issue. This is an area that needs to be improved.

There is security built-in, but most of the developers don't emphasize the security enough. When they are building the products or databases, they don't focus on the security of the database.

For how long have I used the solution?

I have been providing services for this solution to my clients for five or six years.

What do I think about the stability of the solution?

We have had no issues with stability. It's one of the most stable products.

What do I think about the scalability of the solution?

This solution is scalable. It is easy to expand.

How are customer service and technical support?

In the five or six years that I have been handling SQL Servers, I have not had to contact technical support. 

Their documentation is sufficient for troubleshooting and maintenance activity.

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

I am also using Sophos.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

We have our in-house team of more than 10 engineers for maintenance.

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

Pricing is a bit on the higher side. It could be reduced.

What other advice do I have?

To others who are interested in using this solution, I would say go for it. It's a stable database that is easy to configure and maintain. I would suggest this solution when compared with other databases.

I would rate 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
Buyer's Guide
SQL Server
November 2022
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
656,862 professionals have used our research since 2012.
Mohammed Habeeb - PeerSpot reviewer
System Administrator at ARTIc
Real User
Top 20
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
PeerSpot user
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.
PeerSpot user
RogerMorera - PeerSpot reviewer
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.
PeerSpot user
Veerender Kumar - PeerSpot reviewer
Product Owner at a tech services company with 201-500 employees
Real User
Top 5Leaderboard
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
    Gajanan Shalgar - PeerSpot reviewer
    Software Engineer at a tech services company with 11-50 employees
    Real User
    Top 10
    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.
    PeerSpot user
    Miyoba Sichimwi - PeerSpot reviewer
    Information Technology Security Officer at a government with 201-500 employees
    Real User
    Top 5
    Beneficial support system, highly scalable and reliable
    Pros and Cons
    • "SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm."
    • "SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI."

    What is our primary use case?

    All our databases are using Microsoft SQL. It supports our application, such as HR and finance.

    What needs improvement?

    SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI.

    For how long have I used the solution?

    I have been using SQL Server for approximately 10 years.

    What do I think about the stability of the solution?

    SQL Server is highly stable.

    What do I think about the scalability of the solution?

    SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm.

    The solution is suitable for any environment, such as small, medium, and large enterprises. 

    How are customer service and support?

    SQL Server support system is well-established. It's a Microsoft solution therefore you receive support very easily. It is the number one selling point of SQL Server. I have been highly satisfied with the support.

    How was the initial setup?

    SQL Server's initial setup is simple. However, you must be a specialist to do it. That's the unfriendliness that I see about the solution. It has to be done by an engineer and not any engineer can do it, you have to be a specific Microsoft engineer.

    What other advice do I have?

    My advice to others would be to create a standard for SQL Server to allow a high level of security. What we did is, we adopted CIS, which is the Center for Information Security, hardening standards and benchmarks to keep it secure. SQL Server out of the box comes with a lot of unnecessary services that can make you very vulnerable to any site attack.

    I rate SQL Server an eight out of ten.

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