Try our new research platform with insights from 80,000+ expert users
reviewer1410678 - PeerSpot reviewer
Data Analyst at a tech company with 51-200 employees
Real User
Flexible, stable, with good report and data analysis capabilities
Pros and Cons
  • "It's a flexible solution."
  • "The installation process should be simplified."

What is our primary use case?

I use this solution as our data warehouse. 

We use the reports, data analysis, and for connecting our databases to multiple resources.

What is most valuable?

It's a flexible solution.

What needs improvement?

The installation process should be simplified.

The configuration could be easier.

For how long have I used the solution?

I have been using SQL Server for a couple of months.

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?

It's a stable solution. We have no issues with the stability.

What do I think about the scalability of the solution?

We have 10 users in our organization who are using this solution.

We have a team made up of engineers, data analysts, and some developers to maintain this solution.

We have plans to increase your usage.

How are customer service and support?

We have not contacted technical support.

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

Previously, I was using MySQL.

How was the initial setup?

The installation is not easy, it could be easier.

It can take many hours to configure it.

What about the implementation team?

I completed the installation myself.

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

It's a bit expensive.

The licensing is expensive.

What other advice do I have?

I would recommend SQL Server to others.

I would rate SQL Server an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Intelligence and Decision Support Team Leader at a university with 1,001-5,000 employees
Vendor
We’ve been using SQL Server for 17 years

What is most valuable?

It’s easy to develop and learn for newbies, and community MVP’s are so powerful and qualified, so info is easily accessible.

Also, SQL Server is not only a DBMS solution anymore, it is also a BI platform, and improvements are being made continuously.

How has it helped my organization?

SQL Server is our main RDBMS for SIS (Student Information System) and also our DWH, which are hosted on our SQL Server.

What needs improvement?

Version management, editor capabilities, CDC (change date capture), and some advanced analytic functions should be added; continuous integration solutions.

For how long have I used the solution?

I’ve been developing with MS SQL Server for nearly 20 years, since Version 6.5.

What do I think about the stability of the solution?

Not in this version.

What do I think about the scalability of the solution?

Yes, we did, with the 2008 version.

How are customer service and technical support?

We have a yearly technical support agreement with a major partner. Consultant meetings are a requirement.

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

No. We’ve been using SQL Server for 17 years.

How was the initial setup?

We’ve been using AlwaysOn availability groups for three years. It took a while to model the structure, but now it is stabilized, and safe with disaster recovery and failover configurations.

Which other solutions did I evaluate?

It was years ago, so it’s not relevant info anymore.

What other advice do I have?

Database modeling and indexing best practices are so important. Do not defer to implement these practices. Before installation, planning different file groups for temp, data, and index files will help to gain performance and maintenance advantages.

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