Try our new research platform with insights from 80,000+ expert users
reviewer1430925 - PeerSpot reviewer
Technical Director at a security firm with 51-200 employees
Real User
Stable and easy to install
Pros and Cons
  • "It is stable, and it works okay."
  • "It would be nice if they can reduce its price."

What is our primary use case?

It is used for many things. We primarily use it for our two-tier and three-tier applications.

What is most valuable?

It is stable, and it works okay.

What needs improvement?

It would be nice if they can reduce its price.

For how long have I used the solution?

I have been using this solution for ten years.

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

What do I think about the stability of the solution?

It is stable.

How are customer service and support?

I didn't use their technical support.

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

I have used Microsoft Access.

How was the initial setup?

Its installation is straightforward. It took half an hour to one hour.

What about the implementation team?

I can install it myself.

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

We did a one-time payment. Its price, in general, can be reduced.

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?

On-premises
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
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,067 professionals have used our research since 2012.
reviewer1476273 - PeerSpot reviewer
Manager with 501-1,000 employees
Real User
Popular, works well, and easy to use and deploy
Pros and Cons
  • "It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner."
  • "It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."

What is most valuable?

It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner.

What needs improvement?

It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting.

For how long have I used the solution?

I have been using this solution for more than ten years.

What do I think about the scalability of the solution?

We have around approximately 600 or 700 users of this solution. Currently, everybody is using this solution, and we don't have a plan to increase its usage.

How are customer service and technical support?

We don't have a direct connection with Microsoft support. We have a support partner who is in contact with the official Microsoft support.

How was the initial setup?

Its initial setup is easy.

What other advice do I have?

I would recommend this solution. 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
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
reviewer1491816 - PeerSpot reviewer
Senior Architect at a computer software company with 10,001+ employees
Real User
A user-friendly relational database management system
Pros and Cons
  • "It's more user-friendly than most databases."
  • "The performance could be better."

What is our primary use case?

Our server projects are mostly related to SQL Server, and we're using it. All our healthcare projects are using the SQL Server, and we're able to load millions of data without any issues.

What is most valuable?

It's more user-friendly than most databases. If we don't have to use the command mode, it's very easy.

What needs improvement?

The performance could be better. When we pump in millions of records, we start struggling, and that's why we want improvement in those areas.

For how long have I used the solution?

I have been using SQL Server for more than ten years.

What do I think about the stability of the solution?

In the past, it wasn't stable compared to other products like Oracle Db2, but it has improved, and now it's stable. 

How was the initial setup?

The installation is easy, and performance-wise it's okay now.

What about the implementation team?

SQL Server installation is easy, and we did it by ourselves.

What other advice do I have?

I would recommend this product to new users.

On a scale from one to ten, I would give Microsoft 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
reviewer1484775 - PeerSpot reviewer
Senior Programmer at a tech services company with 51-200 employees
Real User
Easy to set up with good scalability and extensive online documentation
Pros and Cons
  • "The product has very good online documentation that can be used for troubleshooting."
  • "The licensing costs are very high."

What is our primary use case?

We primarily use the solution as a database for business operations.

What is most valuable?

I personally work with Microsoft products and therefore I like the continuity it provides. I like sticking with the brand.

The solution is very stable.

The product has very good online documentation that can be used for troubleshooting.

The solution can scale as necessary.

We've found the setup to be quick and relatively easy.

What needs improvement?

The licensing costs are very high.

I would like the scaling process to be more transparent and obvious.

There's a lot of documentation on the web, and it is quite extensive, and yet it isn't very well organized which makes it hard to find items often.

For how long have I used the solution?

I've been using the solution for a very long time. It's been around ten years or more. I'd say it's been at least a decade at this point.

What do I think about the stability of the solution?

The stability of the solution is quite good. We don't have issues with it. It doesn't crash or freeze. We don't experience bugs or glitches. It's reliable.

What do I think about the scalability of the solution?

While I personally haven't gone beyond 50 or so users, it's my understanding that as long as you pay for the licensing, you can grow as much as you need to. There would be costs involved, however, the solution can scale if a company needs it to. 

I'd love to have Microsoft explain to me the scaling process so that I could better understand it. Right now, I'm in the dark.

How are customer service and technical support?

In terms of technical support, I can say that sometimes I need them. However, it's very difficult to contact Microsoft support for anything. 

In general, they have none. I wouldn't know how to reach them directly for help if I needed it.

Right now they have good support for their Azure product, in the cloud. However, this is not the case for on-premise products. That means, as an on-premise user, I have a problem. That said, since their product is well-known, there's a lot of documents on the web. If I try to search online I will typically find the answers I need. 

How was the initial setup?

The initial setup is not complex. It's pretty straightforward. It takes an hour or less to set everything up. Some people may need a few hours, however, for me, less than an hour was enough. That said, the Windows Server would also take an hour or two to set up as well.

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

The solution certainly comes at a cost, however, for me, it's an acceptable cost. I find it acceptable due to the fact that it would be free if I use MySQL on-premise, however, then it would be hard to hire people to maintain it. It's a give and take. That said, the license cost is very very high. I'm afraid if I use it on a larger scale it will cost a lot.

What other advice do I have?

Currently, we're just Microsoft customers, although we would like to have a partnership with the company in the future.

I haven't done the HA for SQL server yet, therefore, I'm not sure how hard it is and how difficult it would be to implement, or how stable and how scalable it is.

There are two markets really. It's Microsoft and non-Microsoft. If anyone is familiar with Microsoft products, then they should go with this, however, they should bear in mind that it comes at a cost. The SQL cost is quite high if a company is using it at a large scale.

That said, if a company is looking at something small scale, there is a free edition. I use the standard edition, and it won't cost too much. 

In any case, for those that aren't tied to Microsoft options, there are a lot of products out there that might be suitable with very little overhead.

In general, I would rate the solution at 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
Member of the Board & Co-Founder, Executive Manager at Networld Systems
Real User
Good replication and helps to reduce costs
Pros and Cons
  • "The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations."
  • "I would like to have more replication scenarios."

What is our primary use case?

We have a Windows Server environment.

This is a production system for secure document issuing in a government department.

How has it helped my organization?

It helped reduce licensing costs and also running costs, as well as the learning curve.

What is most valuable?

The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.

What needs improvement?

I would like to have more replication scenarios.

For how long have I used the solution?

I have been using this solution for twenty years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user280197 - PeerSpot reviewer
BI Solution Architect at a tech services company with 501-1,000 employees
Real User
The database engine is one of the most valuable components of the platform.

What is most valuable?

The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.

The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.

In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).

One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.

How has it helped my organization?

As an IT Services organization, our companies have used this product in dozens of customer deliveries for solutions such as ERP applications, Data and Analytics solutions, and more. We also use the product internally as the backend for some of our most important operational systems.

What needs improvement?

The user interface to the web frontend of MDS could be more intuitive and the Analysis Services platform has not evolved much in recent times, these are the two things that come to mind.

For how long have I used the solution?

This specific version (2014), I have used for approximately three years. However, I use other versions of the software on a regular basis, such as 2012 and 2016.

What do I think about the stability of the solution?

There were no issues with stability.

What do I think about the scalability of the solution?

There were no issues with scalability.

How are customer service and technical support?

Microsoft has a solid support structure for the SQL Server platform and I’ve always been provided with a good service.

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

We used a combination of RDBMS platforms and we still do in addition to this solution.

How was the initial setup?

The installation and configuration was very straightforward. The full setup typically takes less than one day.

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

The Enterprise license includes features that enrich the product experience as well as performance and scalability options. Choose this over the standard license where possible.

Which other solutions did I evaluate?

We reviewed many RDBMS platforms for suitability depending on the requirements of the customers. We would also use the likes of Oracle 12c and Amazon RDS.

What other advice do I have?

Install a trial version as soon as you can and give it a try.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company (Version 1) is a Microsoft Gold Partner. We are also an Oracle Platinum Partner as well as Amazon, etc.
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.