Blog

(Articles with tag:MS SQL Remote DBA) - Remove Filter

When To Use One Big Database vs Many Smaller Databases For SaaS Application?

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.

How to Insert Carriage Return or Line Break Or Tab into a string in MS SQL Server

From some reason when I first ran MS SQL 2016 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.

SDLC as Software Development Life Cycle, Increases Quality Speed and Reduces Cost:

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.

What Is Alpha AnyWhere Software Development?

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.