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.
Information Security Manager at a financial services firm with 501-1,000 employees
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?
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.
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?
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 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.
IT Assistant at Hotel 2 Fevrier
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.
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.
Computer engineering student at a educational organization with 501-1,000 employees
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.
Associate Manager at a consultancy with 501-1,000 employees
Provides great CDC mechanism for adding data incrementally; simple installation
Pros and Cons
- "A big advantage is the ability to store any type of data in SQL Server."
- "Performance could be improved."
What is our primary use case?
We use SQL Server to import data from different source systems. Depending on requirements, you act as the resource and can schedule jobs in the Azure environment. The server can be stopped when not required so there's no cost when it's not being used. We make use of the pipeline to put the data into the SQL Azure environment and extract it to the server. I'm the associate manager.
What is most valuable?
The best feature in SQL Server is the CDC mechanism for adding data incrementally. Another good feature is the ability to store any type of data in SQL Server, it's a big advantage.
What needs improvement?
You need to be careful if you have a very large amount of data, because the platform can be degraded if you're not on top of it. Oracle handles that issue better and it's the main problem I have with SQL Server. The performance should be better.
What do I think about the stability of the solution?
This is a stable product.
What do I think about the scalability of the solution?
This product is scalable, we have between 20 and 30 users in our company. We'll continue to use this product.
How are customer service and technical support?
We haven't needed to contact technical support. If there is an issue we use the different SQL forums and we can easily fix issues.
How was the initial setup?
The initial setup is straightforward, you can install with basic knowledge. Installation doesn't take long at all, I did it myself.
What's my experience with pricing, setup cost, and licensing?
There are no annual licensing fees, you pay when you use the product.
What other advice do I have?
I rate this solution a nine out of 10.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Infrastructure and Networks at a financial services firm with 10,001+ employees
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.
Chief Information Officer at a financial services firm with 501-1,000 employees
Good SSMS and profiling tools that work well for internal applications
Pros and Cons
- "I like that the new version has a memory-optimized table to improve the performance."
- "I would like to see the performance improved. Migrating should be easier and the scalability needs improvement."
What is our primary use case?
We use SQL Server for our internal applications.
What is most valuable?
Working with SQL Server, it is quite convenient to use the SSMS tools to write a profile. I also like the profiling tools.
I like that the new version has a memory-optimized table to improve the performance.
What needs improvement?
We had some difficulty doing the performance tuning when we migrated from the 2008 version to the 2016 version. We experienced a drop in the performance. We could not understand or figure out what caused the drop in performance. We did not change any settings to cause this effect. We tried to keep the same settings.
We feel that when running the 2008 version, it was much quicker in terms of performance.
That is an area of SQL Server that can be improved. Moving to a new version, you shouldn't have to change the configuration.
We have not been able to utilize it fully because it is not straightforward.
I would like to see the performance improved. Migrating should be easier and the scalability needs improvement.
For how long have I used the solution?
I have been using this solution for many years.
We are using version 2016.
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?
In terms of scalability, it has some room for improvement.
We have 20 people in our organization who are using this solution.
How are customer service and technical support?
We don't usually get support from Microsoft. We get it from our software vendors or we try to do it ourselves.
We are somewhat satisfied with the support that we have received from the vendor, but not fully because of the issue we faced when we moved to a newer version. But in other areas, it's okay.
Which solution did I use previously and why did I switch?
We have used SQL Server from the beginning.
How was the initial setup?
The initial setup was moderate. It was not easy but it was not difficult.
What other advice do I have?
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.
Data Architect at ACPAS Loan Management Software
Stable with good time zone features and easily scalable
Pros and Cons
- "If you need to, you can scale the solution very easily."
- "The solution is rather expensive."
What is our primary use case?
We primarily use the solution for non-management processes.
What is most valuable?
The product is very good at centralizing information.
The solution has very good features related to timezones.
The product is quite stable.
If you need to, you can scale the solution very easily.
What needs improvement?
The solution has legacy issues when it comes to compatibility. If you have older technology, you may run into compatibility problems with SQL.
The solution is rather expensive.
For how long have I used the solution?
I've been using the solution for over a decade. It's been a long time. At this point, it's been about 12 years or so.
What do I think about the stability of the solution?
The stability of the solution is excellent. We don't run into any issues with bugs or glitches. It doesn't crash or freeze. It's fairly reliable.
What do I think about the scalability of the solution?
The solution scales well. if a company needs to expand its SQL server, it's not a problem to do so.
We do plan to continue to use it going forward. I'm unsure as to if we have plans to scale it, however.
How are customer service and technical support?
I don't have too much information on technical support, however, it's my understanding that if you need it, it is available.
Which solution did I use previously and why did I switch?
We did not previously use a different solution. We've only ever really used SQL.
How was the initial setup?
The initial setup isn't too complex. It's pretty straightforward, especially if you are setting up the cloud. It's very easy to provision. It requires fairly typical knowledge. If you are familiar with Windows software, you'll find that there isn't much of a challenge to the setup. I'd say it's not overly technical.
Deployment is fast. You can have it up and running in an hour or sometimes less.
You need about two people to handle the deployment of the solution.
What about the implementation team?
I handled the implementation myself. It's pretty easy, and not too technical, and therefore I didn't need the assistance of any consultants or integrators.
What's my experience with pricing, setup cost, and licensing?
You do need to pay for licensing in order to use the solution. It is a little bit expensive, however, it's not the most expensive option on the market. It's cheaper than the competition, however, as I mentioned, it's still pretty pricey.
What other advice do I have?
We're just a customer. We don't have a business relationship with the client.
We're using the latest version of the solution currently.
We use both cloud and on-premises deployment models.
I'd recommend this product to other organizations.
Overall, we've had a positive experience with the solution. I would rate it 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.
Analytics Manager - Data and Capability at a financial services firm with 1,001-5,000 employees
Scalable as a cloud, good as a data warehouse, and offers good analytics
Pros and Cons
- "As a data warehouse and storage solution, it's quite good."
- "The solution could use better governance on the management side, especially around data governance."
What is our primary use case?
We use the solution for many tasks. We use it as a data warehouse. However, we also use it for workflows and processing jobs.
What is most valuable?
The analytics are pretty good.
As a data warehouse and storage solution, it's quite good.
It's easy to put the data back onto the SQL Server or Oracle.
The solution is pretty fast. We find it to be responsive.
There are a lot of services, such as the SSISS, SIS, and SSI's that work quite well.
What needs improvement?
The solution could use better governance on the management side, especially around data governance.
The product could do better at allowing for integrations.
For how long have I used the solution?
I've been working with the solution for many years. It's likely ten to 15 years at this point. It's well over a decade, so I have some long-term experience with the product overall.
What do I think about the scalability of the solution?
The scalability for the solution is good, at least where it concerns the cloud. Using the cloud makes everything very easy to scale. On-remises, if you run out of dick space, it's a bit difficult.
How are customer service and technical support?
We've been in touch with technical support in the past. We manage the data center ourselves, however, if we run into issues we know we can contact them for assistance. I'd say we are quite satisfied with the level of support we get.
How was the initial setup?
I can't recall how the initial setup was. It was a while ago. We've had the solution for a very long time.
What other advice do I have?
We're just customers and end-users.
I don't know if I would recommend the solution per se. There are other options out there. Something that is a NoSQL database. Something like Snowflake, for example, might be a very good option for data warehousing. They are more adept at handling different types of data.
You shouldn't have to create tables or systems, you should just be able to query files.
I'd rate the solution at an eight out of ten. However, for the current scenarios we have, there are other options that may be more suitable. It's not the only product available on the market, and the competition is quite good.
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.
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 ToolsPopular Comparisons
MySQL
Teradata
Oracle Database
MariaDB
SAP HANA
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
IBM Informix
Oracle Database In-Memory
Citus Data
YugabyteDB
SAP IQ
SAP Adaptive Server Enterprise
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Microsoft sql2017 VS SAP Hana
- SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
- SQL Server 2012 - can I make OLTP transactions from my ERP run in memory?
- How does NuoDB compare to MySQL and SQL Server?
- What are the main architectural differences between Microsoft SQL Server and Oracle Multitenant?
- Would you say the price of SQL Server is high compared to that of similar products?
- Has using SQL Server helped your organization in any way?
- Which authentication mode is best for SQL Server?
- Which solution do you prefer: Microsoft SQL Server's enterprise edition or Oracle Database's enterprise edition?
- Which is better: SQL Server or SAP HANA?