Try our new research platform with insights from 80,000+ expert users
PeerSpot user
SAP NetWeaver Implementer at a tech services company
Consultant
With it, we've been able to tune individual queries by optimizing the database server, but the speed is inconsistent.

What is most valuable?

It allows for performance tuning to maximize performance. With the enhancements to the tuning wizard indexes are added to the needs of the system structure and use. I find this helps prevent locking of the system.

How has it helped my organization?

It cuts down on the variable speed of queries, and individual queries can be tuned by optimizing the database server.

What needs improvement?

The speed is inconsistent.

What was my experience with deployment of the solution?

N/A

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.
842,592 professionals have used our research since 2012.

What do I think about the stability of the solution?

N/A

What do I think about the scalability of the solution?

N/A

How are customer service and support?

Customer Service:

N/A

Technical Support:

N/A

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1162596 - PeerSpot reviewer
Data Analyst at a healthcare company with 10,001+ employees
Real User
Useful online community, helpful support, and powerful
Pros and Cons
  • "SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful."
  • "SQL Server backups could be better."

How has it helped my organization?

SQL Server has helped us make better decisions through the queries that we have built.

What is most valuable?

SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful.

What needs improvement?

SQL Server backups could be better.

For how long have I used the solution?

I have been using SQL Server for approximately three years.

What do I think about the stability of the solution?

SQL Server is a stable solution.

What do I think about the scalability of the solution?

I have found SQL Server to be scalable.

The solution is suitable for all-sized businesses.

How are customer service and support?

The technical support from SQL Server is quite good.

How was the initial setup?

I was satisfied with the implementation of the solution.

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

The price of SQL Server is great. In my company, SQL Server is part of the Microsoft Suite, we don't have to pay for any additional license costs, it's quite cost-effective for us.

What other advice do I have?

My advice to others is SQL Server is a good tool to work with and there are a lot of community resources available to help you out in case you are stuck anywhere.

I rate SQL Server a ten 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
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.
842,592 professionals have used our research since 2012.
reviewer1561038 - PeerSpot reviewer
Chief Technology Officer at a financial services firm with 11-50 employees
Real User
Stable, simple installation, but scalability could improve
Pros and Cons
  • "The initial setup was straightforward."
  • "I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."

What is our primary use case?

The main use of this solution is to control and manage data storage information.

What needs improvement?

I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server.

For how long have I used the solution?

I have been using the solution for approximately two years. 

What do I think about the stability of the solution?

The solution is stable. 

What do I think about the scalability of the solution?

I find the solution not to be scalable. 

There are approximately six people in our company using SQL Server.

How are customer service and support?

I have not needed to contact technical support.

How was the initial setup?

The initial setup was straightforward. 

What about the implementation team?

I did the implementation of the solution myself, it does not require any consultants or integrators.

What other advice do I have?

I rate SQL Server a six out of ten. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Managing Partner at Veribir Ltd
Real User
Easy to manage, stable and scalable
Pros and Cons
  • "SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based."
  • "The solution could improve by being more user-friendly."

What is our primary use case?

We are using SQL Server for internal development projects.

What is most valuable?

SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.

What needs improvement?

The solution could improve by being more user-friendly.

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?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable, we have found it to be vertically scalable, but horizontal scaling, we have not used it for this purpose.

We are mostly using this solution for internal use, not for public services. We have approximately 10 developers using it.

How are customer service and technical support?

My experience with technical support has been an average level of satisfaction.

How was the initial setup?

The installation is easy.

What about the implementation team?

We have one individual that is managing the solution at this time.

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

For our purpose, we are not required to have a license for what we are using it for.

What other advice do I have?

I would recommend this solution to developers who are familiar with Microsoft's platform. However, for others who work with Linux-based solutions, I could recommend something else.

I rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1489908 - PeerSpot reviewer
Systems Engineer at a tech services company with 11-50 employees
Real User
Stable, easy to use, and offers a quick deployment
Pros and Cons
  • "The installation is pretty straightforward."
  • "The pricing of the product could be better."

What is most valuable?

Right now, we are using DB2 and the SQL Server. It's really helpful for the replication of data. It's real-time and very easy to use.

The product is very stable. We find it to be reliable.

The scalability is okay. 

The installation is pretty straightforward.

What needs improvement?

For now, we've found the features to be sufficient. I cannot recall feeling anything is actually missing.

The pricing of the product could be better. They could make it more reasonable or more competitive.

Microsoft's technical support could be better.

For how long have I used the solution?

We've been supporting these servers for a couple of years at this point. It's likely been about two or so years. We've worked with them for a while. 

What do I think about the stability of the solution?

The solution is very stable and reliable. There are no bugs or glitches. It doesn't crash or freeze. We're happy with it.

What do I think about the scalability of the solution?

The scalability potential depends on the resources. If the resources are enough, we can scale it. For us, it's already enough. However, if a company plans to expand, it should be prepared for that beforehand. 

We have more than ten users on the solution currently.

How are customer service and technical support?

Microsoft technical support could be improved upon. They aren't the best. They could always be better.

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

We also use IBM DB2. We support it for our customers.

How was the initial setup?

We have found the solution to be straightforward. It's not overly difficult or complex. A company shouldn't have any issue with implementation.

The product implementation process depends on the needs of the client. For us, deployment was around 30 minutes to one hour. It's pretty quick.

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

The solution could be priced more competitively. We'd, of course, like it to be lower. Microsoft can sometimes be expensive.

Each customer needs their own license.

What other advice do I have?

We use the solution both on the cloud and on-premises. 

I'd rate the solution at a nine out of ten. We've been pleased with its capabilities overall.

I would recommend the solution to other users and companies. They should know that it is very easy to use. 

We had two people that handled the initial setup - an engineer and a manager. It's pretty easy to handle if an engineer is doing the setup.

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
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1564890 - PeerSpot reviewer
Head of Data Analytics at a tech services company with 11-50 employees
Real User
Affordable, easy to use and democratic in the enterprise; scalability could be improved
Pros and Cons
  • "Very easy to use, and it's very democratic in the enterprise."
  • "Scalability of the database could be improved if it could handle increased volumes of data."

What is our primary use case?

Our primary use case is for data mart and data warehousing. My company is a service company and we provide the professional services for deployment of BI solutions. We are customers of SQL Server and I'm head of data analytics.

What is most valuable?

This solution is very easy to use, and it's very democratic in the enterprise. A lot of customers use this type of database, and that's why the deployments are very often in the medium enterprise.

What needs improvement?

I think the scalability of the database could be improved if it could handle increased volumes of data. I'd also like to see improvement in performance when you are loading big amounts of data. Integration with other solutions would be a nice additional feature. 

For how long have I used the solution?

I've been using this solution for 10 years. 

What do I think about the stability of the solution?

The solution is very stable. 

What do I think about the scalability of the solution?

The solution is scalable to a point but not for very large enterprise. 

How are customer service and technical support?

I don't have too much contact with the support at Microsoft, but as far as I know, it's good.

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

This is a very affordable solution, which is why it's used so widely in the market. I think one of the strongest points of SQL Server is the reasonable cost.

What other advice do I have?

The value of this solution depends on the business case that you're trying to accomplish and company size, and it depends on the volume of data you're looking for and the type of users that you're trying to serve. Basically, it depends on everything that goes with the functional requirements of the solution. If all that works then I would recommend this product.

I rate this solution a seven out of 10. 

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
Information Security Engineer at a security firm with 11-50 employees
Real User
User-friendly interface, stable, and easy to install
Pros and Cons
  • "The most valuable feature is easy installation. It was very easy to install."
  • "I would like to see more integration with other products and it needs to be more secure."

What is most valuable?

The most valuable feature is easy installation. It was very easy to install.

The interface is very user-friendly.

What needs improvement?

I would like to see more integration with other products and it needs to be more secure.

For how long have I used the solution?

I have been using SQL Server for two months and I believe that we are using the latest version.

What do I think about the stability of the solution?

It's a stable solution. It's very stable.

What do I think about the scalability of the solution?

It is a scalable solution.

My installation requires SQL Servers, so I have to continue using them.

How are customer service and technical support?

I have not contacted technical support.

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

Previously, we did not use another product.

How was the initial setup?

The initial setup was straightforward. The installation was easy.

It took two hours to deploy.

What about the implementation team?

I completed the implementation myself.

What other advice do I have?

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

I would rate SQL Server 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
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.