Sadly there’s no native Piwik plugin for the Koken photography CMS. However you can use another plugin the inject the tracking code to the footer of your site. Install the HTML Injector plugin (Site > Settings > Plugin > Download Plugins). Enable the plugin (Site > Settings > Plugin > HTML injector > Enable). Setup the plugin (Site > Settings > Plugin > HTML injector > Setup). Copy the tracking code of your Piwik site (Piwik > Administration > Websites > [site] > View Tracking code).

Read More...

I found the perfect tool to record desktop actions: Screen-To-Gif recorder. I’m using ScreenToGif almost every day to create short and precise online documations for my customer wiki. Here’s a gif recorded with ScreenToGif how I’m using ScreenToGif to create a gif of my desktop actions.

Read More...

Oh my gosh, second round! Is this real? Yes indeed it is sir!

Read More...

The following scripts allows you to compare the group membership of two users.

Read More...

Today I wrote a simple script that converts a directory tree query with get-childitem into a json formatted data tree.

Read More...

Berlin is very famous for it’s deserted and abandoned places. Last week I spent 3 days there doing parkour and take photos. Here are some impressions of my short Berlin trip:

Read More...

Ever wondered what effect photography filters have on the resulting image? Well here’s a handy guide:

Read More...

A friend of mine told me to watch The Brain Hack on Vimeo. It’s a short film about the perception of god. This movie literally blew me mind. You have to watch it!

Read More...

Is it host outside? Then take your hammock, look for nice setup spot and listen this relaxing playlist.

Read More...

You can get the latest version of this SQL cheat sheet here: https://gist.github.com/janikvonrotz/6e27788f662fcdbba3fb

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

Read More...