SQL Server Reviews

We're using it for our on-premise servers, and we have the latest version of SQL Server.  

We use SQL Server for the database for Microsoft Navision. We also use it for the Track-It application that helps users in logging in their IT requests. We also manage all the IT inventory through Track-It. It does automatic auditing and traces online IT equipment.

We have end-computing devices with a server-client type of model. We have a server. All terminals are dumb terminals, but they get connectivity from SQL Server, and it has worked really well. We operate in difficult locations, such as Mombasa in Kenya and Mozambique in Maputo, where power is a big problem. Instead of desktop computers, we went for thin end-computing clients, and it worked really well with SQL Server.

It is a stable product, and it runs seamlessly. It is not complex.

It has been there for a long time, and they are doing whatever bug fixes they have to do. 

They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers.

I have been using SQL Server for ten years.

It is a stable product.

It has pretty good scalability. In terms of usage, we have two different types of usage. For end-computing usage, we have about 600 or 700 students who use the media labs. For Microsoft Navision and Track-It, we have about 100 staff members as users. 

It is being used fairly extensively. Microsoft Navision is one of the core solutions of our business, and it is used on a daily basis. End computing is used by students. Because of the pandemic, for the last 14 months, everything is closed, and everybody is remote, so end computing has not been used, but Navision continued to be used. After the school reopens in each location, we will continue to use it even more. We definitely have plans for expansion.

Their response is fast.

Its initial setup is very straightforward. In case there is an issue, Microsoft's tech support people come online and help you.

For its deployment and maintenance, two people are required at each location. We have one database specialist and one IT service delivery engineer with networking knowledge.

It comes with the bundle package that we have. We have Microsoft Volume Licensing, so we don't have to pay for it separately. It is a part of the package.

I would definitely recommend this solution. I have nothing to complain about.

I would rate SQL Server a nine out of ten. 

On-premises

SQL Server is enterprise database software. It provides the back end for any number of different applications, including web applications, and other types of internal applications, and software-based applications. It also provides a back end for enterprise backup tools. It's incredibly diverse in terms of its use case.

Scalability, cluster ability, ease of use, ease of implementation — these are all great. 

In terms of exceptionally large databases, it doesn't scale as well as Oracle. It scales excellently and it's flexible and it can provide a solution for exceptionally large databases, but it doesn't work as well as Oracle does for this particular use case. The performance starts to drag in the case of exceptionally large databases; especially where there's a lot more feature functionality. With Oracle, there's a lot more tunability.

I have been working with this product for 20 years. 

It's exceptionally stable. The ease of implementation and the ease of use can't be beaten. I think it's outstanding overall.

Scalability-wise, it's outstanding. The one limitation it has is that at the very, very high end of petabytes-sized databases, it doesn't scale as well as Oracle. Still, you're not going to run into very many exceptionally large databases. Almost 100% of the use cases for it scale very well.

Technical support is available for a separate cost. If you don't have a subscription or a support contract, then you don't get support. You'll be stuck with online forums — that's how you'll have to get answers to questions. Assuming you have a support contract with Microsoft, it's outstanding.

The initial setup was straightforward. 

This solution is available at a much lower price point than Oracle. Plus, it includes 99% of the same feature functionality. I'd say it knocks ROI out of the park.

If you're interested in using this product, make sure that you have a good understanding of best practices for database implementation. Make sure to incorporate them in your deployment right off the bat. You won't want to have to go back and have to take production databases down because you have to change the configuration, post-implementation. Make sure you get all of these things done, pre-production implementation.

They've come a long, long way in the 20 years I've been working with them. Overall, on a scale from one to ten, I would give SQL Server a rating of nine.

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. 

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. 

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. 

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

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

The solution seems scalable to me. 

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

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. 

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

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

I rate SQL Server as a seven out of ten. 

We develop software for another company. We mainly develop on-premises solutions.

We use this solution with our accounting ERP software. Our product is called Orchida ERP and we have many clients in Egypt who are using this software. Its database is SQL Server.

We mainly work in ERP. 

We currently have a small project in SharePoint for Microsoft, but 80% of our work is with Orchida ERP

We have our software with SQL server for 20 years. Our software will not work without SQL Server. 

We provide consultancy in installing this solution for our clients.

It is easy to maintain, and it's easy to set up.

It is also easy to develop. Overall, it's easy.

It can work with many different sizes of data, anywhere from 10 to 50 gigs of data.

The performance of SQL Server is perfect. It does not need to be enhanced.

If you work with more than 50 gigs of data, it will run slower than Oracle.

Security is an area that can be improved. It could be more secure; more security is needed.

We have some clients who have been exposed to the SQL injection virus. 

We would like SQL to be able to manage this problem or to come up with an alerting system to alert the user that the server has been exposed. This has become more of an issue because of the Corona Virus and people are working from home.

Some have been infected by the SQL injection Virus and will lose their data.

I have been using  SQL Server for 20 years.

Most of our clients work with version 14 and version 19, which is the latest.

It's a stable solution.

SQL Server is scalable. Our clients are medium-sized companies, not large. They don't have professional IT.

We have 20 people in our organization who are using this solution, but we have many clients who are using it. We sell our consultancy service to more than 200 clients every year.

If we have any issues, we search Google and the internet to resolve them.

Our company has not used Microsoft Support. 

We have tried many versions of Oracle, including Oracle 11, Oracle 12, and the latest version, which is easy to maintain and similar to Microsoft.

Some of our clients are also using Express SQL. It is not good, but also not bad. If you have small amounts of data then it will meet the requirements.

The installation is straightforward. It is easy, you continuously click the next button until you are done.

It takes 20 to 25 minutes to install. There are no issues with the installation, it is very basic.

We did not use an integrator, we have an in-house team to install and implement this solution.

Some of our clients purchase the license and others do not; they use Express SQL Server.

One of our clients is using an SQL Server on Linux. We don't use it but it is a very interesting product. It's a good trend, the Linux environment has become a market share that is growing in Egypt.

I would recommend this solution to others who are interested in using it.

We can't compare this solution with other databases, as we do not have enough experience with other similar tools. 

Overall, SQL Server is good. I would rate SQL Server an eight out of ten.

On-premises

We use SQL Server with Sage products.

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

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

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 04 Years now 

The solution could be more stable

The performance in terms of simultaneous connection must be reviewed.

We do not pay for technical support.

No

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.

great

The licensing involves a one-time fee.

We evaluated Oracle as an alternative.

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

On-premises

It is used for everything under the sun. We're currently using it for a health pass for a medic aid information management system. It is also used by companies in banking and retail.

We are using SQL Server 2014 on Windows Server 2012 platform, and we also have SQL Server 2016 on Windows Server 2016 platform. I have primarily worked on the hardware, but I am now also working in the Amazon AWS cloud.

The entire solution that we're deploying is built on Microsoft SQL Server as a database engine. Our solution is completely engineered for that, and if we attempt to deploy it in any other database engine, it is going to be a huge nightmare.

Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms.

Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities.  The native SQL Server Backups take more time than do the backup processes from LiteSpeed, and the backup compression is a little less.  

I have been using SQL Server since version 6.5, which came out about 30 years ago.

It is very stable.

It is very scalable. You can run the database engine on the C drive, or you can run it on a large cloud array or a disk array. Currently, we just have developers and testers accessing it.

Technical support from Microsoft is very good.

If you know how to set it up, it is easy, but you have to learn that over time. For a new user, it is detailed. You need to have the right things in place at the right time before you actually install the software.

To create an instance, it takes about an hour overall. This includes deploying the basic system, applying the latest service pack, and then applying the latest cumulative update.

It was an in-house job. In terms of maintenance, the number of staff members required would depend on the implementation. It requires coordination amongst teams. It is a team effort. The database administrator creates and runs the jobs that create the backup file. You need to have somebody for copying the backup files to offline storage. You also need to have system administrators for setting up the hardware.

I would advise others to just be familiar with Windows concepts.

I would rate SQL Server a nine out of ten. If you're familiar with Windows concepts, it just works.

Public Cloud

Amazon Web Services (AWS)

We use it for both database services and analysis services.

I believe Always On is the most valuable feature. It's also easy to use and not very tricky.

Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit.

I have been using SQL Server for about 15 years.

It's stable. The database service is better than the analysis service, but it's quite stable. It's as stable as the support it has. If it has a good infrastructure and good machines with disks, it's quite stable.

SQL Server is vertically scalable. We have about 3,000 people using this solution.

We haven't used their technical support a lot. I would say it depends on the scope of the help you need. On a scale from one to ten, I would give technical support a seven.

I don't know the exact prices because my focus is essentially technical and not on the bills. A few years ago, they changed the billing policy for the Enterprise Edition, and it became less attractive. But I believe they are still cheaper than Oracle. SQL Server isn't cheap, but it's not expensive either. 

I would tell potential users that it's important to have a good infrastructure, but my advice is for any database, not only SQL Server. It's important to have a good infrastructure and a good network if you're planning to use Always On and clusters. I believe the most important thing is the infrastructure where the SQL Server will be based.

On a scale from one to ten, I would give SQL Server an eight.

We are primarily using the solution for pulling data and analysis.

In the auto industry, are the dealer management systems for which there is kind of portals from which the dealers are maintaining information can have access to retail data, bookings, and details surrounding individual customers.

We are fetching data and using it for analytics purposes, basically.

The basic features of the solution are excellent overall.

The initial setup isn't overly complex.

The pricing is reasonable.

The solution scales well.

The solutions very fast. It reads and writes six to eight times faster than any other tool.

The solution is very different from Oracle, which is a product we also use.

Mainly the data capacity needs to be improved. The data values are limited. They are smaller or medium scale. The MySQL is working fine, however, when it comes to large data sets or large data volumes, Oracle can handle them better. The backup capacity needs to be bigger.

When it's medium or small-scale data volume, people are referring to MySQL, however, when the data volume grows the people are referring to Oracle. In my estimation, the stability is fine.

The scalability of the product is pretty good. It can scale effectively and expands better than other options.

We have around 40 users on the solution currently.

Our main usage is not for the database and we simply use basic aspects of the platform.

Technical support isn't an aspect of the solution I know too much about. I've never been in direct contact with them. Therefore, I can't speak to how helpful or responsive they are. 

We also currently use Oracle. 

The initial setup isn't too complex or difficult. It's pretty straightforward. It's less complex of a process as compared to other solutions.

The cost isn't overly expensive. It's very reasonable. Our customers are happy with the price. It's in a good range.

We are partners with Microsoft. We use multiple deployment models, and typically those are private cloud or on-premises options.

Overall, I would rate the solution at an eight out of ten. We've been mostly very satisfied with the capabilities of the product. It's fast. It's our preferred product.

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

Private Cloud