Skip to content

Instantly share code, notes, and snippets.

Avatar

Janik Vonrotz janikvonrotz

View GitHub Profile
@janikvonrotz
janikvonrotz / SQL Cheat Sheet.md
Last active Oct 25, 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 Lets Encrypt and create a free SSL certificate.md
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 certificate.md

Introduction

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.

Requirements

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

Introduction

WPScan is a black box WordPress vulnerability scanner.

Requirements

  • Ubntu server
  • libcurl4-gnutls-dev, libopenssl-ruby, libxml2, libxml2-dev, libxslt1-dev, ruby-dev
  • Git
  • Ruby and RubyGems with RVM
@janikvonrotz
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 = "http://janikvonrotz.ch"
CreateDate = "2013-11-15"
@janikvonrotz
janikvonrotz / Install Ubuntu development libraries.md
Created Mar 25, 2014
Ubuntu: Install Ubuntu development libraries #Ubuntu #Markdown
View Install Ubuntu development libraries.md

Introduction

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

Requirements

  • Ubuntu server

Installation

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

Requirements

  • Ubuntu server

Instructions

Update the list of available packages.

sudo aptitude update
View Backup to external drive.md

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\janikv.cloud D:\janikv.cloud /MIR /R:1 /W:0

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

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
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 / 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)
$SPContentService.Update()
# udpate SharePoint claims token lifetime
You can’t perform that action at this time.