Tag Archives: Problemlösung

ThinkPad HDD Led

On some (any?) new ThinkPad models, Lenovo has chosen not to add a hdd-led. E.g. on my new ThinkPad Edge E540.

Who is used to look at this led, when pc is stuck (it doesen’t change anything, but it is nice to know if it is working), will shurely miss it someday.

Under linux it is very simple to control the led, Lenovo uses as tittle on the ThinkPad logo. Continue reading

Tagged , , , , , , , , , ,

Checking two tables for equality

When developing DataWareHouses you often have to check if a new/optimized ETL has same results as the old version. So you have to check, if two database tables contain the same rows.

For two tables at the same database, or databases that are connected, this can be done by the following SQL statements.

Continue reading

Tagged , , , , ,

crontab: Tipp

Just add followind comment to your crontab…

#* * * * * command to be executed
#| | | | |
#| | | | +—— day of week (0 – 6) (Sunday=0)
#| | | +———— month (1 – 12)
#| | +—————— day of month (1 – 31)
#| +———————— hour (0 – 23)
#+—————————— min (0 – 59)

By suckup.de/ ( http://suckup.de/linux/crontab-tipp/ )

Tagged , , , ,

Disable Touchpad while typing

When your curser changes it's position while you are typing, then you propably hit your touchpad accidently…

This should be prevented by a functionality named "disable Touchpad while typing", which should diable your touchpad for a specified interval after pressing a key.

On one of my laptops (a Lenovo IdeaPad Z580 – Synaptics Touchpad) this interval is to short under Ubuntu 12.10 and so is mostly useless.

Continue reading

Tagged , , , , ,