Try our new research platform with insights from 80,000+ expert users
reviewer1470330 - PeerSpot reviewer
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
Real User
Dec 30, 2020
Scalable as a cloud, good as a data warehouse, and offers good analytics
Pros and Cons
  • "As a data warehouse and storage solution, it's quite good."
  • "The solution could use better governance on the management side, especially around data governance."

What is our primary use case?

We use the solution for many tasks. We use it as a data warehouse. However, we also use it for workflows and processing jobs.

What is most valuable?

The analytics are pretty good.

As a data warehouse and storage solution, it's quite good.

It's easy to put the data back onto the SQL Server or Oracle. 

The solution is pretty fast. We find it to be responsive.

There are a lot of services, such as the SSISS, SIS, and SSI's that work quite well.

What needs improvement?

The solution could use better governance on the management side, especially around data governance.

The product could do better at allowing for integrations. 

For how long have I used the solution?

I've been working with the solution for many years. It's likely ten to 15 years at this point. It's well over a decade, so I have some long-term experience with the product overall.

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

What do I think about the scalability of the solution?

The scalability for the solution is good, at least where it concerns the cloud. Using the cloud makes everything very easy to scale. On-remises, if you run out of dick space, it's a bit difficult.

How are customer service and support?

We've been in touch with technical support in the past. We manage the data center ourselves, however, if we run into issues we know we can contact them for assistance. I'd say we are quite satisfied with the level of support we get.

How was the initial setup?

I can't recall how the initial setup was. It was a while ago. We've had the solution for a very long time.

What other advice do I have?

We're just customers and end-users.

I don't know if I would recommend the solution per se. There are other options out there. Something that is a NoSQL database. Something like Snowflake, for example, might be a very good option for data warehousing. They are more adept at handling different types of data.

You shouldn't have to create tables or systems, you should just be able to query files.

I'd rate the solution at an eight out of ten. However, for the current scenarios we have, there are other options that may be more suitable. It's not the only product available on the market, and the competition is quite good.

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
reviewer1187943 - PeerSpot reviewer
Director of Data Analytics at a insurance company with 1,001-5,000 employees
Real User
Dec 12, 2020
Stable with good support, but the scalability needs improvement
Pros and Cons
  • "Technical support is very good."
  • "Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way."

What is our primary use case?

We are using this solution for application databases and data warehouses.

How has it helped my organization?

The organization was deploying SQL before I came to it, so I assume whoever selected this type of technology was really happy with it.

What is most valuable?

That question is not that easy to answer, to say that there is a feature in a database that you like more than others. When you are running a database, you expect it to do many different things, and if fails in one area, it basically takes it out of the picture completely.

What needs improvement?

Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way.

I would like to know how you can scale to be a large enterprise server.

For how long have I used the solution?

I have been using SQL Server for approximately 20 years.

We were using version 16 and we went to version 19.

What do I think about the stability of the solution?

There are no issues with stability that are not within the norm where you deploy new versions. Microsoft is always very close. When we experience any type of glitch, Microsoft handles it and we take care of it.

What do I think about the scalability of the solution?

It scales with a lot of effort. When comparing it to Exadata, it's easier to scale with Exadata.

How are customer service and technical support?

Technical support is very good. We have them on-site.

They know their business very well and I would rate them a ten out of ten.

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

Previously, I was working with Oracle Exadata at a different company. It was great, and ran very smoothly.

How was the initial setup?

The initial setup was straightforward because we had help from Microsoft.

What about the implementation team?

We had help through the Microsoft team.

Which other solutions did I evaluate?

Our company is Microsoft SQL Server based. I used to use appliances like Exadata before I joined the organization. 

I was looking to see if there would be available technology solutions that would make Microsoft SQL Server work on an appliance to improve stability and scalability, as opposed to running or dividing into Intel-based processors and servers, and handling all of the operational issues.

Having a server that's optimized for the purpose of data warehousing and analytics, is something that I would be interested in. 

I am not sure if there is anything else available as a nice comparison.

We use SQL Server and we are evaluating Azure cloud, and Azure SQL.

What other advice do I have?

I am a data person. I design data warehouses and I develop analytics.

Before implementing SQL Server, make sure that you evaluate it based on the case that you're actually planning to implement it for, and that it's not just for general purposes.

It's not built for everything and anything. You need to choose carefully.

I would rate SQL Server a seven 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
Buyer's Guide
SQL Server
December 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,310 professionals have used our research since 2012.
Victor Sokolov - PeerSpot reviewer
Data Architect/Engineering manager at a computer software company with 1,001-5,000 employees
Real User
Top 10
Dec 11, 2020
Stable, scalable, and good integration services
Pros and Cons
  • "The columnstore index feature is useful for us, and we also use the integration services. It is also very stable."
  • "We would like to have a common storage option in the SQL Server. This option is available in Oracle Database. It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage."

What is most valuable?

The columnstore index feature is useful for us, and we also use the integration services. It is also very stable.

What needs improvement?

We would like to have a common storage option in the SQL Server. This option is available in Oracle Database. It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage.

For how long have I used the solution?

I have been using SQL Server for four years.

What do I think about the stability of the solution?

It is pretty stable.

What do I think about the scalability of the solution?

If we talk about just standard RDBMS, it is very scalable because we don't have to scale platforms.

How are customer service and technical support?

All communication with Microsoft technical support is done by our internal support group. I'm not communicating with them directly. I guess their technical support is okay and fast.

What other advice do I have?

I would recommend SQL Server as a solution for a medium enterprise or a small business.

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
IT manager at a manufacturing company with 5,001-10,000 employees
Real User
Top 10
Dec 9, 2020
An easy initial setup with good pricing and good stability
Pros and Cons
  • "The pricing of the product is very good."
  • "The solution could offer better integration with other solutions - specifically Microsoft."

What is our primary use case?

We primarily use the solution as a WAP server and we have it on-premises.

How has it helped my organization?

It's helped us connect to our company's machines.

What is most valuable?

The pricing of the product is very good.

We've found the stability to be very reliable.

The initial setup isn't too complicated. It's pretty straightforward.

What needs improvement?

Overall, the solution could be improved in future releases. We hope to improve the way we use it ourselves in our next project.

The solution could offer better integration with other solutions - specifically Microsoft.

For how long have I used the solution?

I've been using the solution for about five years at this point. It'd been a while.

What do I think about the stability of the solution?

Thus far, the solution has been quite stable. It doesn't crash or freeze. there aren't bugs or glitches. It works well for us overall and we find it to be reliable.

What do I think about the scalability of the solution?

I'm not sure about the capability of the solution's scalability. We've never really tested its capabilities, and it's therefore hard to gauge.

How are customer service and technical support?

We have a department that handles support. I find them knowledgeable. They respond in a reasonable amount of time. 

How was the initial setup?

The initial setup wasn't complex. It was pretty straightforward. We didn't have any issues with the implementation process at all.

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

The licensing is reasonable. It's not too expensive. We are charged on a yearly basis, however, I don't know the exact amount we are charged. I'm not a part of the billing and payments department.

What other advice do I have?

I believe we are using the 2019 version of the solution.

In general, I would recommend the solution to other organizations. We've mostly been pretty happy with its performance.

We're not Microsoft partners. We are just customers.

Overall, I would rate the solution eight out of ten. If it had better integration capabilities with Microsoft, I might rate it higher.

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
Owner at a computer software company with 11-50 employees
Real User
Top 20
Dec 8, 2020
Reliable, with good programmability, and helpful web support
Pros and Cons
  • "The most valuable features are programmability and reliability."
  • "Price could be cheaper, and access to reporting tools should be better."

What is our primary use case?

We are using this solution for business websites.

What is most valuable?

The most valuable features are programmability and reliability.

What needs improvement?

Price could be cheaper, and access to reporting tools should be better.

For how long have I used the solution?

I have been working with SQL Server for more than 20 years.

What do I think about the stability of the solution?

It's a stable product.

What do I think about the scalability of the solution?

It has limited scalability, but it's perfectly adequate for our needs. We apply vertical scalability to it and not horizontal.

We are a very small software development company, scaling is not an issue for us.

How are customer service and technical support?

Technical support is good.

In general, we use what is available on the web, rather than talking to people. The articles on the web are more useful.

We have no particular issue with Microsoft.

How was the initial setup?

The initial setup was straightforward. It was very easy to do.

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

The price could be cheaper.

What other advice do I have?

The marketing for dealer support and that type of environment is very contorted. It's very difficult to access, but, with the technical side of things, they are fine.

My experience is limited, but compared with Oracle, Microsoft SQL Server is many times better and easier to program with. So, I love Microsoft. I don't like Oracle.

I would rate SQL Server a ten 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
Technical Department Manager at a computer software company with 11-50 employees
Real User
Nov 30, 2020
Straightforward setup and good stability
Pros and Cons
  • "We have many users, between 50 and 100 using the SQL Server product."
  • "Right now we don't get much technical support from Microsoft"

What is our primary use case?

We use it mostly for integration into an ERP system. We also use it for our internal development of products.

How has it helped my organization?

We have many users, between 50 and 100 using the SQL Server product.

What is most valuable?

We have been using SQL Server from the start, so it's a stable product.

What needs improvement?

I think a web console for the management studio, I think that would be a good thing. I think also on load balancing. I think that's something that we can use.

For how long have I used the solution?

We've been using SQL Server for 12 years. We are currently using the latest version. It is deployed on-premise and cloud.

What do I think about the stability of the solution?

The product is stable.

What do I think about the scalability of the solution?

The product is scalable.

How are customer service and technical support?

Right now we don't get much technical support from Microsoft. I think for all issues we encounter, we do the solutions by ourselves. I think if there should be some avenue for us to raise some issues that we are encountering, so maybe that would be something that's good for us as well. It is not easy to contact Microsoft support for this product.

How was the initial setup?

Setup required two engineers to deploy it. It was pretty straightforward and took one to two days.

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

We didn't have any licensing costs for SQL Server.

What other advice do I have?

I would recommend this product to others and give it an 8 out of 10.

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. Implementer
PeerSpot user
Enterprise Solutions Department Manager at a tech services company with 201-500 employees
Real User
Oct 31, 2020
A stable solution for storing and retrieving data
Pros and Cons
  • "The technical support is good."
  • "The user interface and the reporting could also be improved."

What is our primary use case?

We are a software development company. Most of our developers use SQL Server. We plan to continue using this solution in the future.

We use SQL Server for relational database management.

We have a variety of customers who use it in the government sector and in the tourism sector.

What needs improvement?

The time series database could be improved. There needs to be more storage space for large documents.

The user interface and the reporting could also be improved. It's not bad, but it could be improved upon.

For how long have I used the solution?

I have been using this solution for 20 years.

What do I think about the scalability of the solution?

SQL Server is both scalable and stable.

How are customer service and technical support?

The technical support is good.

How was the initial setup?

Installation was very easy. We had it installed within one hour.

What about the implementation team?

One of our team members deployed it.

What other advice do I have?

I would definitely recommend this solution to others.

On a scale from one to ten, I would give SQL Server a rating of eight.

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
reviewer1413750 - PeerSpot reviewer
Lead Data Architect at a financial services firm with 1,001-5,000 employees
Real User
Sep 5, 2020
Easy to use and integrates well with other Microsoft products, but the performance needs improvement, and there are many hidden costs at the enterprise level
Pros and Cons
  • "The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
  • "The performance needs some improvement and it needs more features integrated into it."

What is our primary use case?

We are using SQL server for both transactional and analytical purposes, and for storing the data.

How has it helped my organization?

We are familiar with Microsoft products and bringing another Microsoft product was a very easy transition.

What is most valuable?

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.

What needs improvement?

The performance needs some improvement and it needs more features integrated into it.

Technical support could be better. 

Scalability could be less costly.

One of the conflicts with Microsoft is if you have an enterprise relationship, you have to deal with a third-party offering Microsoft solutions.

In the 2016 version, they don't have support for Python. It may be included with the 2019 version but if they don't, I would like to see support for Python implemented.

For how long have I used the solution?

The company has been using this solution for approximately 20 years. I was in contracting and now have been using it for approximately five years.

What do I think about the stability of the solution?

SQL Server is pretty stable.

What do I think about the scalability of the solution?

There is a concern with the scalability because it's an on-premise technology. 

Scaling always comes with more costs and also the licensing cost increase, which makes it complex, and more difficult.

We have backend developers, data engineers, data scientists, and analysts using this solution.

How are customer service and technical support?

Most of the time, technical support is not straightforward and it goes to a third party.

I wouldn't say that it is great, but okay.

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

Previously, we had not used any other solutions. We have been a Microsoft shop from the beginning.

How was the initial setup?

The initial setup was not easy but not complex. Rather, it was somewhere in between.

What about the implementation team?

We did not use an integrator or reseller to deploy this solution.

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

Pricing is reasonable for small organizations, but the scaling increases the price.

For larger organizations that would be using enterprise solutions, it contains some hidden costs.

What other advice do I have?

It's suited for small organizations, but if someone from a larger organization is looking for this, they might have some problems implementing enterprise-wide solutions. This is because of the integrations, as there would be hidden costs to it.

The best parts of this solution are the costs and that it is easy to use, but the cons would be with implementing an enterprise-wide solution. There are many hidden factors, such as costs. Also, you have to put more effort into integrating with other solutions across the enterprise.

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