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

Introduction

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.

Requirements

  • Ubuntu server
  • MySQL

Installation

View bookshelf.md


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
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
janikvonrotz / Install Nginx SSL website.md
Last active Dec 5, 2019
Ubuntu: Install Nginx SSL website #Nginx #Markdown
View Install Nginx SSL website.md

Introduction

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.

Requirements

  • Ubuntu server
  • Nginx
  • Nginx minimal website
@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 / 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} ^snippetdb.com$
RewriteRule (.*) http://www.snippetdb.com$1 [R=301]
#.htaccess rewrite examples should begin with: ^
Options +FollowSymLinks
RewriteEngine On
@janikvonrotz
janikvonrotz / TypoScript.xml
Created Oct 5, 2013
TypoScript Syntax Highlight #Typo3 #NotepadPlusPlus #XML
View TypoScript.xml
<NotepadPlus>
<?xml version="1.0" encoding="UTF-8" ?>
<AutoComplete>
<KeyWord name="absRefPrefix" />
<KeyWord name="accessibility" />
<KeyWord name="accessKey" />
<KeyWord name="ACT" />
<KeyWord name="ACTIFSUB" />
<KeyWord name="ACTIFSUBRO" />
<KeyWord name="ACTRO" />
@janikvonrotz
janikvonrotz / Create-AlphabeticalSortedListOfAllFunctions.ps1
Created Apr 17, 2014
PowerShell: Create alphabetical sorted list of all functions #PowerShell #PowerUp
View Create-AlphabeticalSortedListOfAllFunctions.ps1
cls
$B = "https://github.com/janikvonrotz/PowerShell-PowerUp/blob/master/functions/"
$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
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:
Content.KeePassFile.Root.Group.Group.Entry[67].String[0].Value
#>
function Traverse-Tree ($Node, $ParentPath) {
You can’t perform that action at this time.