Calendar

March 2010
S M T W T F S
« Feb    
 123456
78910111213
14151617181920
21222324252627
28293031  

Oracle Performance Tuning

Recently I am struggling to deal with the performance tuning of oracle databases. As we used Baan IVc4 and Oracle 9i, it keeps growing the data space of index and data. It has been 7 years without much actions to the database performance.

The thing I would like to tackle is that I must rebuild some [...]

Baan ASCII Functions

Last week I was asked to verify the item description to exclude certain characters and to limit the first character with 0-9 and A-Z. As some of the characters such as double quote (“) and semicolon (;) can not be easily used in the expressions, I finally decided to use the value of ASCII alternatively.

There [...]

Migrate Loftware to VMWare ESX

Recently we were migrating a physical server to a virtual machine, and upgrading Loftware Barcode Printer Server from version 8 to 9.5.2. Although it does not go smoothly from the beginning, we finally figured it out.

The main consideration is to replace the physical USB dongle key with soft license key. In order to minimize the [...]

B2Win – Convert Baan Reports to Excel/Word/PDF/XML/HTML

We recently deploy a small add-on tool for Baan, which enables users to download Baan Reports directly into Excel, Word, PDF, XML, HTML or Emails. I used the B2Win Version 4 since 2000, but the latest version now is 6.5.

B2Win is one product provide by an Israel company named NAZDAQ, who dedicates to provide add-ons [...]