We primarily use the solution as a backend server.
There are a few applications of the Oracle product for our data sitting on the SQL Server as well.
We primarily use the solution as a backend server.
There are a few applications of the Oracle product for our data sitting on the SQL Server as well.
It's useful as a backend server.
We have found the solution to be scalable.
The stability of the product needs to be improved. It's really not stable enough.
In Microsoft, the Active-Active options are not available. There are a lot of requirements that are coming right from the customer, which may not be provided by Microsoft. There are a few use cases where we do need the Active-Active options instead of Active-Passive, yet those kinds of options are not available for Microsoft.
We've been working with the solution for going on five years.
We've struggled with the stability of the product. We'd like for it to be more stable and reliable.
The scalability is very good. If a company needs to expand, it can do so.
We are a customer and an end-user.
I would rate the solution at a seven out of ten. While the scalability is there, the solution is lacking a few aspects that customers really need.
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.
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.
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.
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.
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.
The scalability could be improved.
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.
The initial setup was straightforward.
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.
I rate SQL Server as an eight out of ten.
All of our .NET applications and some of our third-party applications require a single server database, AutoCAD, and things like that. Our custom apps are the largest estate of databases.
In our production environments, we're on version 17. I've worked with the most recent version but not in a production environment.
I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else.
They've been adding a lot of great functionality such as columnstore indexes to improve the way indexes are rebuilt and to be able to do online index rebuilds. All those are great features.
On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances.
I have been working with this solution for probably 18 years.
Everything is pretty much scripted out, so it is pretty straightforward for us.
They've been adding a lot of great functionality, and hopefully, they continue down that path. We don't use a lot of the more advanced features at this point, but for what we're doing right now, it's working really great with availability groups and other features.
Its usability has gotten a lot better after version 14. There were a lot of great updates after version 14 for SQL or query performance with the engine.
I would rate it an eight out of 10.
We primarily use SQL Server as a database management system.
This solution is deployed on-prem.
One of the most valuable features of SQL Server is that it's easy to use.
SQL Server could be improved with cheaper licensing because it's very expensive.
We have been using SQL Server since 2016, so more than five years.
This solution is stable.
Before implementing SQL Server, we used Oracle. We switched to SQL Server because it had good integration.
The installation is straightforward. I was able to handle deployment and maintenance by myself.
We implemented this solution through an in-house team.
For licensing, we pay yearly. The licensing is very expensive, and it should be cheaper.
I rate SQL Server an eight out of ten. I would recommend it to others, as long is it meets their requirements.
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.
SQL Server could improve the integration with nonrational database solutions, such as MongoDB.
I have been using SQL Server for eight years.
SQL Server has good performance. It is one of the best features.
We have approximately 300 instances of SQL Server.
I have approximately five customers using this solution.
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.
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.
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.
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.
We use SQL Server to manage and store information.
They have improved the UI and ease of accessing the database and server which is good.
You can load it up and start using it from the very minute it is implemented.
I have been using SQL Server for two and a half years.
SQL Server is stable. We have more resources that are using it, I am more familiar with SQL Server. I have been using it for a long time. Most of the time it has been stable.
The solution is scalable.
We have approximately 30 people in my organization using this solution.
The technical support is okay.
The installation is straightforward.
We have administrators and engineers that do support the solution.
We are on a monthly subscription and the price could improve. However, the price has worked out well in some deployments. The problem is you never know what kind of services have been installed and you have to be in touch with many people, such as which servers are active or which are not. I did face a couple of issues in terms of subscriptions and the pricing model. They have improved over time.
I would recommend this solution to others. My advice to others wanting to implement this solution is you have to consider the industry demand and the benefits or advantages of a solution before you choose, for example, Oracle or Microsoft.
I rate SQL Server an eight out of ten.
We use SQL Server as a database management system for all of our projects.
While this is a reliable product, it has room for improvement.
Although Microsoft SQL was accessible in some projects, we did not use it everywhere. It is determined by the project. It's quite beneficial in some circumstances, but it couldn't support SQL databases in others, consequently, we used other suppliers like Oracle, Informix DB, PostgreSQL, MySQL, and others.
We have been using SQL Server for quite some time now.
We use it both on-premises and in the cloud. It is dependent on the projects.
SQL Server is a stable solution.
SQL Server scales well.
In the future, we may expand our usage.
I don't have any issues with the technical support.
We evaluated each product after using it, starting with Informix DB and ending with Oracle.
Oracle, Informix DB, PostgreSQL, and MySQL are among the products we use.
It's quite easy to install.
Completing the installation is not an issue.
My position is not related to installation, but if it is necessary, I am capable of doing it.
It requires the purchase of a license. Our company's products all have licenses.
It is appropriate for small and medium-sized businesses.
I would recommend this solution to others.
I would rate SQL Server an eight out of ten.
We are using SQL Server for our financial application package.
One of the best features of SQL Server is the efficient retrieval of information.
We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud.
I have used SQL Server for approximately seven years.
SQL Server is stable. However, Microsoft products have a tendency to crash. I would rate it a five out of ten in terms of stability.
The scalability of SQL Server is good.
The solution is straightforward to install.
The price of SQL Server could be better in the African market. The licensing model needs to be improved, it is confusing.
I rate SQL Server an eight out of ten.