Janik von Rotz

Compare Active Directory group membership

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

Read More...



Convert Directory Tree to Json with PowerShell

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

Read More...



Abandoned Berlin

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:

Nature is tacking back .

Read More...



Photography Filter Cheat Sheet

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

Read More...



The Brain Hack - Short Film

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



O3M 64 - Ridikulös

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

Read More...



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.

Read More...



O3M 63 - Beauty of Music

Georgous mix of some very good sounds.

Read More...



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

Read More...



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:

Read More...



27