Skip to content

Instantly share code, notes, and snippets.


Janik Vonrotz janikvonrotz

View GitHub Profile
janikvonrotz / SQL Cheat
Last active June 7, 2023 10:29
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 / Generate CSR (Certificate Signing Request) with
Created July 25, 2015 06:59
Generate CSR (Certificate Signing Request) with OpenSSL #OpenSSL #Markdown
View Generate CSR (Certificate Signing Request) with

Define the following attributes, you have to set them in the wizard when generating the CSR.

  • Common Name (the domain name certificate should be issued for)
  • Country
  • State (or province)
  • Locality (or city)
  • Organization
  • Organizational Unit (Department)
  • E-mail address
graph LR;
    A[Alice]-->|Hi Bob|B[Bob];
janikvonrotz / Install Lets Encrypt and create a free SSL
Last active April 6, 2023 14:06
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 / Default system
Last active April 3, 2023 07:11
Windows: Default system variables #Windows
View Default system
janikvonrotz / Install phpMyAdmin
Last active March 28, 2023 02:56
Ubuntu: Install phpMyAdmin website #phpMyAdmin #Markdown
View Install phpMyAdmin


  • Ubuntu server
  • Nginx
  • Nginx minimal website
  • php5-fpm
  • php5-mysql, php5-mcrypt
  • Nginx php5-fpm website
  • MySQL
janikvonrotz / Garmin Connect
Created April 16, 2020 18:04
Garmin Connect Weight
View Garmin Connect
janikvonrotz / Delete-AllCmdKeyCredentials.ps1
Created December 6, 2013 07:39
PowerShell: Delete all cmdkey credentials #PowerShell #Windows
View Delete-AllCmdKeyCredentials.ps1
cmdkey /list | ForEach-Object{if($_ -like "*Ziel:*"){cmdkey /del:($_ -replace " ","" -replace "Ziel:","")}}
janikvonrotz / Install Koken
Last active February 18, 2023 19:57
Ubuntu: Install Koken website #Koken #Markdown
View Install Koken
janikvonrotz / Assign-TemporaryAdministratorRights.ps1
Last active February 7, 2023 21:31
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"