Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Engineer at a hospitality company with 1,001-5,000 employees
Real User
The High Availability feature provides us with failover if a node becomes unavailable, but it lacks realtime data refresh in SSRS.

What is most valuable?

It's a solution that's always on.

How has it helped my organization?

It has High Availability, therefore provides failover if a node becomes unavailable.

What needs improvement?

  • Few in SSIS
  • Realtime data refresh in SSRS
  • More datasources in Power BI
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Albeez - PeerSpot reviewer
AlbeezIT Director at DAR AL ARKAN
Real User
PeerSpot user
Infrastructure Analyst / Engineer (24x7) at a tech services company with 501-1,000 employees
Consultant
The user interface can be improved but its always been reliable and consistent, providing tremendous functionality.

What is most valuable?

  • Reliability
  • Ease of use
  • Extensive Knowledge Base to improve and maintain the product

How has it helped my organization?

The majority of the software frameworks utilised by companies I have supported use SQL Server by Microsoft as the application's database management system. It always been reliable and consistent providing tremendous functionality for many years. 

What needs improvement?

The user interface can be improved through the adoption of the intuitive interaction design of the MS Office 2013 applications.

For how long have I used the solution?

 5 years

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

I previously used MongoDB before the stability of innovative products still remains questionable in both theory and practice. 

What was our ROI?

100%.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SQL Server
November 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
824,106 professionals have used our research since 2012.
reviewer1707912 - PeerSpot reviewer
System Analyst and Team Lead at a tech services company with 11-50 employees
Real User
Stable, scalable, and simple installation
Pros and Cons
  • "Many developers like SQL Server."
  • "The solution could improve by having more integration with other operating systems and other platforms."

What is our primary use case?

I am a professional and I use this SQL Server in different companies. One of the companies I worked for was in the automotive industry. They had automobile products which they developed the SQL Server and database. At that time it was the first time I used SQL Server. I have also used Suprema which is a biometric system that also had an SQL Server. Our main products for data we have used SQL Server. However, my main application is developed on Oracle and MySQL, not any other database solution.

All of our systems use this solution, it can control security, data management, and integration. 

What is most valuable?

Many developers like SQL Server.

What needs improvement?

The solution could improve by having more integration with other operating systems and other platforms.

For how long have I used the solution?

I have used SQL Server within the past 12 months.

What do I think about the stability of the solution?

SQL Server is stable.

What do I think about the scalability of the solution?

The solution is scalable.

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

I have used MySQL.

How was the initial setup?

If you follow the restoration policy, the installation is not a problem. If you want connectivity in the application then you have to open the ports and configure them. Otherwise, I'm very pleased it is very simple.

What about the implementation team?

I can do the implementation myself.

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

SQL Server is under a license from Microsoft.

What other advice do I have?

I would not recommend this solution.

I rate SQL Server a six 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
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: 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
Anteneh Asnake - PeerSpot reviewer
Modern Data Center and Cloud Engineer II at IE Network Solutions PLC
MSP
Easy to use, scalable, and good technical support
Pros and Cons
  • "The solution is easy to use."
  • "The performance could improve."

What is our primary use case?

We use the solution for managing our database functions.

What is most valuable?

The solution is easy to use.

What needs improvement?

The performance could improve.

For how long have I used the solution?

I have been using the solution for approximately four years.

What do I think about the stability of the solution?

I have found SQL Server stable.

What do I think about the scalability of the solution?

I have found it to be scalable.

How are customer service and technical support?

The technical support is good from Microsoft. We have four people that do the maintenance of the solution.

How was the initial setup?

The initial setup is straightforward, it took approximately one hour.

What about the implementation team?

I did the implementation myself.

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

There is a license required for this solution.

What other advice do I have?

I would recommend this solution to others.

I 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
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
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: 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: November 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.