Blog
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.
We provide custom software development and many times we get phone calls from new Clients regarding their MS Access application. In many cases the Clients still have feelings towards their old application, and simply want us improve it or fix some other ms access developer’s bugs. The application could have been developed more than 20 years ago and the developer nowhere to be found. Convert MS Access to a web application could be another solution. In this case you can use the old application for some of business rules.
Today, we are going to take a look at four exciting case studies: custom projects we have developed. The four software projects are: Avis Car Rental Contact Manager , No Interest Loans Account Management, Accounting Software for School Districts and Payroll Salaries Software for Employees of School Districts. Once you see the powerful custom software development our team can perform, you will want us on your next project. From desktop to web to mobile applications, we do it all! Plus, we have a team of remote database administrators to ensure your optimized database keeps all of your new applications running at lightning-fast speeds.
Alpha AnyWhere is a software development solution design to speed up the custom software development process. Farber Consulting Group has experience with Alpha AnyWhere software development and used this design solution when creating a contract manager for Avis Car Rental. We have also used it to develop accounting and payroll systems for school districts in NJ and to create an accounting system for a non-profit organization (just to name a few of our big projects). The development engine is incredibly powerful when it comes to designing mobile applications, so the “anywhere” part of the development engine name is very fitting.
We got an urgent call from a new client that has many clients of its own. They do have a SaaS application with more than 1000 clients. Our consulting firm provides MySQL and MS SQL as remote dba services. They needed help with MySQL database right away. Imagine the client has SaaS app with more than 1000 clients of his own. For every client there is one dedicated database. Obviously, the client created a nightmare maintenance for himself. Just to spice up the situation every database seems different then the other one. Either the indexes are different, or in some cases some columns in certain tables are different. A Real mess!