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.
We primarily use the solution to store databases.
Since MongoDB, we have come up and there are lots of tools that do enhance the database management system or keep an eye on our data. People can easily access it.
The solution is stable. It's reliable.
The initial setup is simple.
MongoDB is a bit better. A traditional database system, like the SQL Server, is failing to catch up.
You need an experienced person to use that piece of technology so that you can store everything in a logical manner. We'd like it to be easier to store in a logical manner.
The scalability could be better.
We've been using this solution since 2012. It's been a while at this point.
It's not scalable. It hinders your performance as it's slow in nature and you need experienced people to work on it. That is why it's not very scalable.
We currently have ten to 15 users on the solution.
At this time, we have no plans to increase usage. We are focusing more on MongoDB.
We don't have any experience with Microsoft technical support. Therefore, I wouldn't be able to rate how responsive or helpful they are.
We did not previously use a different solution. We are currently moving towards MongoDB, however.
The installation is easy, especially since the new version has come up. Now, with the latest versions, installation is easy.
I cannot remember the time it took to complete the installation.
Earlier, we had to bring in a technical team, however, our own technical team is quite experienced now. They can now do it themselves.
We pay a yearly subscription fee.
We use both cloud and on-premises deployment models. We're using the latest version of the solution.
I'd recommend the solution to other users and organizations. If there are people who can't afford MongoDB or if an organization doesn't want to migrate to MongoDB, it's important to keep in mind the users would have to learn the fundamentals of the SQL server first. Knowledge of it is a necessity.
I'd rate the solution at a six out of ten.
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 for reporting.
I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.
The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions.
I've been working with SQL Server for the past seven years.
SQL Server is stable.
SQL Server is scalable. I can't say if we'll increase usage in the future because I'm only working here as an analyst. It's a company decision. If necessary, then I can make a recommendation. I can go for that if the client wants, so it depends entirely on our client. If the client wants Oracle instead of Microsoft, I don't have an option.
I never contacted Microsoft support about SQL Server, but I have called about Power BI one or two times. It was great support.
I rate SQL Server eight out of 10.
We are business consults. We use SQL Server to ensure that critical applications remain operational by performing BCM activities across application and database servers.
SQL Server has scaled as per our requirements.
I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements.
From a restoration perspective, I have been working with SQL Server for a few years.
The stability of the SQL Server needs improvements.
We have over 2,000 users in our organization.
I have contacted technical support, and overall my experience with technical support was okay.
The installation took a few days to complete.
We have a team of three or four admins to maintain this solution.
We had assistance from an integrator.
Licensing fees are paid on a yearly basis.
We were evaluating other solutions for a specific requirement in our organization. The requirement is now complete.
I would recommend this solution to others who are interested in using it.
I would rate SQL Server an eight out of ten.
SQL Server is used for storing data.
I have found SQL Server easy to use.
SQL Server could improve by having better usability or user guidance.
I have been using SQL Server for approximately five years.
The solution is stable and the performance is good.
SQL Server is scalable.
I have not needed to contact support.
The implementation was done by our IT department.
We did the implementation in-house.
The price of the solution is fine.
I would recommend this solution to others.
I rate SQL Server an eight out of ten.
We have been using SQL Server for more than 10 or 15 years.
Microsoft support is an issue unto itself. We mainly benefit from common support, such as a forum or Microsoft support, of which I don't have that much experience.
As with Oracle Database, the solution has a reliable database. I do not see much difference between the two when it comes to usage and the program decision to use one solution over another varies with the appropriateness of a given product, some utilizing Oracle, others Scale.
I am an SQL partner.
As with Oracle, SQL Server is deployed on private cloud.
I rate SQL Server as a nine out of ten.
