Showing Outlook 2007 Calendar Appointments in Different Colors for Different Statuses

In Outlook 2003's calendar, appointments and meetings marked as "Free", "Tentative", "Busy", and "Out of Office" all automatically appeared differently on the calendar view to make it easy to visually distinguish them. Outlook 2007 offers the same "Show time as" options, but does not automatically visually distinguish these statuses by default.

I wanted this feature back in Outlook 2007, because I use my calendar not only to block out time for meeting and appointments which I mark as "Busy", but also as reminders for things I'd like to do if convenient, which I mark as "Free". Items I mark as "Free" are things like "Read the corporate newsletter", "Drink water", etc.

One way to visually distinguish meetings and appointments in Outlook 2007 is to manually assign each meeting and appointment a category which is associated with a color. This is what I did at first, but thought there must be a better way.

Oracle Wallet and tracing didn't work when executed by cron jobs

For those who may find it helpful, here's a problem I ran into along with the solution.

When a Korn shell script using Oracle 10gR2 client's sqlplus was run manually at the command prompt, the script successfully used an Oracle Wallet to log in and run an SQL script.

However, when the same ksh script was run with a cron job, I would get the following error:
"ORA-12534: TNS:operation not supported".

Workaround for SQL*Loader-297/ORA-01756 problem

Upgraded Oracle SQL*Loader (a.k.a. sqlldr) from a 9i version to a 10gR2 version on two computers, with release 10.2.0.1.0 on one computer and release 10.2.0.4.0 on the other.

Some ctl files have the following line:

flag "'N'",

When I'd run sqlldr release 10.2.0.4.0 or the 9i version of sqlldr, the above line caused no problems.

But when I'd run it on release 10.2.0.1.0, I'd get this error:

SQL*Loader-297: Invalid syntax or bind variable in SQL string for column FLAG.
ORA-01756: quoted string not properly terminated

I found I was able to get the ctl files to work with release 10.2.0.1.0 by changing the problematic line to this:

Outlook 2007 changing font and other formatting on reply or forward

Outlook 2007 is driving me crazy: I'll reply to an email using my default Outlook font of Calibri. Then I'll open the email I just sent from the "Sent Items" folder and find that the text I just wrote get converted to Time New Roman font. Also, the font for the text for all preceding emails was usually, but not always, also converted to Times New Roman. For example, in an email I'm looking at right now that has a long string of replies from different people, some people's signature line text got converted to Times New Roman, but some signature lines did not.

Value of Excel Formula Won't Show

This problem has driven me nuts on more than one occassion, so I am documenting the solution here for reference. Maybe this will help you.

Problem: Enter formula into cell such as "=B2". After entering formula, instead of seeing the value of the B2 cell, you see "=B2".

Connecting a Sony KDL-19M4000 HDTV to a Sony Vaio PCG-V505BCP laptop

It took me some hours to figure out how to get a Sony Vaio PCG-V505BCP laptop running Windows XP Professional to work with a Sony KDL-19M4000 HDTV the way I wanted it to, so I'm posting these instructions in case they might help someone else.

The instructions haven't been completely walked through end to end yet—they are based on notes. So there may be some missing, unnecessary, and/or incorrect steps.