General Articles

Microsoft Excel VLOOKUP Function – Looking Up Values in an MS Excel Database or Table

Consider a simple spreadsheet in Microsoft Excel, which contains a table of data in columns A to C as follows:

Column A – the unique …

Activity Monitoring for Database Management

Just a few years ago, the primary concern of most database administrators (DBAs) was file storage space. Most of our time was spent monitoring disk space usage and optimizing how much was being used and …

Windows 7 Registry Cleaner That Works Well and is Reliable

Windows 7 might be one of the latest operating systems, but it still suffers from all the problems that the registry causes. This is a big problem that even the …

A Guide to Choosing the Best Registry Cleaner

With so many registry cleaners out there, it’s essential that you are able to use the tool that works best on your PC. Fortunately, we’ve been using these tools for several years …

How to Install Oracle on OpenSuSe Linux

I recently upgraded my Linux installation to the latest OpenSuSe 11.2 release and then decided to install also the free version of the Oracle database (Oracle-XE or Oracle Express)..

The installation of Oracle …

IT and Business Database: A Perfect Combination

Why should we try IT telemarketing? Well, it’s for the same reason that we want to try working with a business database provider: we want to be on top of our game. That’s …

What’s the Buzz on Keywords?

If you are on the hunt for a new job, you have probably heard the reminders to make sure you have “keywords” included in your resume. So, what exactly are keywords and where do you …