Try our new research platform with insights from 80,000+ expert users
reviewer1624716 - PeerSpot reviewer
2de Solution Engineer - storage & compute at a financial services firm with 10,001+ employees
Real User
Scalable and stable with good overall performance
Pros and Cons
  • "The scalability of the product is great."
  • "The licensing is pretty expensive."

What is our primary use case?

We primarily use the solution mainly for databases on all types of applications.

How has it helped my organization?

SQL is the all around leading Database server

What is most valuable?

The solution is very stable. 

The scalability of the product is great.

What needs improvement?

We'd like the deployment process to be better in the future. 

The licensing is pretty expensive.

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

For how long have I used the solution?

I've been using the solution for 20 years at this point. It's been two decades. We've used it for a while now.

What do I think about the stability of the solution?

The solution is stable and the performance is great. 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 do so.

We have 900 to 1,000 people using it currently.

How are customer service and support?

I'm more on the architecture side and therefore do not directly deal with technical support. I cannot speak to how helpful or responsive they are.

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

We also use Oracle. We've used it for over a decade already.

How was the initial setup?

The deployment could be easier.

While the deployment only takes about 15 minutes, you have to follow up with a lot of configuration.

What about the implementation team?

We handled the implementation ourselves. We did not enlist the assistance of any integrators or consultants. It was all handled in-house.

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

We're paying too much for licensing at this time. They need to work on the pricing. They could be cheaper, however, it's also difficult to run the licenses in the right way.

We pay licensing fees on a yearly basis. 

What other advice do I have?

We're a customer and an end-user. We don't have a business relationship with SQL. 

While everything is currently on-premises, we're making moves to shift to the cloud. 

We're using the 2019 and 2016 versions of the product.

I'd rate the solution at an eight out of ten. In general, we've been quite happy with its capabilities.

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
reviewer1428423 - PeerSpot reviewer
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Integrates well, high performance, and provides many features
Pros and Cons
  • "SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
  • "They could improve by adding the SQL format."

What is our primary use case?

This solution is part of the ERP that we have for application. We use it for many purposes, such as POS in-store cash registers for enterprise companies.

What is most valuable?

SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well.

What needs improvement?

They could improve by adding the SQL format.

For how long have I used the solution?

I have been using SQL Server for approximately eight years.

What do I think about the stability of the solution?

The solution is stable, I have not had any issue using it.

What do I think about the scalability of the solution?

The scalability is very good.

We have approximately 500 users using the POS.

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

I have previously used IBM Informix, PostgresSQL, and Oracle Databases.

How was the initial setup?

The installation is straightforward and takes approximately 30 minutes. If you were to add more features the installation could take longer. For example, there are many features such as table partitioning allowing you to do queries faster, transferring data from one table to another, and performing quicker backups.

What about the implementation team?

We did the implementation ourselves. We have a team that does the maintenance for Windows Servers, Linux desktops, and Linux Servers.

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

There is a license required for servers and for the POS we use the free version. The free version allows you to have tables and a total database size of approximately 10 GB, which is enough for our requirements.

What other advice do I have?

This is an excellent solution when it comes to databases. I would recommend it to others.

I rate SQL Server a ten 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
SQL Server
October 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
Ryan Dave Brigino - PeerSpot reviewer
Software Engineer at Es'hailSat
Real User
Top 5Leaderboard
Easy to use, with good performance but could have better pricing
Pros and Cons
  • "The performance is good."
  • "The pricing in general could be better."

What is our primary use case?

The solution is primarily used for studying data and statistics. We have some services that we are monitoring and keeping records and doing reports, and we use it for that.

What is most valuable?

The solution is quite stable.

The solution has the capability of scaling.

The performance is good. 

It's very easy to use.

What needs improvement?

The solution was delivered to us, and we really don't interface with the solution directly. I can't speak to any features that are missing.

The only people that can use it directly are developers. It's not for everyday users.

The pricing in general could be better.

For how long have I used the solution?

We've used the solution for about five years or so. It's been a while.

What do I think about the stability of the solution?

The solution is stable. It's reliable. We do not deal with bugs or glitches. It doesn't crash or freeze.

What do I think about the scalability of the solution?

The solution can scale, however, it's dependant on the hardware. It's not limitless.

There are about ten users using the solution at this time.

We do have plans to increase usage in the future.

How are customer service and technical support?

We don't interface with Microsoft support. We always go to the vendor that performed the integration for us.

How was the initial setup?

We did not implement the solution. We had it delivered to us.

I've done an installation in the past, however, not at this company. It's straightforward. It's simple due to the fact that it's going to be installed on the Microsoft operating system, not like MySQL that's used on a Linux server.

Deployment may take about 15 minutes or so.

We have a technical team of about eight people that can handle maintenance as necessary.

What about the implementation team?

We had an integrator deliver the solution to us, as we are not ourselves developers.

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

I don't have any details on the licensing in terms of any details or costs. It's not an aspect of the solution I directly deal with.

What other advice do I have?

We are just customers and end-users. We don't have any business relationship with the company.

We use the express edition of the solution.

It was delivered as part of a solution. We are not developers. It was a turnkey solution delivered to us by an integrator, and we are doing some maintenance, however, we are not developing the content of the database. It was used as part of our services for maybe five years or more.

The database is on the back end. We are using it with our applications at the front end that we are interfacing with. In terms of the SQL server, we don't go and use it directly. We use it through the application. There's an application that is providing a user interface for us, and we work on that user interface. We don't work on the native interface of the SQL server.

Overall, I would rate the solution at a seven out of ten. I've heard that Oracle is better.

I'd recommend this solution to other companies.

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
reviewer1494501 - PeerSpot reviewer
BI Developer at a manufacturing company with 1,001-5,000 employees
Real User
A stable and scalable relational database management system
Pros and Cons
  • "The performance is great."
  • "It's difficult to make changes. It's a very complicated product in general — that's the issue."

What is our primary use case?

We use this solution to analyze the profitability of sales.

Within our organization, there are roughly 30 people using the analysis services solution from the Business Intelligence side.

What is most valuable?

The performance can be great. Tuning and understanding SSAS is not straightforward.

What needs improvement?

The issue is that Microsoft is not really supporting the Multi Dimensional Analysis Services feature any longer and it's looking very obsolete. We're looking at replacing it.

SSAS-MD is difficult to make changes. It's a very complicated product in general — that's the issue. It is too complicated for most. It's too difficult to change. It's too difficult!

For how long have I used the solution?

I have been using this product for more than 10 years.

What do I think about the stability of the solution?

This particular product is quite stable. We've not had any particular problems. We've had problems with Microsoft Excel recently, but Analysis Services has been quite stable.

What do I think about the scalability of the solution?

Scalability-wise, it's quite good. It's not scalable up to the big data type of thing that people are doing now. It's scalable up to a point, but it has been overtaken by newer products.

How are customer service and technical support?

We try and avoid calling Microsoft support, generally. That's the truth. We've tried getting support for other products like Power BI — support is an issue.

They're changing their products and they're not stable enough. Analysis Services has been okay, but some of their other products, like Excel and Power BI, are not stable.

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

We're looking at alternative solutions because we think Microsoft's licensing costs have been expensive and multidimensional cubes have been overtaken by other technologies such as in-memory databases and products like Snowflake.

We're looking for a solution that allows us to pay by usage rather than pay by the number of users. We don't want to pay for hardware capacity that we rarely use. I'm looking at several products, including Snowflake, that bill by how much we use the product. I'm not sure if Microsoft is on board with that yet. I was also looking at Qlik — they do a commercial model that is paid by the amount of time. I think paying per usage is a rising trend at the moment.

What other advice do I have?

Overall, on a scale from one to ten, I would give SQL Server a rating of nine. It's generally a good product.

If you're interested in using this solution, my advice is to do your research. It's a good product, but there are other products available.

One of the biggest issues that I have with Microsoft is that they change their products and don't continue to support the old product. We've got some things in Microsoft Excel that are no longer supported. They bring out a new model and they drop support for some of the older features.

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
reviewer1022898 - PeerSpot reviewer
Director at a tech services company with 10,001+ employees
Real User
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
Vice President, Product Engineering at Logitix
Real User
Reliable with good scalability and offers a very high level of performance
Pros and Cons
  • "The solution offers very high performance."
  • "The Task Scheduler has a lot of shortcomings. This could be improved quite a bit."

What is our primary use case?

We primarily use the solution as a relational database system.

What is most valuable?

The solution offers very high performance.

It is a very reliable solution. We find it to be quite stable.

We've found the product to be very scalable, specifically from MSSQL

The product offers various deployment models.

What needs improvement?

The Message Broker portion of the solution is not very scalable in comparison to the rest of the solution. The problem is, you can exclude that portion.

The Task Scheduler has a lot of shortcomings. This could be improved quite a bit.

The enterprise version of the product should be more cost-effective.

For how long have I used the solution?

We've been using the solution for the last 15 or so years. It's been a while. We have a lot of experience with it.

What do I think about the stability of the solution?

The stability of the product is very good. It offers excellent performance. There aren't bugs or glitches. It doesn't crash or freeze. It's reliable.

What do I think about the scalability of the solution?

The solution is extremely scalable. If a company needs to expand, it can do so without any problems.

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

The enterprise version of the solution needs to be priced more competitively.

We have a couple of models. We lease through Azure monthly, which is for the Standard version. We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous.

On top of that, there aren't really any other knock-on costs.

What other advice do I have?

We have experience with almost every angle of Microsoft ecosystem that you could imagine.

We're a direct customer. We own a MSSQL server. We have it deployed both on-premises and on the cloud, so we use different deployment models. We have distinct instances in the cloud and we have distinct instances in our on-prem.

I would warn other organizations to not use their Message Broker and don't rely on their Task Scheduler. Look elsewhere. Go look at Oversource, Rabbit MQ, Azure Message Broker, or something other than what's built into Microsoft's SQL server. That would be my advice.

Our original architecture messaging infrastructure was based on Microsoft SQL server's Message Broker. It's been a complete disaster. It's a black hole that can't be diagnosed or supported in terms of troubleshooting from Microsoft when it doesn't work. When it doesn't work, it just doesn't work and no one can answer why. That is very bad. The intended use of it was for enterprise messaging. However, that is not a use case for MSSQL Message Broker, period. We're in the process of moving in a couple of directions. We're going to move to Azure Service Bus as an interim solution, as our current technical capabilities are very Microsoft-centric. Then, the next step will be to move to other more enterprise-class messaging and queuing subsystems like RabbitMQ.

The SQL server as an engine probably deserves a very high nine out of ten. It's a very, very efficient relational database management system. And it is very scalable.

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?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Owner at BNS
Real User
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 Direcbusiness Technologies, Inc.
Real User
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
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: October 2024
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.