Skip to content

Instantly share code, notes, and snippets.

Silthus Silthus

Block or report user

Report or block Silthus

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
View drop-all-schemas.sql
/* USE [YOUR_DATABASE] */
DECLARE @schema VARCHAR(128)
SELECT @schema = (SELECT TOP 1 [name] FROM sys.schemas ORDER BY [name])
WHILE @schema is not null
BEGIN
/* Drop all non-system stored procs */
View Export-VMTemplate.ps1
param (
[parameter(Mandatory=$true)]
$VM,
[parameter(Mandatory=$true)]
[string]
$TemplateName,
[parameter(Mandatory=$false)]
$VMMServer,
@Silthus
Silthus / README.md
Created Sep 12, 2018
Quest Example Readme
View README.md

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 Jan 7, 2019
Drops all stored procs, views, constraints and tables
View drop-all.sql
/* 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 Mar 12, 2018
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
View Get-FailedFiles.ps1
#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.
View auth_source_wcf.rb
# 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,
You can’t perform that action at this time.