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 / SQL Cheat
Last active Jan 30, 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
Last active Jan 16, 2020
Ubuntu: Install automysqlbackup #MySQL #Markdown
View Install


AutoMySQLBackup with a basic configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers.


  • Ubuntu server
  • MySQL



Title: Tao-te-King
Author: Lao Tse
Comment: The bible of daoism. Love the quotes and most of them are as relevant as it gets for today.
Rating: 8/10
ISBN: 9783257791259
Finished: 17.12.2018

Title: Supernova Era

janikvonrotz / Get-AllCostCentersAndDepartmentName.ps1
Created Dec 17, 2013
PowerShell: Get All Cost Centers and Department Names #PowerShell #ActiveDirectory
View Get-AllCostCentersAndDepartmentName.ps1
# extensionattribute2 ist cost center number
Get-ADUser -Filter * -Properties extensionattribute2, department | where{$_.extensionattribute2 -and $_.department} | select extensionattribute2, department -Unique | sort extensionattribute2 | out-gridview
janikvonrotz / Install Nginx SSL
Last active Dec 5, 2019
Ubuntu: Install Nginx SSL website #Nginx #Markdown
View Install Nginx SSL


This best practice shows you the most advanced SSL configurations for your Nginx website. For productive usage it's recommended to use only public-signed certificates.


  • Ubuntu server
  • Nginx
  • Nginx minimal website
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 / Apache Rewrite Rules.txt
Created Jun 10, 2013
Apache: Rewrite Rules #Apache
View Apache Rewrite Rules.txt
#Rewerite canonical URL
RewriteEngine On
RewriteCond %{HTTP_HOST} ^$
RewriteRule (.*)$1 [R=301]
#.htaccess rewrite examples should begin with: ^
Options +FollowSymLinks
RewriteEngine On
janikvonrotz / TypoScript.xml
Created Oct 5, 2013
TypoScript Syntax Highlight #Typo3 #NotepadPlusPlus #XML
View TypoScript.xml
<?xml version="1.0" encoding="UTF-8" ?>
<KeyWord name="absRefPrefix" />
<KeyWord name="accessibility" />
<KeyWord name="accessKey" />
<KeyWord name="ACT" />
<KeyWord name="ACTIFSUB" />
<KeyWord name="ACTIFSUBRO" />
<KeyWord name="ACTRO" />
janikvonrotz / Create-AlphabeticalSortedListOfAllFunctions.ps1
Created Apr 17, 2014
PowerShell: Create alphabetical sorted list of all functions #PowerShell #PowerUp
View Create-AlphabeticalSortedListOfAllFunctions.ps1
$B = ""
$A = "H:/SkyDrive/Shared/Projects/GitHub/Powershell-PowerUp/functions/"
$Terms = Get-ChildItem $PSfunctions.Path -Recurse -Filter *.ps1 |
select Name, BaseName, @{L="Verb";E={$_.Name.Split("-")[0]}},@{L="Noun";E={$_.BaseName.Split("-")[1]}}, FullName, @{L="Url";E={$_.FullName -replace "\\","/" -replace $A,$B}} |
Sort-Object Noun, Verb
janikvonrotz / Convert-KeePassToPass.ps1
Last active Oct 20, 2019
Convert KeePass to Pass #KeePass #PowerShell
View Convert-KeePassToPass.ps1
[xml]$Content = Get-Content -Path "KeepassData.xml"
Access the xml data:
function Traverse-Tree ($Node, $ParentPath) {
You can’t perform that action at this time.