Blog

If you are looking to add a new database system for your company, you will probably be using either MySQL or MS SQL Server. They are the most common relational database management systems. However, there are some significant differences. The most significant difference is this: 1. MySQL is open-source 2. MS SQL Server is developed by Microsoft.

Could custom software development be just what your business needs in order to thrive? In today’s article, we will discuss whether micro services or monolithic is the better way for you to automate your manual procedures. If you are not sure what those terms refer to, don’t worry. We’re going to help you to know which method of software architecture is more efficient for your company’s clients.

Our company migrated a legacy Visual FoxPro desktop accounting application to a web-based multi-tenant SaaS system using Alpha Anywhere. Using advanced client-side scripting techniques to provide a high level of scalability, the application takes full advantage of the capabilities of Alpha Anywhere as a visual client. Our company has a team of Alpha AnyWhere Software experts that use the latest combination of JavaScript, SQL Stored procedures, and advanced coding practices. In Alpha Five to create user interfaces that are both visually appealing and highly efficient.

Do you use stored procedures? Some developers said, we don’t use it. Too much of a hassle. We would rather use one development tool to encapsulate all in one set of code. I was interviewing a dot net developer for a web scarping project and I asked him, if he can show me what stored procedures he worked lately. I was amazed to realize that the developer has difficulties to identify different features in MS SQL and basically does not work with any SP. He said all is done within the entity framework and LinQ.

In a previous article: MySQL Remote DBA Consultant helped the client to scale up, We discussed a situation where a client had a MySQL server that had 1,100 databases and was using it with a SaaS application. We do not want you to think that having separate databases per client is always a bad idea. There are some real advantages with using separate databases for each client, so we want to go over those also so that you can determine the best way to design your database and structure for your SaaS app.

From some reason when I first ran MS SQL 2019 I realized when I run some code with Carriage Return Return and Line Break it stays in one line after coping that into a note pad or below the SQL code in Microsoft SQL Server Studio. So, what happened here? After digging deep into it I found out that this feature that worked as default from MS SQL 2014 and below is not working as a default feature anymore. You need to set it up in order to make that work.

You want the best quality software, but you also don’t want to waste time. That is the purpose of the software development life cycle. How can you get from the idea to a fully functional program in the least amount of time? You have to work within a series of steps that produce the best quality applications in the least amount of time. Of course, for the best results, the steps need to include testing the software before release so that you don’t end up having to fix bugs on the fly. Also, while there are a few different viewpoints as to the best SDLC model, they all follow a basic pattern to get your company from point A to point B in the most efficient way.

We are often approached by Clients to, either improve their existing MS Access application or, to convert Access to Web. In many cases the original MS Access Developer is not available anymore. Which means we have to reverse engineer the MS Access application to establish what it does before we can improve or covert it to Web.