Try our new research platform with insights from 80,000+ expert users
Marketo Consultant at Webtech software servies
Real User
Easy to query, straightforward for beginners, and extensive online support community
Pros and Cons
  • "The most valuable features of this solution are easy queries and straightforward programming for beginners."
  • "SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server."

What is our primary use case?

We use SQL Server for web application and website development.

What is most valuable?

The most valuable features of this solution are easy queries and straightforward programming for beginners.

What needs improvement?

SQL Server could improve by providing something similar to an interface or dashboard where a developer can do debugging, this would make a developer's work easier. Additionally, the optimization could be better. If there was an interface showing information needed for the optimization it would help because there can be some data loss making it difficult to optimize the SQL Server.

For how long have I used the solution?

I have been using this solution within the past 12 months.

Buyer's Guide
SQL Server
March 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
861,524 professionals have used our research since 2012.

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 scalability is good for simple applications. However, the problem with scalability is if the application is too large, it cannot handle it. We have to depend on other database servers. 

How are customer service and support?

I have not used technical support but I have used the open forums online that provide all the information that we have needed. There is a large online community for support. 

How was the initial setup?

The installation is straightforward.

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

There is a license required for this solution and we pay monthly. The price is reasonable compared to other solutions.

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?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1428423 - PeerSpot reviewer
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Integrates well, high performance, and provides many features
Pros and Cons
  • "SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well."
  • "They could improve by adding the SQL format."

What is our primary use case?

This solution is part of the ERP that we have for application. We use it for many purposes, such as POS in-store cash registers for enterprise companies.

What is most valuable?

SQL Server provides good performance. Most of the SQL solutions can be integrated and this solution is no different, you are able to link other databases. For example, we have Oracle running a Postgres Server and it is linked. It follows the ISO standard when it comes to commands, it works well.

What needs improvement?

They could improve by adding the SQL format.

For how long have I used the solution?

I have been using SQL Server for approximately eight years.

What do I think about the stability of the solution?

The solution is stable, I have not had any issue using it.

What do I think about the scalability of the solution?

The scalability is very good.

We have approximately 500 users using the POS.

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

I have previously used IBM Informix, PostgresSQL, and Oracle Databases.

How was the initial setup?

The installation is straightforward and takes approximately 30 minutes. If you were to add more features the installation could take longer. For example, there are many features such as table partitioning allowing you to do queries faster, transferring data from one table to another, and performing quicker backups.

What about the implementation team?

We did the implementation ourselves. We have a team that does the maintenance for Windows Servers, Linux desktops, and Linux Servers.

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

There is a license required for servers and for the POS we use the free version. The free version allows you to have tables and a total database size of approximately 10 GB, which is enough for our requirements.

What other advice do I have?

This is an excellent solution when it comes to databases. I would recommend it to others.

I rate SQL Server a ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
SQL Server
March 2025
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
861,524 professionals have used our research since 2012.
reviewer1621938 - PeerSpot reviewer
Senior BI Consultant at a tech services company with 11-50 employees
Consultant
Overall high quality features, reliable, and good technical support
Pros and Cons
  • "I have found the whole solution with all its features wonderful."
  • "If this solution could provide an automatic indexing feature it would be very useful."

What is our primary use case?

Our primary use case is for SQL Server is data warehousing and business intelligence.

How has it helped my organization?

This solution acts as the backbone of most IT services. It is essential for us to use it.

What is most valuable?

I have found the whole solution with all its features wonderful.

What needs improvement?

If this solution could provide an automatic indexing feature it would be very useful.

In the next release, there could be better integration with Power BI or other tools.

For how long have I used the solution?

I have been using this solution for approximately 20 years.

What do I think about the stability of the solution?

The solution is stable. There has been a few bugs but all solutions have them at one time or another.

What do I think about the scalability of the solution?

There are scalability limitations and this is why we are evaluating cloud alternatives. 

I rate the scalability of SQL Server a four out of five.

How are customer service and technical support?

We provide support for our clients but if we need support we receive it quickly because we are prime customers.

Which other solutions did I evaluate?

We are currently evaluating cloud options.

What other advice do I have?

I would advise those wanting to implement this solution to thoroughly investigate if this is the right tool for their use case.

I rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
PeerSpot user
reviewer1601793 - PeerSpot reviewer
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Real User
Simple to set up, simple to use, stable, and scalable
Pros and Cons
  • "I like that it's a cloud solution, is simple to set up, and is simple to use."
  • "It would definitely be better if SQL Server were free."

What is most valuable?

I like that it's a cloud solution, is simple to set up, and is simple to use.

We are also totally satisfied with the stability and scalability of SQL Server.

What needs improvement?

It would definitely be better if SQL Server were free. 

For how long have I used the solution?

I've been using SQL Server for two years.

It's a cloud-based solution.

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?

It is scalable, and we have had no issues so far.

How was the initial setup?

The initial setup is straightforward and is comparable to that of PostgreSQL.

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

We pay per second of usage, but there are different offerings of the license.

Which other solutions did I evaluate?

We evaluated Oracle and PostgreSQL.

What other advice do I have?

For people who would like to use SQL Server for specific use-cases, I would definitely recommend it.

On a scale from one to ten, I would rate this solution at eight.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
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: My company does not have a business relationship with this vendor other than being a customer.
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1523223 - PeerSpot reviewer
IT at a financial services firm with 201-500 employees
Real User
Enables a person to do whatever is required at the command line level
Pros and Cons
  • "Since we can automate most of our tasks, it means that the management is very easy."
  • "I would like to see the database become fully automated."

What is our primary use case?

Microsoft SQL Server is a database application, meaning it acts as the backend system for help with the backend data repository system. It concerns itself with every activity that happens at the front end of the database in Microsoft SQL Server. ERP Microsoft solutions is one reason that the SQL server has compatibility. The management of Microsoft SQL Server is actually quite easy. It has a GUI interface and enables a person to do whatever is required at the command line level. It functions as a repository for storing one's data in the relational database. 

What needs improvement?

The Standard Edition and Enterprise Edition have certain limitations. While the latter is clearly more expensive than the former, it would be nice to see some of the features in the Enterprise Edition be moved to the Standard Edition. This will encourage many more people to use that solution.

If we were discussing the 2000 edition in respect of the SQL Server, I would probably cite security and performance as issues. However, nowadays, when it comes to an application connected to their databases, there is no real difference between MS SQL Server and Oracle. As a consequence, it would be nice to see the application be made more cost-effective. I am aware of much database self-management in respect of Oracle. I know that the last time a colleague of mine used this solution in California, he informed me that the application itself was managing the database.

At present, the solution uses the older connection and the schema is designed in such a way that it can actually provide a very low level of virtualization. Since the security is also hierarchical within the system, they've really done a very good job. 

This said, I would like to see the database become fully automated.

For how long have I used the solution?

I have been using SQL server for a couple of years, since day one. 

What do I think about the stability of the solution?

The solution is stable and it has remained so over the years. I've worked in different organizations, such as the banks here in Lagos. Straight off the bat, I've been using Microsoft SQL Server 2000. We currently use Microsoft SQL Server for our ERP needs. How one designs his tables is important. As the team leader, it is my job to ensure that the functioning is as it should be. The application is pretty straightforward. 

Since we can automate most of our tasks, it means that the management is very easy. We can have jobs for our backups. The solution grants us the ability to perform database housekeeping tasks.

What do I think about the scalability of the solution?

The solution is very scalable.

How are customer service and technical support?

It's been fun dealing with technical support. Generally speaking, they have shown a willingness to handle issues we may have. 

What other advice do I have?

The solution demonstrates performance and this is going well for the moment. 

In consideration of its performance, I rate SQL server as a nine out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Computer engineering student at a educational organization with 501-1,000 employees
Real User
Stable with good technical support and integrates well with Visual Studio
Pros and Cons
  • "The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
  • "The solution could be better integrated with the SQL Server Studio tool."

What is our primary use case?

I primarily use the solution for the development of various applications, database connections, that I need for projects.

I just use it myself, for assignments. I am a student and am studying the product.

What is most valuable?

The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services.

The solution is very stable.

The solution scales well.

The initial setup is straightforward. 

What needs improvement?

I don't have a deep technical knowledge of the solution. It's hard to discuss features that may be lacking.

The solution could be better integrated with the SQL Server Studio tool.

There are some complexities with the initial setup sometimes as there are a lot of options.

For how long have I used the solution?

I've been using the solution for two years at this point.

What do I think about the stability of the solution?

The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable in terms of performance.

What do I think about the scalability of the solution?

The solution can scale. If a company needs to expand it, it can do so.

As a student, I don't yet have plans to increase usage of the product.

How are customer service and technical support?

I've been in touch with technical support. I contact them to assist with a bug that I detected, that was not really related to SQL Server. It was, however, related to another tool, the Microsoft SQL Server Studio. They responded quickly. I was quite satisfied with their level of support for the most part.

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

I've also worked with PostgreSQL, and MySQL as well as MongoDB. I found that, in comparison, PostgreSQL was not as easy to use.

How was the initial setup?

The initial setup was pretty straightforward. It's very similar to other software products. The Visual Studio is easier, however, it's still mostly straightforward. It could be better integrated with this SQL Server Studio tool. You have to install it separately. If they could be installed together, that would be an improvement in my opinion. While not everyone would use it, the developer would find it a helpful item to have.

It can sometimes be confusing to install by yourself since it does have many options that you need to decide on.

What about the implementation team?

I was able to install the solution myself. I did not need the assistance of an integrator or consultant.

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

You do need to pay for a license in order to use the product.

What other advice do I have?

I'm just an end-user.

I'd rate the solution at a nine out of ten. I'm mostly happy with its capabilities.

I'd recommend the solution to other users. It's a solution that is nice and standardized. We are learning all about it at school and its industry standards make it a good option.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
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.