Try our new research platform with insights from 80,000+ expert users
Raphael Haroun  Ikyagh - PeerSpot reviewer
Network Administrator at Letshego
Real User
Top 5Leaderboard
A stable and straightforward solution that is easy to use and can be deployed quickly
Pros and Cons
  • "The product is easy to use."
  • "The pricing could be better."

What is most valuable?

The product enables us to grant access to users. The product is easy to use.

What needs improvement?

The pricing could be better.

For how long have I used the solution?

I have been using the solution for about four years.

What do I think about the stability of the solution?

We did not have any issues with stability. The tool is stable.

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

What do I think about the scalability of the solution?

The tool is scalable. Four other users have access to the server. We are not planning to increase the usage.

How was the initial setup?

The setup is straightforward. The deployment does not take very long.

What about the implementation team?

We did not use an integrator for the deployment. Our in-house team has been able to deploy the tool well.

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

We pay a yearly licensing fee.

What other advice do I have?

I recommend the solution to others. The solution is straightforward to work with. Overall, I rate the product a nine 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
EverVidal - PeerSpot reviewer
Architect of Solutions at Interbank
Real User
It's an inexpensive solution that integrates well with cloud-based tools
Pros and Cons
  • "SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation."
  • "Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."

What is our primary use case?

I have SQL Server running in an on-premise environment, but we are testing it out on the cloud. We are trying out using APIs to access a database. SQL Server creates a lot of opportunities for us. While some of the larger companies have Oracle, SQL Server is more common in Peru. I'm responsible for administration and implementation, including configuration and data replication.

What needs improvement?

Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems.

For how long have I used the solution?

I have been working with SQL Server for 10 years. 

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

I worked on Oracle Database for four years. In the last year, I have been working with various cloud databases, including Cosmos DB and DynamoDB in AWS and Azure.

What other advice do I have?

I rate SQL Server nine out of 10. SQL Server is an inexpensive solution. I recommend it if the project isn't sensitive. SQL is similar to Oracle and integrates well with tools in the cloud environment. The difference is that Oracle is for data solutions where there is replication and moderation.

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,406 professionals have used our research since 2012.
reviewer1635153 - PeerSpot reviewer
VP Global Information Technology at a insurance company with 10,001+ employees
Real User
A scalable and stable solution with a flawless setup
Pros and Cons
  • "The initial setup is easy, flawless."
  • "I want to see one improvement and this involves the replication between the DC and DR."

What is our primary use case?

We are using the latest version.

We can use the solution for the same application. On the database side we have Microsoft SQL and on the operating system side we have 2019.

What needs improvement?

I want to see one improvement and this involves the replication between the DC and DR. We have limited options at the moment and it does not lend sufficient support for the number of databases. This means we have a huge number of databases, topping approximately 2,000. For the moment, this particular replication is not supported by SQL. 

The support number of databases needs to be increased, as well as the database number of databases that it supports. That support cannot be found when it comes to the replication between the DC and DR. 

For how long have I used the solution?

I have been using SQL Server for ten years. 

What do I think about the stability of the solution?

The solution is sufficiently stable. 

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and technical support?

When it comes to the speed, knowledge and customer-friendliness of the technical support, we feel these to be good. 

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

We did not use other solutions prior to SQL Server. 

How was the initial setup?

The initial setup is easy, flawless. 

It lasts a single day. 

What about the implementation team?

We handed the implementation on our own. 

This involved a technical team of 15 people. 

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

There is a need to pay for the license for SQL Server. We have an enterprise license, which we consider to be fine. 

What other advice do I have?

We have 10,000 customers. 

I would recommend the solution to others. 

SQL Server is good and I rate it as a nine 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
reviewer1570953 - PeerSpot reviewer
Database Administrator at a computer software company with 10,001+ employees
Real User
Very scalable and stable, good support, and works well with Windows Server platforms
Pros and Cons
  • "Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
  • "Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities."

What is our primary use case?

It is used for everything under the sun. We're currently using it for a health pass for a medic aid information management system. It is also used by companies in banking and retail.

We are using SQL Server 2014 on Windows Server 2012 platform, and we also have SQL Server 2016 on Windows Server 2016 platform. I have primarily worked on the hardware, but I am now also working in the Amazon AWS cloud.

How has it helped my organization?

The entire solution that we're deploying is built on Microsoft SQL Server as a database engine. Our solution is completely engineered for that, and if we attempt to deploy it in any other database engine, it is going to be a huge nightmare.

What is most valuable?

Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.

What needs improvement?

Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities.  The native SQL Server Backups take more time than do the backup processes from LiteSpeed, and the backup compression is a little less.  

For how long have I used the solution?

I have been using SQL Server since version 6.5, which came out about 30 years ago.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

It is very scalable. You can run the database engine on the C drive, or you can run it on a large cloud array or a disk array. Currently, we just have developers and testers accessing it.

How are customer service and technical support?

Technical support from Microsoft is very good.

How was the initial setup?

If you know how to set it up, it is easy, but you have to learn that over time. For a new user, it is detailed. You need to have the right things in place at the right time before you actually install the software.

To create an instance, it takes about an hour overall. This includes deploying the basic system, applying the latest service pack, and then applying the latest cumulative update.

What about the implementation team?

It was an in-house job. In terms of maintenance, the number of staff members required would depend on the implementation. It requires coordination amongst teams. It is a team effort. The database administrator creates and runs the jobs that create the backup file. You need to have somebody for copying the backup files to offline storage. You also need to have system administrators for setting up the hardware.

What other advice do I have?

I would advise others to just be familiar with Windows concepts.

I would rate SQL Server a nine out of ten. If you're familiar with Windows concepts, it just works.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
HaiPham - PeerSpot reviewer
Managing Director at sea-solutión
MSP
Top 5Leaderboard
Provides effective security features, but the scalability needs improvement
Pros and Cons
  • "The setup process is straightforward."
  • "The product performance can become slow when the data reaches sizes like a terabyte."

What is most valuable?

SQL Server is easy to use. As a Microsoft product, it has an intuitive and user-friendly interface.

What needs improvement?

The product performance can become slow when the data reaches sizes like a terabyte.

What do I think about the stability of the solution?

The product is stable. 

What do I think about the scalability of the solution?

Our organization has a maximum of 100 SQL Server users. The scalability needs improvement.

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

We have used other solutions such as PostgreSQL, MySQL, and Oracle. 

SQL Server is often chosen for Windows platforms due to its compatibility. For other development environments, like PHP or Java, we might select MySQL or PostgreSQL, respectively.

How was the initial setup?

The setup process is straightforward. It involves running the setup file, configuring general settings, setting up a user account, and creating a database. After that, you can create tables within the database and start using it.

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

The product's price is reasonable. It requires a one-time license purchase, unlike Azure SQL, which operates on a subscription basis.

What other advice do I have?

SQL Server's performance is good enough for medium-sized applications. The security features are adequate and effective.

I rate it a seven out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Balaji E - PeerSpot reviewer
Senior Database Administrator at Torry Harris Integration Solutions
Real User
Top 20
Offers Always On Availability Groups setup, stable product and easy to setup
Pros and Cons
  • "We use it for our on-premises solutions, virtual servers and SSAS, SSRS packages. Also, our applications are .NET based, so it made to use it."
  • "We need it to support Linux for better troubleshooting flexibility."

What is our primary use case?

We use it for both development and administration purposes.  

How has it helped my organization?

It's serving our data solution needs okay. 

What is most valuable?

I like that it's the Always On Availability Groups setup. It ensures our servers are always running.

What needs improvement?

We need it to support Linux for better troubleshooting flexibility.

For how long have I used the solution?

I have been using this product for five years. We currently use the older versions, SQL Server 2019 and 2017.

We will soon migrate to the 2022 version. 

What do I think about the stability of the solution?

It works perfectly. No issues there. 

So, it is a stable product. 

What do I think about the scalability of the solution?

There are around 300 to 500 end users using it. 

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

We use it for our on-premises solutions, virtual servers and SSAS, SSRS packages. Also, our applications are .NET based, so it made sense to use it. 

How was the initial setup?

The initial setup is very easy. It is easy to understand. 

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

It is an expensive product. 

What other advice do I have?

I would recommend using it , but it's best if you already know how it works.

Overall, I would rate the solution 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.
Flag as inappropriate
PeerSpot user
System engineer at a financial services firm with 51-200 employees
Real User
Beneficial querying, scalable, and stable
Pros and Cons
  • "The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features."
  • "If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good."

What is our primary use case?

We provide support services to clients. We find that some of our clients are running the latest system while others are still on Windows 2016, others are moving to 2019. Some other clients take time to upgrade. If I interact with five clients, I'll basically be in five different environments.

Our use case for the SQL Server is for transaction processing. We store all the transactions that occur. For example, if you now purchase something from the point of sale, all the information about the good you are purchasing gets stored on the SQL Server. 

When you perform a transaction that information is stored at the bank that owns the point of sale and perhaps even your bank, where your money is will be stored in a SQL Server.

All the people in all of the organizations, which are involved in the process use SQL Server.

If your transaction goes through my server, I store part of the transaction there, and if I have to route that transaction to Visa or Mastercard, they have their own SQL Server, and they also store the transaction up until you get receive your goods at the particular merchant. Almost everyone in that transaction stores the information on their respective Microsoft SQL server.

What is most valuable?

The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features.

We do not know all the features of SQL Server.

What needs improvement?

If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good.

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?

SQL Server is stable and is a high-performance database. We do hundreds of transactions per second, it's fairly robust, it does not struggle. Mostly, if your hardware is strong enough and you've set it up properly, then you can actually perform a lot of transactions per second on a SQL Serving installation.

What do I think about the scalability of the solution?

The scalability of SQL Server is relatively easy. if you are in a Microsoft environment, then I think that it relatively it should not be that difficult. However, I haven't been on a project whereby we have had to scale.

SQL Server is suitable for all companies in my experience, ranging from small to large enterprises businesses.

How are customer service and support?

I have not dealt much with technical support, because most of the time when we have issues, we go online. If it's a Microsoft issue, then we go and read up what that issue is. If there's an error, then there are places on the Microsoft support system where we are able to enter in the error code and it is able to tell you why you have that problem. As far as dealing or interacting with people or technical support from Microsoft, I have not done that.

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

I use MySQL and when comparing the solutions I have found the SQL Server is much more professional, and it's quite big and robust. MySQL is a community of people who are contributing to a project and you have to hack them in order for it to work. But it is quite good as well.

How was the initial setup?

The installation is straightforward and not complex. However, it depends on some of the features that you may want to use. I think it is simply because you only need to tick whatever functionalities you want to use and the ones that you don't need to use, you don't select them.

What about the implementation team?

Most of the time we are doing the implementation from scratch. If it's a big bank, then they would normally have dedicated people who deal with SQL. However, it depends on the customer.

There is some maintenance that is required, such as updates and tuning. We need to find ways of filling up the data so that it doesn't get stale but normally with regular updates, you should be fine.

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

I cannot comment on the price because I find that the organization already has a license when I arrived. I have not had a sneak peek at the price. When you join an organization, they tell you we are using the 2018 version and that someone purchased it. I don't know who purchased it, I'm not privy to that kind of information.

What other advice do I have?

My advice to companies that are wanting to implement the solution is they have to make sure that they've have a proper skillset. When you have the proper skillset or people who are certified it would make for a better investment into the product. When you are certified, then you know the system in and out and you should be able to have the best implementation for the type of business you have.

I 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
Senior Developer at a government with 51-200 employees
Real User
Easy to scale, simple to set up, and offers many great features
Pros and Cons
  • "The backups are excellent."
  • "I would like to see better integration between their link server and other platforms, such as IBM."

What is our primary use case?

Usually, we use a lot of the vendor software, like ManageEngine, and stuff like that. They use Postgres, however, I prefer to use Microsoft's SQL server. We have a couple of servers and we integrate that information into it. I can run reporting and analysis off of that.

What is most valuable?

There's a lot of great features. I like T-SQL, which is wonderful. The backups are excellent. There's a lot of things that are much easier to manage. All of the features and functions within the SQL language itself, the store procedures, I really, really enjoy. The security has been excellent.

The initial setup is very straightforward. 

The stability is very good.

We find it easy to scale if we need to.

What needs improvement?

I would like to see better integration between their link server and other platforms, such as IBM, due to the fact that, a lot of times, you want to set up a linked server so you can be on SQL and pull data off of another server using that link server. Sometimes they don't play well together. There just needs to be better integration for those types of situations.

For how long have I used the solution?

I've been using the solution for about eight or nine years at this point. 

What do I think about the stability of the solution?

The stability is great. There are no bugs or glitches. it doesn't crash or freeze. It's very reliable. The performance is great. 

What do I think about the scalability of the solution?

Scaling is easy if you need to do it. You simply set up a cluster and you can just grow it up.

In our organization, all the end-users are pretty much integrated into it and using it. As far as developers, there are two developers and me that are using it.

How are customer service and technical support?

We haven't used tech support as we used to have a business partner that wanted us to talk to them instead. Therefore, I can't speak to how helpful or responsive they would be if you need assistance. 

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

Here at the company, they used Postgres, and what I didn't care about it was that it was okay, but it didn't integrate with a lot of the other applications. I felt Microsoft did a better job of that.

How was the initial setup?

The setup is pretty straightforward. The only thing that sometimes gets weird is if you have somebody that's needing an ODBC driver from another type of application back to the SQL server. It's usually that other application trying to figure out what it needs to connect to SQL. It's not really SQL's fault.

What other advice do I have?

We are customers and end-users.

We are using both the latest version and a previous version of the solution. I don't have the exact version numbers on hand. 

I would advise new users first to get help implementing it unless you know the solution well, as there's so much that it can do. A lot of times you can actually make a little mistake. Say if you're going to go in a certain direction, if you get some advice, you may be much happier going in another direction completely.

In general, I would rate the solution at a nine out of ten. I've been quite satisfied with its capabilities. It's an excellent product that still has room for growth.

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