Watashi wa pengin desu.

Watashi wa pengin desu.
Minä olen pingviini.

Easy way to convert audio-only ASF to MP3 / WAV

Follow these steps:
1) Download and install latest version of Goldwave
2) Open ASF-file with Goldwave
3) Save it to WAV or MP3. There are many other formats, too.

Suggested bitrate for new MP3-file is same as the original ASF-file had.

Note, Goldwave uses LAME MP3 Encoder, so Goldwave will ask for "lame_enc.dll" at the first run. If you don't have it already, download it from The LAME Project page.

ts2bluray (dvd)

Mini-ohje miten HD Transport Stream (.ts) "muutetaan" Blu-ray-yhteensopivaksi ja poltetaan DVD:lle. Blu-ray -levyä ei tarvita. Toimii Playstation 3:ssa ja Blu-ray soittimessa. Mutta Blu-ray soitin testattu.

Replace a string in Oracle database field

update myTable a set someField = replace (a.someField,'Ä','A') where someField is not null;
update myTable a set someField = replace (a.someField,'Ö','ö') where someField is not null;
update myTable a set someField = replace (a.someField,'Å','A') where someField is not null;

Oracle Case-When example

select
product,
company,
case when category = 'Microsoft'
then 'Yes!!'
else 'No'
end as microsoft_spotted
from
products
;

List all tables in your Oracle database

select owner, table_name from all_tables;
select * from all_tables;
more on ss64.com

Howto register Dll and Exe in command-line

To un/register Dll:
c:\>regsvr32 "C:\Windows\System32\My.dll"
c:\>regsvr32 /u "C:\Windows\System32\My.dll"

To un/register Exe:
c:\>"C:\Program Files\MyAppLocation\My.exe" /REGSERVER
c:\>"C:\Program Files\MyAppLocation\My.exe" /UNREGSERVER