SQL Server Reviews

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

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.

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.

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.

This is a stable product. 

This product is scalable, we have between 20 and 30 users in our company. We'll continue to use this product. 

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. 

The initial setup is straightforward, you can install with basic knowledge. Installation doesn't take long at all, I did it myself. 

There are no annual licensing fees, you pay when you use the product. 

I rate this solution a nine out of 10.

Public Cloud

We use this solution for data warehousing and products to the platforms developed by the company. 

We like everything. We use all of the features that SQL offers. 

We like business integration, database, and analysis.

I would like to see more integration with other platforms.

I have used this solution for more than ten years

We are using the latest version.

It's a stable product.

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.

Technical support is okay. We don't have any issues with them.

The initial setup was straightforward.

It took a couple of hours to install, no more than that.

We completed the implementation ourselves.

We have a team of 34 admins and engineers to deploy and maintain this solution.

We purchased our license and the pricing is fine for us. 

I would recommend this solution to others.

I would rate SQL Server a nine out of ten.

On-premises

I use SQL Server for .NET. We have ERP software in the background and we use the SQL Server for its creation.

SQL Server and their offers are very good. You can switch over, export, and do other things. I got access from users and it is very flexible to use.

SQL Server is technically good. For questions or other queries, we go through the internet and they explain it there. I think the structure of their product is good.

I have been using SQL Server for one year and a month.

It's stable. It was very easy for me to handle it.

The free version of SQL Server is time-limited before updating to the paid version. So, sort of more access and more work in your database to help process most of the time. It's better to purchase it for more secure functions.

We have a technical support engineer who handles maintenance and security for SQL Server. I think Microsoft's technical support is also very good.

It's a straightforward installation. I installed SQL Server 2012, 2013 and 2016.

The usability of the free version is limited. They also have some guidelines on how to use the paid ones. You still have to check your IT requirements after purchasing it. We are using a licensed one right now, which has more functionality than the free version.

Hybrid Cloud

Amazon Web Services (AWS)