Skip to content

Instantly share code, notes, and snippets.

View Silthus's full-sized avatar

Michael Reichenbach Silthus

View GitHub Profile
@Silthus
Silthus / README.md
Created September 12, 2018 17:04
Quest Example Readme

Beispiel Quest

Hier sollte in ein bis zwei kurzen Sätzen der Kern der Quest erzählt werden, so dass man schnell weiß um was es in der Quest geht.

Die README Dateien für Quests können auch von den Quest Schreibern entworfen werden um den Quest Entwicklern die Arbeit zu erleichtern.

Ablauf

Ein kurzer Überblick über den schematischen Ablauf der Quest wie sie vom Quest Schreiber geplant wurde.

@Silthus
Silthus / drop-all.sql
Last active January 7, 2019 10:12
Drops all stored procs, views, constraints and tables
/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])
WHILE @name is not null
BEGIN
SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)
@Silthus
Silthus / Get-FailedFiles.ps1
Created March 12, 2018 08:57
Powershell script that parses RoboCopy log and extracts failed files to .csv. Copied from: https://gallery.technet.microsoft.com/scriptcenter/Powershell-script-to-parse-a1bc8a92
#Requires -Version 4
function Log {
<#
.Synopsis
Function to log input string to file and display it to screen
.Description
Function to log input string to file and display it to screen. Log entries in the log file are time stamped. Function allows for displaying text to screen in different colors.
# Redmine Woltlab Community Framework 2 Authentication Source
#
# Copyright (C) 2014 Michael 'Silthus' Doering
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,