What is our primary use case?
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.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using SQL Server for 20 years.
Most of our clients work with version 14 and version 19, which is the latest.
What do I think about the stability of the solution?
What do I think about the scalability of the 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.
How are customer service and technical support?
If we have any issues, we search Google and the internet to resolve them.
Our company has not used Microsoft Support.
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
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.
What about the implementation team?
We did not use an integrator, we have an in-house team to install and implement this solution.
What's my experience with pricing, setup cost, and licensing?
Some of our clients purchase the license and others do not; they use Express SQL Server.
Which other solutions did I evaluate?
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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner