Skip to content

Instantly share code, notes, and snippets.


Janik Vonrotz janikvonrotz

View GitHub Profile
janikvonrotz / SQL Cheat
Last active Oct 25, 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 / Install Lets Encrypt and create a free SSL
Last active Oct 21, 2020
Install Let's Encrypt and create a free SSL certificate #OpenSSL #Markdown
View Install Lets Encrypt and create a free SSL


Let’s Encrypt is a free, automated, and open certificate authority (CA), run for the public’s benefit. Let’s Encrypt is a service provided by the Internet Security Research Group (ISRG). This guide shows you how you can obtain a free SSL certificate.


janikvonrotz / Install
Last active Oct 18, 2020
Ubuntu: Install WPScan #Ubuntu #WordPress #Markdown
View Install


WPScan is a black box WordPress vulnerability scanner.


  • Ubntu server
  • libcurl4-gnutls-dev, libopenssl-ruby, libxml2, libxml2-dev, libxslt1-dev, ruby-dev
  • Git
  • Ruby and RubyGems with RVM
janikvonrotz / Assign-TemporaryAdministratorRights.ps1
Last active Oct 18, 2020
PowerShell: Assign Temporary Administrator Rights #PowerShell #ActiveDirectory #EmbededPost
View Assign-TemporaryAdministratorRights.ps1
$Metadata = @{
Title = "Assign Temporary Administrator Rights"
Filename = "Assign-TemporaryAdministratorRights.ps1"
Description = ""
Tags = "powershell, script, activedirectory, assign, temporary, administrator, rights, computer"
Project = ""
Author = "Janik von Rotz"
AuthorContact = ""
CreateDate = "2013-11-15"
janikvonrotz / Install Ubuntu development
Created Mar 25, 2014
Ubuntu: Install Ubuntu development libraries #Ubuntu #Markdown
View Install Ubuntu development


This is a list of essential tools for developing with Ubuntu.


  • Ubuntu server


janikvonrotz / Update Ubuntu
Created Mar 6, 2014
Ubuntu: Update Ubuntu server #Ubuntu #Markdown
View Update Ubuntu


  • Ubuntu server


Update the list of available packages.

sudo aptitude update
View Backup to external

Backupt to external drive

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

robocopy C:\Users\janik\Nextcloud D:\Nextcloud /MIR /R:1 /W:0

robocopy C:\Users\janik\Nextcloud2 D:\Nextcloud2 /MIR /R:1 /W:0

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

janikvonrotz / Install WordPress
Created Mar 3, 2014
Step by Step: Install WordPress Blog #PHP #MySQL #Nginx #phpMyAdmin #WordPress #Markdown #Ubuntu
View Install WordPress

Finishing this guide you'll get:

  • A running WordPress installation
  • Nginx proxy with PHP and Fast CGI
  • MySQL server accessible with phpMyAdmin

Specification of latest running installation:

  • Date: 03.03.2014
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 / Update-SPTokenLifetime.ps1
Created Apr 3, 2014
PowerShell: Update SharePoint Token Lifetime #SharePoint #PowerShell
View Update-SPTokenLifetime.ps1
if(-not (Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue)){Add-PSSnapin "Microsoft.SharePoint.PowerShell"}
# update SharePoint cache token lifetime
$SPContentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$SPContentService.TokenTimeout = (New-TimeSpan -minutes 5)
# udpate SharePoint claims token lifetime
You can’t perform that action at this time.