Skip to content

Instantly share code, notes, and snippets.

View FrankDeGroot's full-sized avatar

Frank de Groot - Schouten FrankDeGroot

View GitHub Profile
USE [msdb]
BEGIN TRANSACTION;
DECLARE @ReturnCode INT;
SELECT @ReturnCode = 0;
DECLARE @JobCategory NVARCHAR(MAX);
SET @JobCategory = N'[Managementoverzichten]';
$environment = 'dev' # 'dev', 'test' or 'production'
$packagesDir = 'C:\Users\Administrator\Downloads\_PublishedWebsites'
$siteDir = 'C:\inetpub\wwwroot'
$domain = switch ($environment) { 'dev' { (Get-ChildItem ENV:computername).Value } default { 'OFFICE' } }
$sqlServerInstance = '.'
$reportServerUrl = 'http://rsbio01/ReportServer_ONTWIKKEL.123'
$certPath = 'Cert:\LocalMachine\WebHosting'
$certs = @()
$dummyCerts = @(
param (
[switch]$Create,
[switch]$Drop
)
if ($Create) { Create }
if ($Drop) { Drop }
Write-Host "Laden modulen voor IIS en SQL Server..."
@FrankDeGroot
FrankDeGroot / rdp1600x900.sh
Last active August 29, 2015 14:05
Set RDP to 1600x900
modeline="`cvt 1600 900 | sed -n '2p'`"
xrandr --newmode ${modeline:9}
xrandr --addmode VNC-0 ${modeline:9:16}
xrandr -s ${modeline:10:8}
PS1='\w '
PROMPT_COMMAND='echo -ne "\033]0;${PWD/$HOME/~}\007"'
@FrankDeGroot
FrankDeGroot / fedorakderemove.sh
Last active August 29, 2015 14:03
Fedore KDE remove stuff I don't use.
sudo yum remove apper gwenview kamoso kmahjongg kmail kmines kpat marble okular
@FrankDeGroot
FrankDeGroot / mongodb.cmd
Created April 3, 2014 15:59
Install MongoDB as a Windows Service
rem Notice logpath is a FILE and dbpath is a DIRECTORY.
C:\Tools\mongodb\bin\mongod --logpath=C:\Tools\mongodb\log\mongod.log --dbpath=C:\Tools\mongodb\data --install
## Disable sudo password.
sudo visudo
# Comment: %wheel ALL=(ALL) ALL
# Uncomment: %wheel ALL=(ALL) NOPASSWD: ALL
## Remove stuff of Fedora I'm not using.
sudo yum -y remove bijiben cheese devassistant empathy evolution gnome-boxes gnome-calculator gnome-clocks gnome-contacts gnome-documents gnome-photos gnome-software gnome-user-docs gnome-weather rhythmbox shotwell totem transmission vinagre
sudo yum group remove libreoffice
## Install if I'm feeling vaine.
@FrankDeGroot
FrankDeGroot / fonts.sh
Last active December 28, 2015 11:59
Enable font subpixel rendering using RPM fusions freetype-freeworld font renderer.
#add RPM fusion repo
sudo yum localinstall --nogpgcheck http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-$(rpm -E %fedora).noarch.rpm http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-$(rpm -E %fedora).noarch.rpm
#add subpixel font renderer
sudo yum install freetype-freeworld
#gsettings "set" "org.gnome.settings-daemon.plugins.xsettings" "hinting" "slight"
gsettings "set" "org.gnome.settings-daemon.plugins.xsettings" "antialiasing" "rgba"
echo "Xft.lcdfilter: lcddefault" > ~/.Xresources
@FrankDeGroot
FrankDeGroot / renamesln.ps1
Created November 7, 2013 11:14
Rename solution file
dir * -r | rename-item -newname { $_.name -replace "replaceme","" }
dir * -r | attrib -r $_.fullname
dir * -r | ? { !$_.psiscontainer } | % { (get-content $_.fullname | % { $_ -replace "replaceme","withme" } ) | set-content $_.fullname }