O3M 64 - Ridikulös
Is it host outside? Then take your hammock, look for nice setup spot and listen this relaxing playlist.
SQL Cheat Sheet
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.
O3M 63 - Beauty of Music
Georgous mix of some very good sounds.
WordPress checklist
Simple todo list for new WordPress websites. I’ll use it whenever I have to setup a new WordPress site. You’re welcome to contribute: https://github.com/janikvonrotz/wordpress-checklist
PowerShell awesome list introduction
Awesome lists are a great thing on GitHub. It’s about collecting useful resources, packages and modules of a certain technology or subject. It’s the best way of introduction if you have to learn about a new technology. Here’s a good example of a awesome Node.js list by Sindre Sorhus aka the inventor of bower, grunt and many other web tech.
I thought it would be a good idea to do the same for PowerShell. Maybe you’ve got some inputs for me, simply post them in the comment section or make fork of the Awesome PowerShell repository and commit your inputs directly.
So here’s what I’ve got so far:
Kung Fury
Since last thursday you can watch the official Kung Fury movie on YouTube.
So what is Kung Fury about? Well, their website says:
Shenzen tower climb
Wow! These guys give me the chills. Vitaliy Raskalov and Vadim Makhorov two guys from russia have climbed the second highest tower in the world. Here’s a video of how the did it: Also check out their website, they’ve some pretty good photograhps: http://ontheroofs.com/
O3M 62 - PewPew
Don’t know what to say about this playlist, it’s one of my favorite so far. definitely tune in for the Major Lazer track, it’s absolutely gorgeous.
Results of my very important internet survey
First some backgroud informations about why I’ve published this kind of survey:
There are many pulbic survey tools, but none of them offers the as much features as LimeSurvey. To run surveys on my own, I’ve installed the LimeSurvey application on this server. For more insight of how the user interacts with the surveys I’ve added Piwik tracking for my LimeSurvey installation. To test the setup I’ve added a simple survey and posted the link to the SampleSize subreddit.
Enable Piwik for LimeSurvey
This post is part of my Your own Virtual Private Server hosting solution project.
Get the latest version of this article here: https://gist.github.com/1d5043a9f40760716def.
Introduction
Piwik is an Open Source webanalytics software. In this tutorial you’ll learn how to integrate the Piwiks plugin for LimeSurvey.