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 / Generate CSR (Certificate Signing Request) with
Created Jul 25, 2015
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
janikvonrotz / Install Lets Encrypt and create a free SSL
Last active Dec 7, 2015
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 / SQL Cheat
Last active Jan 21, 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 / Enable-PowerShellISEWindowsServer.ps1
Last active Aug 29, 2015
Enable PowerShell ISE for Windows Server #PowerShell #WindowsServer
View Enable-PowerShellISEWindowsServer.ps1
Import-Module ServerManager
Add-WindowsFeature PowerShell-ISE
janikvonrotz / map.geojson
Last active Jan 4, 2018
Places I've been to #JanikVonrotz
View map.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
janikvonrotz / Add-RemoteDesktopUser.ps1
Created Jun 1, 2015
Add Remote Desktop User #PowerShell #Windows
View Add-RemoteDesktopUser.ps1
$computername = "hostname"
Invoke-Command -ComputerName $computername -ScriptBlock {
$computer = $env:COMPUTERNAME
$domain = "domain"
$user = "username"
$group = [ADSI]"WinNT://$computer/Remote Desktop Users,group"
janikvonrotz / Enable Piwik for
Created Apr 9, 2015
Ubuntu: Enable Piwik for LimeSurvey #LimeSurvey
View Enable Piwik for
janikvonrotz / Install LimeSurvey
Last active Nov 13, 2015
Ubuntu: Install LimeSurvey webapp #LimeSurvey
View Install LimeSurvey
janikvonrotz / Add-WPAdminUser.sql
Created Mar 23, 2015
Wordpress add administrator user with sql only #WordPress #MySQL
View Add-WPAdminUser.sql
USE <database>;
SET @username = '<username>';
SET @password = MD5('<password>');
SET @fullname = '<Firstname Lastname>';
SET @email = '<>';
SET @url = '<>';
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_status`, `display_name`) VALUES (@username, @password, @fullname, @email, @url, NOW(), '0', @fullname);
janikvonrotz / footer.blade.php
Last active Jul 4, 2017
Laravel default templates #Laravel
View footer.blade.php
You can’t perform that action at this time.