SQL Server Reviews

While I don't like SQL Server so much, the selection was for clients so we needed to utilize it. Of course, one thing is that as great with this and other Microsoft products is that it's quite well documented and there are also light versions available. If you need to do something, you can also try it somehow on your own computer and so on. 

If I'm helping a client to define what they need to have or what they need to do in a public sector procurement process quite often we cannot fix the database as it would be limiting the competition. That's why we never rule out the SQL Server; it should be included as an option at this level.

The solution is stable. 

I haven't had issues with sizing or scaling.

If it would be more powerful it would be pretty nice. The performance is not always the best. 

Whenever we were setting up the databases, there were some character problems that did not exist on some of the other solutions. However, the exact issues are hard to recall and list. I prefer Linux solutions. That said, when we began the previous project, Microsoft SQL Server was not available for Linux platforms yet.

Nowadays, it's my understanding that there are different versions. I haven't been checking if the current versions are supporting Transact-SQL and stuff like that. I remember that when we had the first Linux-based SQL Servers were introduced, they were, of course, a bit limited from the feature point of view. Whenever it is Unix or Linux or whatever platform, it's easier to manage them and to handle them whenever you are doing remote work. 

I'm not so big fan of the Microsoft platforms as a server. However, whenever it's needed then it's needed. If you are a consultant, you need to adjust your whole mindset to whatever it's needed.

I've used the solution, approximately, for several years. However, there have been gaps. There are different phases, however, I could count something like seven years where I was in an architect position in any project where this server was utilized. 

For the needs we had for the client it was sufficient. Whatever we needed to have - whether more server or more virtual server, the performance for the platform wasn't as good as I would like. I'm not entirely satisfied.

I haven't been utilizing the scale capabilities. I don't have a clear impression on that, however, for our purposes, we've never had an issue.

I've never dealt with technical support. The databases were handled by the service provider or service operator of our clients. We have a public sector client and they have their partner who is handling or is responsible for the platforms. Therefore, if we had a problem with the platform, the right bureaucratic way to go about getting a resolution is that we contact the service provider they have. They probably contact Microsoft. The process is bureaucratic.

I'm also familiar with other servers such as Oracle. While we must do as the client wants or needs, if I could choose, I would probably utilize databases like Oracle or open-source databases more often. It depends on the cases. That said, quite often I'm in a position where I cannot suggest the technology, so I use what the client requests.

We didn't pay anything for it as it was provided for our client by the provider. I cannot say about the enterprise licenses or anything. When we began the work and we needed it for our own machines, I prefer the solutions which are available, of course, as open-source or are free. And Microsoft had this express version of their database which we can utilize as well. In that sense, it is okay, however, of course, in general, I don't know.

I've been working for a client as a consultant so I'm helping them with deployments. With one client, we're using on-premises deployments. Our client has their own service provider or service operator so they have their own IT partner who is handling their databases. If I have understood it correctly, the databases were on-premises for our client, however, it's a bit complicated when you are having and dealing with large-scale public sector actors in Finland. There are plenty of kinds of players involved.

Whether or not I would recommend the solution depends. If you are utilizing some solutions where you need the Microsoft platform-based database, it's completely okay. And if you have, for example, the solutions where you have utilized Transact-SQL or whatever, it's okay. However, if you have this kind of situation where you can make your own choices freely, you have options. And if you're utilizing Java or C, et cetera, quite often the path or logic would go towards some of the databases on the Microsoft side.

There is no clear answer. Quite often when you begin to think about your solution or you think about what you are building, the database is the first thing you decide on. There are other factors too, such as a business case or if you're just building from scratch and so on and so on. I wouldn't like to say that I never would recommend it, however, if you are building everything from the scratch and you can make all the decisions, likely it is not the first option you have or I'd suggest. 

I'd rate the solution at an eight out of ten.

We use this solution as our database.

It could be more stable.

I have been using SQL Server for four or five years.

SQL Server is a stable solution, but it could be improved.

Similar to Microsoft SQL, it is easy to scale.

We have a team of 300 people who are using this solution.

I have not contacted technical support.

Previously, I used MySQL.

I was not involved in the installation.

We have an IT team to complete the installation.

There is no licensing cost for SQL Server.

I am a user of this solution but I don't know that I understand it well enough to recommend it to others because I did not install it.

I would rate SQL Server a five out of ten.

We use a tool called Tosca for automation and all the automation artifacts we are saving are on the SQL Server.

The solution is easy to use and provides similar features to other competitors.

SQL Server could improve by increase the performance, it cannot handle large amounts of data. I did not find any additional features compared to others solutions.

I have been using this solution for a few years.

The solution is stable.

We have not scaled the solution extensively, but I do not foresee any problems.

We have been using Hadoop and Spark.

The installation and configuration are straightforward.

We have a team of three people doing the backend maintenance and application support for this solution.

We did not encounter any issues that we would need support. 

I would recommend this solution to others for small operations. For bigger applications with large amounts of data and a lot of users, I would not recommend it.

I rate SQL Server a six out of ten.

The solution is an RDBMS and can be used to simplify customers' requirements for a back-end database. The main function of the solution is to store information from front-end users.

The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application. Additionally, the solution is simple and if it is configured properly it performs very well. 

I have used the solution for approximately six years.

I find the solution to be very stable. 

The solution is scalable. 

The technical support is only provided to the customers having a subscription-based license with a Software Assurance server. For other forms of licensing the solution will not provide support. 

I have previously used other RDBMS solutions, such as Oracle MySQL, Maria DB, PostgreSQL, and IBM DB2.

When comparing PostgreSQL, Oracle MySQL, and Microsoft SQL, Microsoft SQL has an advantage over the other two server databases because it provides a graphical user interface by default.

The initial setup of the solution is very easy and the time it takes depends on the architecture required. If the deployment of a cluster is required then the setup may take up to three hours, whereas standard environment deployment needs half an hour. 

The solution can be installed by our selves but the use of an integrator makes it much easier. 

The solution requires authorization in either the form of perpetual licensing or subscription-based licenses for two years. If a perpetual license version is purchased then customers have it to the end of life, whereas a subscription-based called server with Software Assurance, has to be renewed every two years. 

The areas that need improvement are with regards to the commercial aspect of the solution, the licensing cost could be reduced in order to help customers to adopt it.

I would recommend this solution. However, the customer has to make sure it fits their use case.

I rate SQL Server a nine out of ten. 

We use this solution to manage our database and store information. I use another platform for more specific needs.

Within our organization, there are roughly 10-12 employees using this solution. 

SQL Server consumes a lot of resources. You need to keep an eye on the number of resources involved. It expands and uses all of the memory available on the server. For this reason, I install it on separate machines.

Also, the ability to connect with other environments needs to be improved. 

I have been using SQL Server for nearly 10 years.

Scalability-wise, it's okay.

I haven't really experienced any issues that required the assistance of technical support. 

I also use MySQL — the open-source version. I started using SQL Server because we required some special functionality for a specific project. 

The initial setup was not complicated. You can do it without any external support. 

I installed the entire solution myself within 20-50 minutes.

The price could always be lower. 

I evaluated Oracle, but I didn't like it — I prefer Microsoft. 

I would absolutely recommend this solution to others. Overall, on a scale from one to ten, I would give this solution a rating of eight. 

We are using SQL Server for the backend of our SAP and are planning on moving to a cloud version soon.

This solution has helped our organization by providing a backbone for our SAP. We would not be able to operate without it.

We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.

We are using an older version of SQL Server and the migration to a newer version could be made easier.

If you are a new user then this solution could be difficult, they could improve by making the overall usage easier.

In an upcoming release, they could improve the ability to customize the solution.

I have been using SQL Server for approximately ten years.

We have not experienced any problems with the stability of this solution.

SQL Server is scalable.

We have not used the support from Microsoft. However, we did have freelance support a few times.

The installation is very easy. We did not have any challenges.

The price of the solution is very expensive. If I went with the cloud version of SQL a license would cost me approximately 11,000 Riyals per month.

We have a team that has evaluated other solutions before we chose SQL Server, such as Oracle.

I would recommend this solution. However, Oracle has a good reputation for quality that might be a better choice.

I rate SQL Server an eight out of ten.

I have been working on SQL Server for installations, configuring for developers, and for creating backup jobs from the MBF files.

The solution is very easy to use.

SQL Server needs to improve in performance and monitoring because there are no specific monitoring solutions to detect and analyze events for issues in the database. You have to use another monitoring solution. If Microsoft could provide an update to this solution or provide a monitoring solution specifically for SQL Server, it would be very valuable.

I have been using this solution for approximately three years.

I have found the SQL Server stable.

The solution is highly scalable. You are able to implement a SQL cluster mechanism for replicating the data between two nodes of the SQL Server. If one of the nodes is down the second node becomes active.

We have approximately 20 developers working directly with SQL Server and approximately 1,000 end-users that are working on the application that is behind the SQL Server.

The technical support is good. We had a big problem and after an investigation, we could not find the solution. We needed to make use of Microsoft support team and open a specific case on the Microsoft panel. They were able to provide solutions for solving this issue.

I have used MySQL.

The installation is not very complex. However, the process could take a long time because you have to follow the step-by-step instructions for the installation. The time it takes to do the installation is approximately two days.

There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford.

I would recommend this solution to others.

I rate SQL Server a seven out of ten.

The solution is a part of a product. We use it for our database, among other items.

The solution is very stable.

The product scales well.

From a security perspective, we have no complaints. 

The initial setup is very straightforward. 

The solution should work to improve its search functionality.

It would be ideal if the solution offered better integration capabilities. In the future, we expect that our company will need to make more integrations with other systems.

I've been using the solution for three years. It hasn't been that long.

So far, the stability has been very good. We haven't experienced any crashed or anything of that nature. There are no bugs or glitches. It's reliable and the performance is good.

The solution is very scalable. The only thing that would limit its ability to expand is how your environment is designed. That said, a company should have no trouble scaling it if they would like to.

There are only five of us using the solution right now.

We do plan to increase usage in the future.

While I haven't had a chance to open a ticket with technical support, I plan to open one next week, as I have an issue I need to ask them about. However, since I have yet to be in contact, I cannot evaluate their level of service.

The initial setup is not complex or difficult. It's easy. It's very straightforward and the setup guide is available if you Google it. Anyone can search for the installation guide on whichever version you're installing.

The deployment is quick. It only takes about 30 minutes or so.

We have a technical team of five engineers. If any maintenance is needed, we can handle it. 

I installed the product myself. I found an installation guide and just followed the directions. I didn't need the help of a consultant or integrator.

We do not currently pay a licensing fee in order to use this product.

I'm currently using the 2017 version. I am not using the latest version of the solution.

In general, I would rate it at an eight out of ten. For the most part, we have been satisfied with its capabilities.

I'd recommend the solution to other users and organizations.