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.
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.
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.