Try our new research platform with insights from 80,000+ expert users
reviewer1621938 - PeerSpot reviewer
Senior BI Consultant at a tech services company with 11-50 employees
Consultant
Overall high quality features, reliable, and good technical support
Pros and Cons
  • "I have found the whole solution with all its features wonderful."
  • "If this solution could provide an automatic indexing feature it would be very useful."

What is our primary use case?

Our primary use case is for SQL Server is data warehousing and business intelligence.

How has it helped my organization?

This solution acts as the backbone of most IT services. It is essential for us to use it.

What is most valuable?

I have found the whole solution with all its features wonderful.

What needs improvement?

If this solution could provide an automatic indexing feature it would be very useful.

In the next release, there could be better integration with Power BI or other tools.

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

For how long have I used the solution?

I have been using this solution for approximately 20 years.

What do I think about the stability of the solution?

The solution is stable. There has been a few bugs but all solutions have them at one time or another.

What do I think about the scalability of the solution?

There are scalability limitations and this is why we are evaluating cloud alternatives. 

I rate the scalability of SQL Server a four out of five.

How are customer service and support?

We provide support for our clients but if we need support we receive it quickly because we are prime customers.

Which other solutions did I evaluate?

We are currently evaluating cloud options.

What other advice do I have?

I would advise those wanting to implement this solution to thoroughly investigate if this is the right tool for their use case.

I rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
PeerSpot user
reviewer1601793 - PeerSpot reviewer
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Real User
Simple to set up, simple to use, stable, and scalable
Pros and Cons
  • "I like that it's a cloud solution, is simple to set up, and is simple to use."
  • "It would definitely be better if SQL Server were free."

What is most valuable?

I like that it's a cloud solution, is simple to set up, and is simple to use.

We are also totally satisfied with the stability and scalability of SQL Server.

What needs improvement?

It would definitely be better if SQL Server were free. 

For how long have I used the solution?

I've been using SQL Server for two years.

It's a cloud-based solution.

What do I think about the stability of the solution?

We have had no issues with stability.

What do I think about the scalability of the solution?

It is scalable, and we have had no issues so far.

How was the initial setup?

The initial setup is straightforward and is comparable to that of PostgreSQL.

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

We pay per second of usage, but there are different offerings of the license.

Which other solutions did I evaluate?

We evaluated Oracle and PostgreSQL.

What other advice do I have?

For people who would like to use SQL Server for specific use-cases, I would definitely recommend it.

On a scale from one to ten, I would rate this solution at eight.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
SQL Server
September 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
868,787 professionals have used our research since 2012.
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.

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 technical 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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1593270 - PeerSpot reviewer
CEO at a tech services company with 51-200 employees
Real User
Highly functional in Microsoft environments, reliable, and scalable
Pros and Cons
  • "I have found that SQL Server works very well in the Microsoft Dynamics environment."
  • "There is room for improvement in performance when managing a large quality of data and a high number of active users."

What is our primary use case?

The solution is used for database management.

What is most valuable?

I have found that SQL Server works very well in the Microsoft Dynamics environment.

What needs improvement?

There is room for improvement in performance when managing a large quality of data and a high number of active users. 

For how long have I used the solution?

I have been using this solution for approximately 17 years.

What do I think about the stability of the solution?

I have found the stability great.

What do I think about the scalability of the solution?

The scalability is very good. We have five people in my organization using this solution in my organization.

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

I have used previously Oracle MySQL, IBM DB2, and SAP HANA. They are better suited for large-size data management.

What about the implementation team?

We have approximately 15 people handling the deployment and maintenance of the solution.

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

The solution is on a pay-per-use pricing model.

What other advice do I have?

I would strongly recommend this solution to others wanting to implement it in a Microsoft environment.

I rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1523223 - PeerSpot reviewer
IT at a financial services firm with 201-500 employees
Real User
Enables a person to do whatever is required at the command line level
Pros and Cons
  • "Since we can automate most of our tasks, it means that the management is very easy."
  • "I would like to see the database become fully automated."

What is our primary use case?

Microsoft SQL Server is a database application, meaning it acts as the backend system for help with the backend data repository system. It concerns itself with every activity that happens at the front end of the database in Microsoft SQL Server. ERP Microsoft solutions is one reason that the SQL server has compatibility. The management of Microsoft SQL Server is actually quite easy. It has a GUI interface and enables a person to do whatever is required at the command line level. It functions as a repository for storing one's data in the relational database. 

What needs improvement?

The Standard Edition and Enterprise Edition have certain limitations. While the latter is clearly more expensive than the former, it would be nice to see some of the features in the Enterprise Edition be moved to the Standard Edition. This will encourage many more people to use that solution.

If we were discussing the 2000 edition in respect of the SQL Server, I would probably cite security and performance as issues. However, nowadays, when it comes to an application connected to their databases, there is no real difference between MS SQL Server and Oracle. As a consequence, it would be nice to see the application be made more cost-effective. I am aware of much database self-management in respect of Oracle. I know that the last time a colleague of mine used this solution in California, he informed me that the application itself was managing the database.

At present, the solution uses the older connection and the schema is designed in such a way that it can actually provide a very low level of virtualization. Since the security is also hierarchical within the system, they've really done a very good job. 

This said, I would like to see the database become fully automated.

For how long have I used the solution?

I have been using SQL server for a couple of years, since day one. 

What do I think about the stability of the solution?

The solution is stable and it has remained so over the years. I've worked in different organizations, such as the banks here in Lagos. Straight off the bat, I've been using Microsoft SQL Server 2000. We currently use Microsoft SQL Server for our ERP needs. How one designs his tables is important. As the team leader, it is my job to ensure that the functioning is as it should be. The application is pretty straightforward. 

Since we can automate most of our tasks, it means that the management is very easy. We can have jobs for our backups. The solution grants us the ability to perform database housekeeping tasks.

What do I think about the scalability of the solution?

The solution is very scalable.

How are customer service and technical support?

It's been fun dealing with technical support. Generally speaking, they have shown a willingness to handle issues we may have. 

What other advice do I have?

The solution demonstrates performance and this is going well for the moment. 

In consideration of its performance, I rate SQL server as a nine out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Computer engineering student at a educational organization with 501-1,000 employees
Real User
Stable with good technical support and integrates well with Visual Studio
Pros and Cons
  • "The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
  • "The solution could be better integrated with the SQL Server Studio tool."

What is our primary use case?

I primarily use the solution for the development of various applications, database connections, that I need for projects.

I just use it myself, for assignments. I am a student and am studying the product.

What is most valuable?

The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services.

The solution is very stable.

The solution scales well.

The initial setup is straightforward. 

What needs improvement?

I don't have a deep technical knowledge of the solution. It's hard to discuss features that may be lacking.

The solution could be better integrated with the SQL Server Studio tool.

There are some complexities with the initial setup sometimes as there are a lot of options.

For how long have I used the solution?

I've been using the solution for two years at this point.

What do I think about the stability of the solution?

The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable in terms of performance.

What do I think about the scalability of the solution?

The solution can scale. If a company needs to expand it, it can do so.

As a student, I don't yet have plans to increase usage of the product.

How are customer service and technical support?

I've been in touch with technical support. I contact them to assist with a bug that I detected, that was not really related to SQL Server. It was, however, related to another tool, the Microsoft SQL Server Studio. They responded quickly. I was quite satisfied with their level of support for the most part.

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

I've also worked with PostgreSQL, and MySQL as well as MongoDB. I found that, in comparison, PostgreSQL was not as easy to use.

How was the initial setup?

The initial setup was pretty straightforward. It's very similar to other software products. The Visual Studio is easier, however, it's still mostly straightforward. It could be better integrated with this SQL Server Studio tool. You have to install it separately. If they could be installed together, that would be an improvement in my opinion. While not everyone would use it, the developer would find it a helpful item to have.

It can sometimes be confusing to install by yourself since it does have many options that you need to decide on.

What about the implementation team?

I was able to install the solution myself. I did not need the assistance of an integrator or consultant.

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

You do need to pay for a license in order to use the product.

What other advice do I have?

I'm just an end-user.

I'd rate the solution at a nine out of ten. I'm mostly happy with its capabilities.

I'd recommend the solution to other users. It's a solution that is nice and standardized. We are learning all about it at school and its industry standards make it a good option.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1430925 - PeerSpot reviewer
Technical Director at a security firm with 51-200 employees
Real User
Stable and easy to install
Pros and Cons
  • "It is stable, and it works okay."
  • "It would be nice if they can reduce its price."

What is our primary use case?

It is used for many things. We primarily use it for our two-tier and three-tier applications.

What is most valuable?

It is stable, and it works okay.

What needs improvement?

It would be nice if they can reduce its price.

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

How are customer service and technical support?

I didn't use their technical support.

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

I have used Microsoft Access.

How was the initial setup?

Its installation is straightforward. It took half an hour to one hour.

What about the implementation team?

I can install it myself.

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

We did a one-time payment. Its price, in general, can be reduced.

What other advice do I have?

I would recommend this solution to others. I would rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Operations Director at ALTERSIS Performance
Real User
Flexible and easy to use but the performance could be better
Pros and Cons
  • "It's a good option for those that have a lot of Microsoft solutions in use."
  • "The solution needs to be more secure. It's lacking, compared to, for example, Oracle."

What is our primary use case?

We use the product for information systems. This is a must both for us. We use it for our Enterprise Portal.

What is most valuable?

The solution has proven to be very flexible.

The product is quite stable.

Overall, we've found it to be extremely easy to use. 

The initial setup is pretty straightforward. It's not difficult to implement and the deployment doesn't take too long.

Technical support has been pretty good so far. They are helpful.

It's a good option for those that have a lot of Microsoft solutions in use.

What needs improvement?

The solution needs to be more secure. It's lacking, compared to, for example, Oracle.

The product needs to work on its scalability. Oracle can scale a bit more effectively.

Sometimes we have some performance issues. It's not like Oracle. Oracle is more powerful in terms of performance. 

For how long have I used the solution?

I've just been dealing with the solution for a few months. It hasn't been too long just yet.

What do I think about the stability of the solution?

We've had some performance issues overall. It's something that's a pain point for us. They need to work on their capabilities in this regard.

What do I think about the scalability of the solution?

The solution could be more scalable. Oracle scales better for companies that need to expand.

We have two to three customers that use the solution currently.

How are customer service and technical support?

We've used technical support in the past. They've been helpful and responsive. We haven't had any issues when we deal with them. We are quite satisfied so far with the level of service we receive when we reach out. 

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

I've also used Oracle in the past. From my side, Oracle is more technical and is more scalable, and more secure than the SQL server.

How was the initial setup?

The installation is quite straightforward. It's not overly difficult or complicated. I found it to be quite simple.

The deployment is rather quick. It took us about one hour, from what I can recall.

We just need one technical person to handle the implementation and maintenance processes. 

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

Customers do have to pay to use the solution. They tend to pay on a yearly basis. 

What other advice do I have?

I'd rate the solution at a seven out of ten.

I'd recommend the solution to other customers, users, and companies. It's a good option of r many. Sometimes the customer is Microsoft-oriented and sometimes they are Oracle-oriented. If the customer is already using a lot of Microsoft products, SQL just makes sense. 

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. Integrator
PeerSpot user
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: September 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.