Contact Us

Blog

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

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.

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.

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.

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.

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.

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.

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.

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.

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?

Benefits of ERP Software for Small or Medium Size Businesses

If you are a typical stakeholder of a small or medium size business, you probably prefer to invest in assets that contribute directly to the growth and revenue of your business (for example, tools for making your product, machines to expand capacity, people to design and sell your product, etc.). You know that information technology and business software is important, but you ...