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
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
janikvonrotz / SQL Cheat Sheet.md
Last active May 23, 2020
SQL Cheat Sheet#SQL#Markdown
View SQL Cheat Sheet.md

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.

Datatypes

Text types

@janikvonrotz
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
janikvonrotz / Unattended Encrypted Incremental Backup to Amazon S3.md
Last active May 8, 2020
Ubuntu: Unattended Encrypted Incremental Backup to Amazon S3#AmazonAWS#Markdown
View Unattended Encrypted Incremental Backup to Amazon S3.md

Introduction

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.

Requirements

  • Ubuntu server
  • duplicity, Git, GnuPG
  • MySQL
@janikvonrotz
janikvonrotz / Check System Resources.sh
Last active Apr 20, 2020
Ubuntu: Check System Resources #Ubuntu
View Check System Resources.sh
# disk space
df -h
# ram in mega bytes
free -m
# detailed ram usage
View Pull all git projects.ps1
$gitUser = @(
"$Home\LocalDrive\GitHub",
"$Home\LocalDrive\GitLab",
"$Home\LocalDrive\GitHub_HaloCustomEdition",
"$Home\LocalDrive\GitHub_Hochschule-Luzern",
"$Home\LocalDrive\GitLab_Apoveda",
"$Home\LocalDrive\GitLab_Valora",
"$Home\LocalDrive\GitHub_Abilium",
"$Home\LocalDrive\GitHub_todo-md",
"$Home\LocalDrive\GitHub_Mint-System",
View Backup to external drive.md

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 Weight.md
@janikvonrotz
janikvonrotz / Manually renew letsencrypt certificate.md
Created Apr 16, 2020
Manually renew letsencrypt certificate
View Manually renew letsencrypt certificate.md

Clone the letsencrypt cli.

git clone https://github.com/letsencrypt/letsencrypt
cd letsencrypt

Request a new certificate for your domain manually.

View bookshelf.md


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.