VIM - Minimal Setup Explained
If you're a vim user and want a minimal set up read Sven Guckes' VIM - Minimal Setup Explained.
Various Meanings of SQL’s PARTITION BY Syntax
For SQL beginners, there’s a bit of an esoteric syntax named
PARTITION BY, which appears all over the place in SQL. It always has a similar meaning, though in quite different contexts. The meaning is similar to that ofGROUP BY, namely to group/partition data sets by some grouping/partitioning criteria.
A almost perfect rsync over ssh backup script
Creating backups is a basic necessity for anyone who stores data. With the help of a dedicated server, the Linux operating system and the rsync software, you can securely and efficiently retrieve data from any computer via an SSH connection and store it in a backup. It doesn’t matter if there is another Linux server, a Mac or a Windows computer on the other side. But as soon as you have more than a few text files, you have to control the process precisely. This script contains some important elements, which are essential when dealing with large amounts of data and slow internet lines.
Source: A almost perfect rsync over ssh backup script, an article by Thomas Hezel.