Try our new research platform with insights from 80,000+ expert users
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.

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

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
Girish Kumar. - PeerSpot reviewer
Consultant at Botmantra
MSP
Reliable, scalable, and easy installation
Pros and Cons
  • "The installation is really easy."
  • "I would like to see the integration with other platforms improved in the future."

What is our primary use case?

We use the solution for managing database information from our clients and for testing database access.

What needs improvement?

I would like to see the integration with other platforms improved in the future.

For how long have I used the solution?

I have been using the solution for four months.

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 have found the solution to be scalable.

How was the initial setup?

The installation is really easy.

What other advice do I have?

I would recommend this solution to others and we are going to continue using it.

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
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,562 professionals have used our research since 2012.
Enterprise Solutions Department Manager at Smart Vision
Real User
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
reviewer1556808 - PeerSpot reviewer
ASM at a healthcare company with 51-200 employees
Real User
A relational database management system that's easy to use, but performance could be better
Pros and Cons
  • "SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
  • "Performance could be better. But I don't know if it's a problem with my application or with my database."

What is our primary use case?

It's a database that we use for our commercial applications, and our ERP sits on it.

What is most valuable?

SQL Server is definitely easy to use, and with the volume that we have, it's also stable.  Maintenance is much easier compared to other products. I may not be comfortable with Oracle because I don't have much experience with it. But in this case, SQL Server is much better for me. 

What needs improvement?

Performance could be better. But I don't know if it's a problem with my application or with my database. Maybe it can have the capability, but I may not be using it to the extent that it could be used, or the configuration is not as per the standard.

For how long have I used the solution?

I've been using SQL Server for over ten years.

What do I think about the stability of the solution?

SQL Server is a stable solution.

How was the initial setup?

The initial setup is very easy.

What about the implementation team?

I implemented this solution by myself.

What other advice do I have?

I would recommend this solution to potential users. If they have their own in-house team, they can manage it very easily. Microsoft is always easy to manage. It's a product where no expert is required for its maintenance.

On a scale from one to ten, I would give SQL Server a seven.

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
PeerSpot user
Software Engineer at a tech services company with 10,001+ employees
Real User
Stable, user-friendly interface, and good community support
Pros and Cons
  • "The interface is user friendly."
  • "Better integration with other platforms would be an improvement."

What is our primary use case?

We use SQL Server to store, retrieve, and manage data.

What is most valuable?

This product works well, serving as our operational database.

The interface is user friendly.

What needs improvement?

Better integration with other platforms would be an improvement.

For how long have I used the solution?

I have been using SQL Server for almost two years.

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?

This is a scalable product. It is being used in three or four projects with a total of between 50 and 100 people.

How are customer service and technical support?

I have not been in contact with technical support for this project, but we use the Microsoft communities to get answers to questions that we have. For example, we have checked the settings to make sure that we are safe.

Overall, the support is pretty good.

How was the initial setup?

The initial setup is definitely straightforward and can be completed within a couple of minutes.

What about the implementation team?

The installation and initial setup were completed by our admin team. However, there are some drivers and additional components that I installed myself.

What other advice do I have?

We always like to work with the best products, we are happy with SQL Server, and I recommend it.

I would rate this solution 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
PeerSpot user
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
Vendor
Enables us to convert to bigger DBs and more easily move or upgrade between branches
Pros and Cons
  • "Enables us to convert to bigger DBs and more easily move or upgrade between branches."
  • "From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week."

How has it helped my organization?

All our main DBs run on SQL.

What is most valuable?

Ability to convert to bigger DBs. It makes it easier to move or upgrade between branches.

What needs improvement?

From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

No issues with stability.

What do I think about the scalability of the solution?

No issues with scalability.

How is customer service and technical support?

Have not used tech support.

How was the initial setup?

Straightforward.

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

Plan ahead, and make sure do not pay for something you are not going to fully use.

What other advice do I have?

Naming conventions are very very important. Make sure that your principle and mirror servers have the same disk space from the outset.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
DBA de Desenvolvimento at a tech services company
Consultant
Review about SQL ServerGreat product. Like any software, a good and prepared staff is the key to success

What is most valuable?

The way the product shows the execution plan and the facility to the developer and tests the SQL code.

How has it helped my organization?

The product is used in the core systems. It has been used since the beginning.

What needs improvement?

Better execution plans and better debugging.

Improved dependency of use of temporary tables to reach good performance in complex SQL.

For how long have I used the solution?

I've used this solution for six years.

What do I think about the stability of the solution?

Sometimes the cross-database performance isn't the best.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

An eight out of 10.

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

I have used Oracle and I also use IBM DB2. All of them have pros and cons.

How was the initial setup?

No.

What other advice do I have?

Great product. Like any software, a good and prepared staff is the key to success.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user231318 - PeerSpot reviewer
Associate Consultant with 501-1,000 employees
Vendor
​It has enhanced our real time decision making capabilities but SSRS could include some ad hoc reporting.

What is most valuable?

There are lots of features including the analysis, database, and reporting, services. We use it mainly for reporting and analysis purposes.

The components I use are -

  • SSAS 8.5/10
  • SSIS 8/10
  • SSRS 7/10

How has it helped my organization?

It has enhanced our real time decision making capabilities. It ensures we are up to date regarding our customers buying behaviour.

What needs improvement?

  • SSRS should have more capabilities in terms of more ad hoc reporting
  • SSAS multi-dimensional expression queries should be more simple

For how long have I used the solution?

I've been using it for the last five and a half years.

What was my experience with deployment of the solution?

With the latest version, it's very easy and intuitive.

What do I think about the stability of the solution?

We had a stability issue with the SSRS component when we deployed it into the production environment.

What do I think about the scalability of the solution?

Not much of an issue to date.

How are customer service and technical support?

Customer Service:

9/10.

Technical Support:

9/10.

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

We were using a solution from Informatica for ETL purpose, which was 8.5/10, but now we are doing it through SSIS, because it is easy to use and its cost.

How was the initial setup?

The migration was, as always, a hard job, but we were able to migrate successfully.

What about the implementation team?

We implemented it in-house.

What was our ROI?

We are pleased with the level of our ROI.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
GaryM - PeerSpot reviewer
GaryMData Architect at World Vision
Top 5LeaderboardReal User

Re. SSRS for adhoc reporting, I would argue SSRS was not meant for adhoc reporting - that's the purpose of PowerBI and Excel PowerPivot. The people who use SSRS should be data consumers who want specific formats whereas adhoc reporting is data explorers who will want a different tool. One size never fits all with any vendor and this is not exception.

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.