SSH tunneling is, of course, useful for a ton of services, but I happened to stumble upon it, when I wanted to connect to a remote redis server.

If you have a redis server running on , you can easily connect
to it (given you have ssh access to it, of course):

ssh -L 9999:localhost:6379 @

will open a tunnel from the remote port 6379 (redis standard) to the local port 9999.

You can now use the redis on your local port 9999 like you would if it was running locally. Nice.