Skip to content

Instantly share code, notes, and snippets.

Janik Vonrotz janikvonrotz

Block or report user

Report or block janikvonrotz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
janikvonrotz / Delete-AllCmdKeyCredentials.ps1
Created Dec 6, 2013
PowerShell: Delete all cmdkey credentials #PowerShell #Windows
View Delete-AllCmdKeyCredentials.ps1
cmdkey /list | ForEach-Object{if($_ -like "*Ziel:*"){cmdkey /del:($_ -replace " ","" -replace "Ziel:","")}}
janikvonrotz / SQL Cheat
Last active May 23, 2020
SQL Cheat Sheet#SQL#Markdown
View SQL Cheat

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.


Text types

janikvonrotz / Get-AllSPLists.ps1
Last active May 14, 2020
PowerShell: Get SharePoint Site Collection Objects #PowerShell #SharePoint
View Get-AllSPLists.ps1
Get-SPsite -Limit all | %{
$_ | Get-SPWeb -Limit all | %{
$_.Lists | %{
janikvonrotz / Unattended Encrypted Incremental Backup to Amazon
Last active May 8, 2020
Ubuntu: Unattended Encrypted Incremental Backup to Amazon S3#AmazonAWS#Markdown
View Unattended Encrypted Incremental Backup to Amazon


For this task we are going to configure a duplicity script wrapper. Unregarded of the installation instructions it's expected that you have already signed up for an Amazon account and know how to use their services.


  • Ubuntu server
  • duplicity, Git, GnuPG
  • MySQL
janikvonrotz / Check System
Last active Apr 20, 2020
Ubuntu: Check System Resources #Ubuntu
View Check System
# disk space
df -h
# ram in mega bytes
free -m
# detailed ram usage
View Pull all git projects.ps1
$gitUser = @(
View Backup to external

Backupt to external drive

robocopy C:\Users\janik\LocalDrive E:\LocalDrive /MIR /R:1 /W:0 /XD node_modules

robocopy C:\Users\janik\OneDrive E:\OneDrive /MIR /R:1 /W:0

robocopy K:\ E:\KBFS /MIR /R:1 /W:0

View Garmin Connect
janikvonrotz / Manually renew letsencrypt
Created Apr 16, 2020
Manually renew letsencrypt certificate
View Manually renew letsencrypt

Clone the letsencrypt cli.

git clone
cd letsencrypt

Request a new certificate for your domain manually.


Title: Factfulness: Ten Reasons We're Wrong About the World – and Why Things Are Better Than You Think
Author: Hans Rosling, Ola Rosling, Anna Rosling Rönnlund
Comment: This book changed my perception of the world subtly
Rating: 10/10
ISBN: 1473637465
Finished: 30.01.2020

Title: When The Moon Shines By Day

You can’t perform that action at this time.