Try our new research platform with insights from 80,000+ expert users
Team Lead, Process Improvement at Fidelity Bank Plc
Real User
Easy to use, reliable and simple to set up
Pros and Cons
  • "Backups hardly get corrupt."
  • "The pricing could be more affordable."

What is our primary use case?

I use the client, however, I can also use the server, the Microsoft SQL Server Studio. I can use both, both the client and the studio.

We connected Automation Anywhere to the DB. Our reporting tool is also connected to that DB. Our financial application is also connected to the DB and some other databases too as well as some of our APIs.

What is most valuable?

I like the way it can manage the users from the security section where you can change their roles. 

SQL is simple to manage, as long as you know the script, and know the tables that you make reference to. If there are errors, you can easily debug them. 

You can easily debug and resolve your issues. 

The ease of backup, how you can back up and call up your backups too is great. Backups hardly get corrupt, except if maybe you have some bad hard drive clusters or bad hard drive sectors.

It is stable.

It's an easy-to-use product.

I find the solution to be scalable.

What needs improvement?

The pricing could be more affordable.

It's like to see less frequent updates. They should be once a month.

For how long have I used the solution?

I've been using SQL Server for a very long time.

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

What do I think about the stability of the solution?

The stability is great. It's very reliable. There are no bugs or glitches. It doesn't crash or freeze.

What do I think about the scalability of the solution?

The product scales well. If you need to expand it, you can.

We have around 50 users on the solution right now. 

How are customer service and support?

The solution is pretty problem-free and therefore it would be rare to have to reach out to support.

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

We've always used SQL. I also use SQLite.

How was the initial setup?

The initial setup is very simple, very straightforward. It's not too complex. 

The time it takes to set up isn't long. The time of installation is determined by the local system or the server where you are installing it to. That said, it's a light solution. For me, it took maybe ten minutes. 

We have eight people who are technical and can handle deployment or maintenance tasks. 

What about the implementation team?

I did the installation myself. It's not hard to do. You don't need a consultant or integrator.

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

We pay a monthly subscription fee. 

What other advice do I have?

I'm an end-user.

I would recommend the solution to other users and organizations.

Overall, I would rate it at 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
reviewer1671969 - PeerSpot reviewer
Data Architect at a computer software company with 1,001-5,000 employees
Real User
Reliable and easy to use
Pros and Cons
  • "It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
  • "One thing I don't like about SQL Server is the way they've set up security with users and groups. It just doesn't seem that intuitive to me. Adding some more explanatory information might help some."

What is our primary use case?

We do data warehousing, and our clients are mainly large commercial Insurance providers in the United States.

What is most valuable?

It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC. You don't have to do all the scripting for the database, then all the tables, keys, etc. It takes all that out of your hands.

What needs improvement?

One thing I don't like about SQL Server is the way they've set up security with users and groups. It just doesn't seem that intuitive to me. Adding some more explanatory information might help some. Sometimes the documentation is a little thin, but the same could be said about a lot of products.

For how long have I used the solution?

I've been using SQL Server on and off since it first came out in the 1990s. Most of the people I've worked for are SQL Server shops.

What do I think about the scalability of the solution?

I can't really speak intelligently about that because I haven't been on any of the real big ones yet. 

How was the initial setup?

The complexity of the initial setup really depends. Obviously, you're going to need to know a few things and there are different ways to do deployments. I like the BACPAC, which is one of the features that come with SQL Server. It's a nice feature to deploy. BACPAC really handles all of the configuration for you. If you use that, I don't think you really need to know too much. If we're talking about a small database that holds a few thousand records, it doesn't matter what you're doing. You can't make a mistake because it's just not big enough.  

We do a lot of Azure-based on-demand type systems where we host the system or we host it in Azure. We do the work for them. So we don't really do a lot of those installs.

Which other solutions did I evaluate?

We're going a lot heavier into Azure and we're going to be dealing with lots of volume because insurance data is pretty voluminous. I think some of our clients don't like the idea of having one gigantic VM system to run the database. That's one reason why they're switching to Snowflake. We had to do some SSRS stuff in the past, and I think they're moving over to Power BI mostly.

What other advice do I have?

I'd probably rate SQL Server nine out of 10. I don't think I'd give anybody a 10, but I think nine's about the best I can do. In my experience, it's been reliable and easy to use.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
SQL Server
March 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
848,716 professionals have used our research since 2012.
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
Low maintenance, helpful online community, and flexible
Pros and Cons
  • "The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward."
  • "SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."

What is our primary use case?

We use SQL Server as a relational database mostly for the application backend activities and integrations.

What is most valuable?

The SQL Server is low maintenance, it does not require advanced technical skills to maintain or use it as you might in other similar database solutions. You need some knowledge on how to access the solution and how to query it but it is fairly straightforward.

What needs improvement?

SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance.

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 stable.

What do I think about the scalability of the solution?

The solution is scalable and flexible.

We have approximately 15 people using the solution in my organization.

How are customer service and technical support?

The technical support from Microsoft is good but we have learned and received the most help from the online community.

How was the initial setup?

The installation difficulty level depends on the use case and environment. For example, if you need to deploy it on multiple nodes or have large amounts of storage it could increase the difficulty level. 

What about the implementation team?

We have a team of approximately five database administrators and application developers who handle the setup and maintenance of the solution.

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

There is a license required for the use of SQL Server and we are on an annual subscription.

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
Dimitris Iracleous - PeerSpot reviewer
Lead Technical Instructor at Code.Hub
Real User
Top 5Leaderboard
A user-friendly, reliable solution for organizing data from subscribers and customers
Pros and Cons
  • "The solution is user-friendly, is a robust tool and is always reliable to users."
  • "The interface integration could be better."

What is our primary use case?

We are a company that possesses data relating to the banking and telecommunications sectors. We use the solution to organize all data received from subscribers and customers. 

What is most valuable?

I feel that this is the simplest of solutions. It is user-friendly, is a robust tool and is always reliable to users. The solution is within the Windows environment. This means that all users, who are already accustomed to Windows, will naturally prefer to use this environment over that of Linux or another operating system. 

What needs improvement?

I would like to have a more directed modeling, to have the flexibility to design all databases using a graphic interface. In other words, the interface integration could be better. 

To avoid the need to write code, many users like to use the database diagrams as an overall tool and, as such, the solution should be more flexible and user-friendly. 

For how long have I used the solution?

I have been actively using SQL Server for up to 10 years. I started with programming, moved to databases and am now concentrating on Power BI.

What do I think about the scalability of the solution?

The solution is quite scalable, as it can be extended to replicate many computers. It can be used in a virtual environment. One would, of course, make use of the cloud. We are now gaining experience in cloud programs such as Azure and AWS.

How are customer service and technical support?

There are two teams which provide technical support. The same team provides support for all these tasks. 

How was the initial setup?

The initial setup is not without certain problems. Many users prefer to use Docker in lieu of the original selection. This is more convenient for them owing to certain configurations it possesses. However, if one is incapable of doing this initially he will find it difficult to do at a later date. An example would involve the inclusion of TCP/IP support, which is quite cumbersome. While it is not very difficult, it does require a certain amount of expertise. 

We have prepared many virtual machines. Each month we prepare these systems so that they may be ready to meet our needs. This task consumes three to four days per month. 

What about the implementation team?

We have a support team who helps our users with deployment. They provide these services to our customers.

When it comes to deployment and maintenance, there are four people responsible for providing the administrative support to us and to our customers.

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

Our customers do pay license fees for the MS SQL Server but the Rabbit is free, as it is open-source software.

Some who pay for these prefer in-house, on-premises support, while others take a cloud-based approach. 

What other advice do I have?

I am also a consultant to SQL Server.

I usually consult with databases, including the Power BI. I started with data business and now shifted to this.

I strongly recommend the solution because we are doing consulting projects using Java applications.

I rate SQL Server as a nine 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
reviewer1570953 - PeerSpot reviewer
Database Administrator at a computer software company with 10,001+ employees
Real User
Very scalable and stable, good support, and works well with Windows Server platforms
Pros and Cons
  • "Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
  • "Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities."

What is our primary use case?

It is used for everything under the sun. We're currently using it for a health pass for a medic aid information management system. It is also used by companies in banking and retail.

We are using SQL Server 2014 on Windows Server 2012 platform, and we also have SQL Server 2016 on Windows Server 2016 platform. I have primarily worked on the hardware, but I am now also working in the Amazon AWS cloud.

How has it helped my organization?

The entire solution that we're deploying is built on Microsoft SQL Server as a database engine. Our solution is completely engineered for that, and if we attempt to deploy it in any other database engine, it is going to be a huge nightmare.

What is most valuable?

Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.

What needs improvement?

Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities.  The native SQL Server Backups take more time than do the backup processes from LiteSpeed, and the backup compression is a little less.  

For how long have I used the solution?

I have been using SQL Server since version 6.5, which came out about 30 years ago.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

It is very scalable. You can run the database engine on the C drive, or you can run it on a large cloud array or a disk array. Currently, we just have developers and testers accessing it.

How are customer service and technical support?

Technical support from Microsoft is very good.

How was the initial setup?

If you know how to set it up, it is easy, but you have to learn that over time. For a new user, it is detailed. You need to have the right things in place at the right time before you actually install the software.

To create an instance, it takes about an hour overall. This includes deploying the basic system, applying the latest service pack, and then applying the latest cumulative update.

What about the implementation team?

It was an in-house job. In terms of maintenance, the number of staff members required would depend on the implementation. It requires coordination amongst teams. It is a team effort. The database administrator creates and runs the jobs that create the backup file. You need to have somebody for copying the backup files to offline storage. You also need to have system administrators for setting up the hardware.

What other advice do I have?

I would advise others to just be familiar with Windows concepts.

I would rate SQL Server a nine out of ten. If you're familiar with Windows concepts, it just works.

Which deployment model are you using for this solution?

Public Cloud

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2112948 - PeerSpot reviewer
Consultant at a transportation company with 10,001+ employees
Real User
Top 5
Backups data quickly and initial setup is easy
Pros and Cons
  • "Managing database is very good."
  • "Sometimes we experience issues with its stability."

What is our primary use case?

We do backups or restore or query tables to create the views, create some triggers to send the attachment report files, and to report on data.

What is most valuable?

It makes managing the database easy. Backups are very quick.

What needs improvement?

Sometimes we experience issues with its stability.

For how long have I used the solution?

I have experience with SQL Server for 3-4 years. 

What do I think about the stability of the solution?

Sometimes we experience issues with its stability.

What do I think about the scalability of the solution?

Five thousand users are using the solution. 

How was the initial setup?

The initial setup is easy. Fifteen twenty minutes required for deployment. 

What other advice do I have?

Overall, I would rate the solution 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
reviewer2384076 - PeerSpot reviewer
BI Specialist at a educational organization with 1,001-5,000 employees
Real User
Top 20
Highly stable and easy to use, but its pricing and quality could be improved
Pros and Cons
  • "SQL Server is a highly stable solution."
  • "The pricing and quality of the product could be improved."

What is most valuable?

SQL Server is a highly stable solution.

What needs improvement?

The pricing and quality of the product could be improved.

For how long have I used the solution?

I have been using SQL Server for more than 40 years.

What do I think about the stability of the solution?

I rate SQL Server a nine out of ten for stability.

What do I think about the scalability of the solution?

Our clients for SQL Server are usually enterprise businesses.

I rate the solution an eight or nine out of ten for scalability.

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

On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing a seven out of ten.

What other advice do I have?

Since SQL Server was one of the most commonly used products initially, it was very easy to use. I'm moving away from the solution because there are now better data storage tools. SQL Server was used for the postal service in the Netherlands, where the postal buses on the street were analyzed. SQL Server is always deployed on the cloud.

Data recovery and backup are sometimes hard with SQL Server because of the data store size. Based on the data structure, I would sometimes recommend the solution to other users.

Overall, I rate the solution a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
System Engineer at CMC CSI saigon
Real User
Top 5Leaderboard
Easy to install, reliable, and reasonably priced
Pros and Cons
  • "The license fee is very low."
  • "We have no vision. We don't know when or how we have been hacked."

What is our primary use case?

SQL Server is only running in China, it is not connected to our site.

We have some PCs running on Windows 7, but it is not supported.

What needs improvement?

We have no vision. We don't know when or how we have been hacked.

We require expert support with it. That is why I am looking for CRMs.

For how long have I used the solution?

We have been using SQL Server for one year.

We use several versions such as 2008, 2012, and 2015.

What do I think about the stability of the solution?

SQL Server is stable.

What do I think about the scalability of the solution?

We are not running more than 1%. Scalability needs improvement.

We have 415 users in our organization.

We have plans to increase our usage.

We have an Active Directory system, so we can install antivirus on the endpoints.

How are customer service and support?

Normally, we can check with the deployment person, and our IT team will respond to the message once my team has deployed it.

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

I have some experience with McAfee MVISION Endpoint. We are focused on the MV1 edition. We have to blend into the EDR.

McAfee has three editions, MVISION 1, 2, and 6. We are still working with version 1.

We are also working with Endpoint Plan 1.

We have 15 servers, both Windows OS and Linux OS.

How was the initial setup?

The initial setup is not complex.

We have an in-house IT team that can deploy this solution.

What about the implementation team?

We have some people who have worked in IT and with endpoint software. I believe my team is capable of handling the new software, and solutions.

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

The licenses are purchased annually.

The license fee is very low.

Which other solutions did I evaluate?

I was looking into some solutions to meet our company's needs. Endpoint Protection for Business, McAfee, and Microsoft Defender for Endpoint was among the solutions I researched. For endpoint security, I prefer Microsoft Defender or McAfee Endpoint Security.

Now we're comparing the cost-effectiveness, and especially the features, and giving ourselves the ability to choose the solution, truly enabling a solution.

What other advice do I have?

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

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