We changed our name from IT Central Station: Here's why
IT Service Manager at a financial services firm with 1,001-5,000 employees
Real User
Top 5Leaderboard
Easy to set up, very stable, and quite scalable
Pros and Cons
  • "The solution has proven to be very stable."
  • "The solution could offer more integration with other platforms."

What is our primary use case?

We primarily use the solution for our banking database.

What is most valuable?

Overall, it's a very good device.

The solution has proven to be very stable.

The scalability potential is very high.

The initial setup is very straightforward and the deployment happens very quickly.

What needs improvement?

The solution could offer more integration with other platforms.

For how long have I used the solution?

I've been using the solution for about ten years or so. It's been about a decade. It's been a while. 

What do I think about the stability of the solution?

The product is very stable, from my experience. It doesn't crash or freeze. There are no bugs or glitches. I've used it for ten years with very few issues. The performance and reliability are very good.

What do I think about the scalability of the solution?

The solution can scale quite well. If your company needs to expand it, it can do so pretty easily. It's not hard.

We currently have 5,000 users on the solution.

We do plan to increase usage in the future.

How are customer service and technical support?

We've dealt with Microsoft technical support in the past and we were very satisfied with the level of service provided to us. They are knowledgeable and responsive. 

How was the initial setup?

The initial setup is straightforward. I wouldn't describe it as difficult or complex. It's actually very simple. A company shouldn't have too much trouble with the implementation.

The deployment was fast and barely took two days.

We have five people on staff who can handle the deployment and maintenance for us. They are administrators and engineers.

What about the implementation team?

We had a consultant that assisted us with the implementation. They were very helpful and made the implementation very simple.

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

We pay a yearly license to Microsoft. I can't speak of the exact cost, however.

What other advice do I have?

We're likely using the latest version of the solution.

I'd rate the product at a nine out of ten. We have been very satisfied with its capabilities over the last decade.

I'd recommend the solution to other users and 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.
Flag as inappropriate
ICT Consultant at a tech services company with 11-50 employees
Real User
Top 5Leaderboard
Stable, easy to use, and simple to deploy
Pros and Cons
  • "The product can scale if a company needs it to."
  • "The solution could be more secure."

What is our primary use case?

We have used it in a variety of ways, including for e-commerce deployments. 

What is most valuable?

The solution is easy to use.

The deployments are very easy.

Technical support is very helpful.

The product can scale if a company needs it to.

The stability is quite reliable. 

What needs improvement?

The product can cost a bit, however, it depends on how you use it. 

The solution could be more secure.

For how long have I used the solution?

I've used the solution over a number of years. I may have started originally around 2000. It's likely been two decades or so.

What do I think about the stability of the solution?

The product is quite stable. there are no bugs or glitches. it doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

You can scale this solution if you need to. It's not an issue. 

Everyone in our company is using the product. We have about 80 users on it currently.

How are customer service and technical support?

Technical support has been helpful and responsive. We have no complaints. We are satisfied with the level of service provided to our company.

How was the initial setup?

The solution is very easy to deploy. It's not a problem.

The amount of time it takes to deploy depends on what you want the solution to do for your company.

What about the implementation team?

We have an installer available to us that can guide us through the process and help us choose the right options. 

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

The solution can get expensive. You do need to pay a licensing fee in order to use it. I can't speak to the exact costs. There are different subscription types and the subscription a company needs depends on the deployment they have in mind.

What other advice do I have?

I've used the solution on a couple of deployments and also deploy patches. 

I'd rate the solution at an eight out of ten.

I would recommend the solution to other organizations and companies. 

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?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
564,599 professionals have used our research since 2012.
Network Engineer at a pharma/biotech company with 1,001-5,000 employees
Real User
Top 5Leaderboard
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: I am a real user, and this review is based on my own experience and opinions.
Manager at a pharma/biotech company with 10,001+ employees
Real User
Top 10
Feature-rich, stable, scalable, and easy to install
Pros and Cons
  • "There is no lack of features."
  • "The agility of the non-SQL-based features is relevant on the market."

What is our primary use case?

We have hundreds of databases that are using SEL Server and there may be other capabilities.

What is most valuable?

It's a standard product that is used with standard applications, which is why we use it.

There is no lack of features.

What needs improvement?

There are newer models that are available on the market. The agility of the non-SQL-based features is relevant on the market.

Integration is one thing but it's making use of all the iterations or the new cloud data result.

Today's architectures are in many different directions. Not always via SQL relational databases, but also NoSQL databases, and they have a pretty good Java database as well.

For how long have I used the solution?

We have been using SQL Server in our organization for 10 years, but I am not a day-to-day user.

We use a couple of the versions. We have used the 2016 version and most likely have used some newer versions as well.

What do I think about the stability of the solution?

SQL Server is a stable product.

What do I think about the scalability of the solution?

We don't have any issues with the scalability of SQL Server.

We have hundreds of thousands of applications using this solution.

How are customer service and technical support?

We have a dedicated Microsoft account team and we have also dedicated support conditions.

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

Areas in our organization use AWS Lambda.

We use other relational databases. The most important product besides SQL Server is Oracle. We use SQL Server and Oracle equally.

How was the initial setup?

I am not a patient person with installations, but there are no issues with the installation of this solution.

We have a database team to maintain this solution along with an engineering team, an operational team and we have eternal resources.

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

The enterprise-level license agreement is very complicated. It's complex, not only with SQL server but with a number of products.

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?

Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Michael Ndwiga
IT Officer at a manufacturing company with 201-500 employees
Real User
Top 5
Easy to set up with ample online documentation to resolve issues independently
Pros and Cons
  • "Stability and usability, which is quite simple, are two of the solution's most valuable features."
  • "The solution could be better when it comes to security."

What is our primary use case?

While we were still using the solution, we employed version 2008, which is a bit on the old side. 

We basically used the solution for hosting the database for Sage ERP.

What is most valuable?

Stability and usability, which is quite simple, are two of the solution's most valuable features. 

What needs improvement?

The solution could be better when it comes to security. 

The solution is part of Windows services, which means that if these should stop running, the database system, too, would be affected. This makes it very crucial to constantly monitor the SQL Server, something which reflects on cheap personnel time. 

Scalability could be better.

Although it comes with a cost, using the most recent version is highly advisable, since it would ensure a certain measure of bug fixes and stability. The sole issue would involve the cost, as this is expensive. 

When it comes to integratable features, the monitoring should be addressed. 

For how long have I used the solution?

We used SQL Server for nearly six years, although we have since moved to another platform. We have used the solution at some point within the last 12 months. 

What do I think about the stability of the solution?

The solution has good stability, although my advice is to use the most recent version towards this end, to provide for bug fixes. This will ensure some stability. 

What do I think about the scalability of the solution?

The scalability could be improved. 

How are customer service and support?

As support would have involved a licensing fee, we opted not to make use of this. 

We find there is ample documentation online to allow us to resolve issues through independent research.

How was the initial setup?

The initial setup was straightforward.

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

Although it comes with a cost, using the most recent version is highly advisable, since it would guarantee a measure of bug fixes and provide some stability. The pricing is expensive, though, this being the sole issue. 

We chose not to make use of support, as this would have incurred a licensing fee. 

What other advice do I have?

I rate SQL Server as 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.
Flag as inappropriate
ITCS user
CTO at a tech services company with 11-50 employees
Real User
Top 5Leaderboard
Reliable and easy to use with good technical support
Pros and Cons
  • "The solution is very common. It's easy to use."
  • "The solution is expensive. The licensing costs are high."

What is our primary use case?

The solution is primarily used as a relational database. It's a great option for anyone who needs to still use a database.

What is most valuable?

The solution is very common. It's easy to use.

The product offers a lot of support. Technical support has been great.

It's a reliable solution currently in this space.

The solution doesn't take a long time to set up. It's pretty straightforward. 

What needs improvement?

The solution is expensive. The licensing costs are high. 

For how long have I used the solution?

I've been dealing with the solution for 20 years or so. It's been two decades. I've used it for a while. 

What do I think about the stability of the solution?

The stability is pretty good. I find it to be reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is good.

What do I think about the scalability of the solution?

We have 150 users on the solution currently.

How are customer service and technical support?

I've contacted Microsoft technical support in the past and have been satisfied with the level of service I get. They're good.

How was the initial setup?

We have a special database team that is running. Except for the initial installation of the hardware, they are doing everything as it's an in-house solution.

It took a day or two to implement. It might have even taken less time. 

What about the implementation team?

We have a team that can manage the implementation process. 

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

The licensing is a bit expensive. We'd like them to be more flexible in terms of costs.

We pay a yearly licensing fee.

Which other solutions did I evaluate?

We did not evaluate other solutions before implementing this solution. 

What other advice do I have?

I'm using either the 2018 or 2019 version of the solution. I don' know the exact number off-hand.

I'd rate the solution at an eight out of ten. It's a very good solution and I've been pretty happy with its capabilities. 

I would recommend the solution to other users.

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.
Flag as inappropriate
Chief Information Officer at a financial services firm with 501-1,000 employees
Real User
Good SSMS and profiling tools that work well for internal applications
Pros and Cons
  • "I like that the new version has a memory-optimized table to improve the performance."
  • "I would like to see the performance improved. Migrating should be easier and the scalability needs improvement."

What is our primary use case?

We use SQL Server for our internal applications.

What is most valuable?

Working with SQL Server, it is quite convenient to use the SSMS tools to write a profile. I also like the profiling tools.

I like that the new version has a memory-optimized table to improve the performance.

What needs improvement?

We had some difficulty doing the performance tuning when we migrated from the 2008 version to the 2016 version. We experienced a drop in the performance. We could not understand or figure out what caused the drop in performance. We did not change any settings to cause this effect. We tried to keep the same settings.

We feel that when running the 2008 version, it was much quicker in terms of performance. 

That is an area of SQL Server that can be improved. Moving to a new version, you shouldn't have to change the configuration.

We have not been able to utilize it fully because it is not straightforward.

I would like to see the performance improved. Migrating should be easier and the scalability needs improvement.

For how long have I used the solution?

I have been using this solution for many years. 

We are using version 2016.

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?

In terms of scalability, it has some room for improvement.

We have 20 people in our organization who are using this solution.

How are customer service and technical support?

We don't usually get support from Microsoft. We get it from our software vendors or we try to do it ourselves.

We are somewhat satisfied with the support that we have received from the vendor, but not fully because of the issue we faced when we moved to a newer version. But in other areas, it's okay.

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

We have used SQL Server from the beginning.

How was the initial setup?

The initial setup was moderate. It was not easy but it was not difficult.

What other advice do I have?

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.
OmidKoushki
Solution Architect at KIAN company
Real User
Top 5Leaderboard
Highly scalable, easy to use, but better performance and monitoring needed
Pros and Cons
  • "The solution is very easy to use."
  • "SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable."

What is our primary use case?

I have been working on SQL Server for installations, configuring for developers, and for creating backup jobs from the MBF files.

What is most valuable?

The solution is very easy to use.

What needs improvement?

SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable.

For how long have I used the solution?

I have been using this solution for approximately three years.

What do I think about the stability of the solution?

I have found the SQL Server stable.

What do I think about the scalability of the solution?

The solution is highly scalable. You are able to implement a SQL cluster mechanism for replicating the data between two nodes of the SQL Server. If one of the nodes is down the second node becomes active.

We have approximately 20 developers working directly with SQL Server and approximately 1,000 end-users that are working on the application that is behind the SQL Server.

How are customer service and technical support?

The technical support is good. We had a big problem and after an investigation, we could not find the solution. We needed to make use of Microsoft support team and open a specific case on the Microsoft panel. They were able to provide solutions for solving this issue.

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

I have used MySQL.

How was the initial setup?

The installation is not very complex. However, the process could take a long time because you have to follow the step-by-step instructions for the installation. The time it takes to do the installation is approximately two days.

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

There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford.

What other advice do I have?

I would recommend this solution to others.

I rate SQL Server a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate