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 , , , ,

Screen tearing when playing flash-videos in unity

In Ubuntu 13.04, as already under 12.10 and 12.04, there is a notable screen tearing problem, when playing videos in fullscreen, using Intel HD 3000 graphics and Unity-Shell.

To resolve this issue, you’ll need CompizConfigSettingsManager:

sudo apt-get install compizconfig-settings-manager

Continue reading

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 , , , , ,