Blog

Jul 06/2017

6 Reasons Why You Should Choose Alpha AnyWhere for Your Company's Custom Software Development

At the Farber Consulting Group, our Alpha AnyWhere (formerly Alpha Five) developers work to create and maintain customized software for our clients. It is one of our specialties, along with things like MS SQL consulting. Why should you choose Alpha AnyWhere as the engine for all of your custom software development needs? We’re going to take a closer look at 6 things that set Alpha AnyWhere apart and make it the perfect development tool for your project.

Jun 29/2017

10 Indications Your Company Needs Custom Software Development

Are you wondering if custom software development is the right direction to take for your business? Whether you are a New York or New Jersey company looking for new software or a complete revamp of existing systems, here are 10 signs that you should invest in custom software development rather than buying an existing software package.

Jan 17/2016

Recover your data when SQL table is Deleted by Accident without any backup

How to Recover your data when SQL Server table is deleted by accident from your database without any backup. We have the solution for you...

Jan 04/2016

Develop Messaging System for Multi-Tenant Application

Multi-Tenant Database Application for Sending Messages Or News To Thousands of Users Hey, I am Eric from the Farber Consulting Group Inc., providing custom software development and database cleasing since 1992 and Remote DBA services as well. In addition, we provide database design services to fully optimized your database . Will be talking about the

Nov 22/2015

MS Access Developers the Best Error Handler

My buddy Bill Walker started a great conversation about MS Access development error handler that impressed us all. I thought it would be a great idea to share the below info with everyone else.

Oct 25/2015

Alpha Five Developers Steps to Add Multiple Images as Logo in Alpha AnyWhere Report

As the company evolves, the application is a work in progress and requires updates, they are in the process of acquiring another car rental company, Payless, while already having Budget as a subsidiary. This required us to design a versatile report for the rental contract with a similar structure for all three companies, but malleable and flexible enough to use for the same three.

Aug 02/2015

The Importance Of Clustered Index To Improve Database Performance In SQL

Clustered Index In Each Table Will Improve Your Database Performance In SQL When working with MS SQL every table should have a clustered index, preferably on the primary key field. The clustered index definition in SQL Server logically sorts the data adjacent to each other in that index key.

Jun 28/2015

Reverse Database Engineering and Database Design

In many cases, we have an existing database but don’t have the original E-R diagram or physical model. Reverse Database Engineering allows us to reconstruct a physical and/or ER model from an existing schema.

Mar 01/2015

Create report in Alpha Five - One Report Does It All With Alpha Anywhere

This is a technique that can save you a lot of time and effort when creating Alpha Anywhere reports. No longer is there a need to create a report for every single type of scenario. We are going to show you how to create versatile reports capable of being used in many different scenarios.

Feb 07/2015

Moving from MS Access to a Web Application

Every one of us at least once had to deal with such predicament when someone accidently deletes a table without any backup to recover it. Even though you have deleted the table, you can still access the pages that are used until they get overwritten by other SQL transactions....

Apr 14/2014

Why Convert Access To SQL

The Advantages of Converting from MS Access to SQL Server is that the performance, and processing time are all significantly improved.

Feb 16/2014

Create Unique Invoice Number in SQL

A better solution will have a separate table so you can generate Invoice numbers. This way you let IDENTITY field work for you with any Insert as shown in the below Stored Procedure.

Feb 13/2014

How to solve identity problem in SQL 2012

Microsoft changed the Identity behavior to jump in increment of 1000 or 10000 whenever the SQL Server 2012 restart. For example: we have a Primary Key that was 10012, if you re-start the SQL server instant, then in the next Insert record you will get the Primary Key as 11012.

Jan 23/2014

How to disable User Account Control in Windows Server 2012

Running any program and dealing with the UAC could be a hassle and that process also evaluates if the user has the rights to proceed with the program any further. If you need to remove the below UAC and save you the additional click then follow some basic steps to accomplish just that.

Dec 13/2013

SQL Consulting

We are experts at SQL Server database administration, performance tuning and database optimization to maximize your company's productivity. In our team we have MS SQL MVP consultant and our highest experience person has 26 years of database solutions. We are located in central NJ and provide MS SQL consulting solutions all over the USA.

Jul 22/2013

Remote DBA

Why do you need Remote DBA or Database Administrator for your company? A Microsoft SQL remote Database Administrator service is one that answers the call for all your database administration needs.

Apr 02/2013

Optimize your sql query for best search result

When developing solutions that require querying large amount of data, you may want to consider user Stored Procedures. When accessing multiple "query patterns", you want to program your system to use the most efficient algorithm to return your data to the user. While using dynamic SQL may work for small databases, a preferred method would be to use a Stored Procedure to optimize performance.

Mar 11/2013

Splitting an Address into Street Number and Street Name in SQL

Attempting to improve search performance when querying on multiple fields (such as First Name, Last Name, Address, City and State) can sometimes could be a bit tricky. Performance improvements can be achieved by splitting the address into separate Street Number and Street Name fields.

Dec 26/2011

Remove Duplicate Records in SQL

In MS SQL 2005 and later editions, a much better way has been provided to remove duplicate records smartly, while having full control of which records to remove. It can be accomplished by using the ROW_NUMBER() which will return a number of row within a partition of a result set. With this code:

Aug 22/2011

ERP Software Selection

You are an owner of a small or medium size company, and you need to select ERP software to run your business. You are confused between the large availability of ERP software packages. How do you select the right one for your business, and how do you find one you can afford?

• 1(current)
• 2