BI Specialist at a educational organization with 1,001-5,000 employees
Real User
Top 20
Highly stable and easy to use, but its pricing and quality could be improved
Pros and Cons
  • "SQL Server is a highly stable solution."
  • "The pricing and quality of the product could be improved."

What is most valuable?

SQL Server is a highly stable solution.

What needs improvement?

The pricing and quality of the product could be improved.

For how long have I used the solution?

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

What do I think about the stability of the solution?

I rate SQL Server a nine out of ten for stability.

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

What do I think about the scalability of the solution?

Our clients for SQL Server are usually enterprise businesses.

I rate the solution an eight or nine out of ten for scalability.

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

On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing a seven out of ten.

What other advice do I have?

Since SQL Server was one of the most commonly used products initially, it was very easy to use. I'm moving away from the solution because there are now better data storage tools. SQL Server was used for the postal service in the Netherlands, where the postal buses on the street were analyzed. SQL Server is always deployed on the cloud.

Data recovery and backup are sometimes hard with SQL Server because of the data store size. Based on the data structure, I would sometimes recommend the solution to other users.

Overall, I rate the solution a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
IT Officer at a manufacturing company with 201-500 employees
Real User
Easy to set up with ample online documentation to resolve issues independently
Pros and Cons
  • "Stability and usability, which is quite simple, are two of the solution's most valuable features."
  • "The solution could be better when it comes to security."

What is our primary use case?

While we were still using the solution, we employed version 2008, which is a bit on the old side. 

We basically used the solution for hosting the database for Sage ERP.

What is most valuable?

Stability and usability, which is quite simple, are two of the solution's most valuable features. 

What needs improvement?

The solution could be better when it comes to security. 

The solution is part of Windows services, which means that if these should stop running, the database system, too, would be affected. This makes it very crucial to constantly monitor the SQL Server, something which reflects on cheap personnel time. 

Scalability could be better.

Although it comes with a cost, using the most recent version is highly advisable, since it would ensure a certain measure of bug fixes and stability. The sole issue would involve the cost, as this is expensive. 

When it comes to integratable features, the monitoring should be addressed. 

For how long have I used the solution?

We used SQL Server for nearly six years, although we have since moved to another platform. We have used the solution at some point within the last 12 months. 

What do I think about the stability of the solution?

The solution has good stability, although my advice is to use the most recent version towards this end, to provide for bug fixes. This will ensure some stability. 

What do I think about the scalability of the solution?

The scalability could be improved. 

How are customer service and support?

As support would have involved a licensing fee, we opted not to make use of this. 

We find there is ample documentation online to allow us to resolve issues through independent research.

How was the initial setup?

The initial setup was straightforward.

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

Although it comes with a cost, using the most recent version is highly advisable, since it would guarantee a measure of bug fixes and provide some stability. The pricing is expensive, though, this being the sole issue. 

We chose not to make use of support, as this would have incurred a licensing fee. 

What other advice do I have?

I rate SQL Server as 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
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,857 professionals have used our research since 2012.
SQL Server Senior Architect at a computer software company with 1,001-5,000 employees
Real User
High performance, easy installation, but better integration needed
Pros and Cons
  • "SQL Server has good performance. It is one of the best features."
  • "SQL Server could improve the integration with nonrational database solutions, such as MongoDB."

What is our primary use case?

SQL Server can be used for managing and storing information.

I have a lot of databases with more than one terabyte of information and we use technology, such as Stretch database to switch out the information to Azure databases with this type of technology.

What needs improvement?

SQL Server could improve the integration with nonrational database solutions, such as MongoDB.

For how long have I used the solution?

I have been using SQL Server for eight years.

What do I think about the stability of the solution?

SQL Server has good performance. It is one of the best features.

What do I think about the scalability of the solution?

We have approximately 300 instances of SQL Server. 

I have approximately five customers using this solution.

How are customer service and support?

I currently have one ticket open with Microsoft support and I have been waiting about two days. However, it's not a critical incident. The technical support they provide us is good.

How was the initial setup?

In the latest version of SQL Server, Microsoft has split the product. For example, if you want to start with the engine or the reporting server you have to download it separately.  I think that the installation is easier on the new versions. There are other kinds of options that you can set up in the installation progress. For example, the number of 10 DV files or the limit of maximum use of memory.

The installation process takes approximately 10 minutes.

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

There is a license to use this solution. However, the model is not easy to understand. There is a guide you have to read about all the information on how it works. If you read this documentation, you can understand how it works. We are paying for our SQL Servers by CPU cores with an enterprise license.

What other advice do I have?

If a new company wants to implement SQL Server, they need to know that there should be a person who has all the knowledge about DBA position, such as how the SQL Server will be set up because I have a lot of customers and when I checked they have a lot of bad options or practicing in their SQL Servers instance. If someone wants to start with SQL Server, they have to improve and have good knowledge about this technology. It's important to have knowledge about this technology. They should take some courses or maybe have a person who has all the knowledge about this technology with certification, it's the most important. It's not easy to keep up to date with the best practice from a provider, in this case, Microsoft.

I rate SQL Server a seven out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Senior Manager at a financial services firm with 201-500 employees
Real User
Easy to manage with good stability and knowledgable technical support
Pros and Cons
  • "The solution is easy to set up."
  • "The configuration process can be a little complex."

What is most valuable?

We find the Microsoft SQL Server affordable compared to its real competitors. 

We find it easy to manage. 

It offers a very robust infrastructure for us.

The solution is easy to set up.

We have found the stability to be good.

We've had a good experience with technical support. They are helpful.

What needs improvement?

We may use different levels of SQL Server when it comes to licensing. We have some Enterprise and some Standard services. They can improve the recovery processes of the replication or disaster recovery scenarios for the lower-tiered version, such as the Standard server.

While we have many options in Enterprise, it's expensive for most companies.

The configuration process can be a little complex. 

Technical support can take a while to respond in Turkey.

The solution may be better with some integration with some factory cloud software. With the standard version, the lodgement process is never enough. We are replicating near real-time to make recovery easy and to make all the RPO targets as expected. 

You cannot recover SQL Servers, especially for big financial companies like ours. It's not easy to erect SQL Servers on any other site, and with an acceptable data loss in the foundations.

For how long have I used the solution?

Personally, I have used the solution for about 15 years at this point. It's well over a decade. I've used it for a while. 

What do I think about the stability of the solution?

The stability has been great. There are no bugs or glitches. It doesn't crash or freeze. it's reliable. 

How are customer service and technical support?

The Microsoft team never responds fast in Turkey. I cannot say they are fast. Unless you have some Enterprise agreement, they're not quick. However, I find that when I deal with the same technician a few times, they are quite good and very helpful. They are very capable. They know what they are talking about. 

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

We also use Oracle Servers. 

How was the initial setup?

The initial implementation is easy and straightforward. It's not overly complex or difficult to set up.

However, it's not just the server we have to set up. We have a cluster environment. Mostly it's just, click, click, click and you are done, however, the configuration process is a bit more difficult. Adjusting performance levels, in particular, can be a real challenge.

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

The enterprise version of the solution is very expensive and most companies would likely find that they wouldn't be able to afford it. 

What other advice do I have?

We're a customer and an end-user.

I'd rate the solution at a nine out of ten. We've been very happy with its capabilities. 

I would recommend the solution, however, it will only be effective if the company hires an effective administrator. While there are default settings, you will likely need to configure quite a bit and connect most of your hardware in the correct way. To be effective, it really needs to be tuned by a professional. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Information Security Manager at a financial services firm with 501-1,000 employees
Real User
Good for publishing web applications, but security, stability and performance can be improved
Pros and Cons
  • "We have found the feature that allows us to publish web applications to be valuable."
  • "As we have faced problems with the solution in both the past and present, I feel it could be more stable."

What is our primary use case?

We use the solution for nearly all of the services we provide that utilize Windows Server. We use it to provide continuous service and in respects of our mail server. 

What is most valuable?

We have found the feature that allows us to publish web applications to be valuable. 

We have 20 servers and we use disparate ones for different applications, such as Kaspersky Anti-Virus Server and Windows SharePoint in respects of the surveillance system. 

What needs improvement?

The solution should be more secure and stable and have better performance, particularly as concerns the endpoint operating systems. I would like to have a better operating system that links the CPU and the RAM efficiently.

For the majority of our servers we have not used other operating systems, although there are certain features or requirements that necessitated their use, such as Red Hat. This was rare. Mostly, we used Windows OS. 

As for the performance issue, we have recently encountered situations in which everything would fail in spite of the CPU and memory being 100 percent operable. 

For how long have I used the solution?

We have been using SQL Server for 12 or 13 years.

What do I think about the stability of the solution?

As we have faced problems with the solution in both the past and present, I feel it could be more stable. 

What do I think about the scalability of the solution?

The solution seems scalable to me. 

How are customer service and technical support?

We have not had experience with technical support and have handled this independently whenever we encountered problems. 

How was the initial setup?

When it comes to the installation of the operating system, we have found it to be easy and user-friendly. 

Our greatest praise for the solution we reserve for its ease of installation and usage. These provide definite advantages. Perhaps this can be attributed to the fact that we have always made use of the solution for nearly every relevant company in South Africa.

While I cannot recall exactly how long the installation lasted, I did recently install endpoint Windows 10 Operating System and this took an hour and a half. 

We were able to handle the installation on our own, as we are well versed in this process when it comes to Windows OS.

On an individual basis, we solely make use of Windows OS. There are between 300 and 400 people in our organization who do so. 

Generally speaking, we do not make use of a technical team for deployment and maintenance purposes and do so internally. There are a maximum of seven or eight people in our organization who are responsible for this. We are talking about technical people who are responsible for the direct installation and configuration of Windows OS and they do not include managers. 

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

I believe the licensing to be on an annual basis. In 2019 we purchased a three year license. 

Which other solutions did I evaluate?

We did not evaluate other other options before going with the solution. 

What other advice do I have?

I rate SQL Server as a seven out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
IT Assistant at Hotel 2 Fevrier
Real User
has an efficient configuration but is not sufficiently scalable in size for simultaneous connections
Pros and Cons
  • "The initial setup is time-efficient and can be done independently."
  • "As SQL server could not support the number of connections we desired, we were forced to go with Oracle."

What is our primary use case?

We use SQL Server with Sage products.

It is used by our finance team and also human resources.

What is most valuable?

the database management tool is very easy to use and largely meets expectations

What needs improvement?

As SQL Server could not support the number of connections we desired, we were forced to go with Oracle. This is an area that needs to be improved.

For how long have I used the solution?

for 04 Years now 

What do I think about the stability of the solution?

The solution could be more stable

What do I think about the scalability of the solution?

The performance in terms of simultaneous connection must be reviewed.

How are customer service and technical support?

We do not pay for technical support.

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

No

How was the initial setup?

The initial setup is time-efficient and can be done independently.

There is no need for developers or managers to deploy and maintain the solution. One or two systems' administrators are sufficient for its deployment.

The deployment is on-premises. We installed the solution on a server and this on the Windows server. The user is provided an application for connecting to it.

What was our ROI?

great

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

The licensing involves a one-time fee.

Which other solutions did I evaluate?

We evaluated Oracle as an alternative.

What other advice do I have?

For my part, SQL Server is aimed at small and medium-sized businesses, I would give it an eight out of ten.


I would not recommend it for a large company that has to support more than 40 simultaneous bi-directional connections to the database


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
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Infrastructure and Networks at a financial services firm with 10,001+ employees
Real User
Reasonably priced, stable, scalable, and the support is good
Pros and Cons
  • "We like business integration, database, and analysis."
  • "I would like to see more integration with other platforms."

What is our primary use case?

We use this solution for data warehousing and products to the platforms developed by the company. 

What is most valuable?

We like everything. We use all of the features that SQL offers. 

We like business integration, database, and analysis.

What needs improvement?

I would like to see more integration with other platforms.

For how long have I used the solution?

I have used this solution for more than ten years

We are using the latest version.

What do I think about the stability of the solution?

It's a stable product.

What do I think about the scalability of the solution?

It's a scalable solution and we have 1,000 users in our organization.

We are stabilizing, so we are not going to increase our usage with SQL.

How are customer service and technical support?

Technical support is okay. We don't have any issues with them.

How was the initial setup?

The initial setup was straightforward.

It took a couple of hours to install, no more than that.

What about the implementation team?

We completed the implementation ourselves.

We have a team of 34 admins and engineers to deploy and maintain this solution.

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

We purchased our license and the pricing is fine for us. 

What other advice do I have?

I would recommend this solution to others.

I would rate SQL Server 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
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 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.