sandorjanssen’s gists

sandorjanssen / gist:a723a78e5ae8af5c9a1fd466a237dfe1

Created May 31, 2018 07:04

Powershell proxy

	[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials

	Or:

	$wc = New-Object System.Net.WebClient
	$wc.Proxy.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials
	$wc.Proxy.Address = "http://proxyurl"

sandorjanssen / kill-orphaned-connections.sql

Created April 5, 2018 14:05

Kill orphaned connections

	DECLARE @SQL AS VARCHAR(255)
	DECLARE @SPID AS SMALLINT
	DECLARE @Loginname AS VARCHAR(500)
	DECLARE @HoursSinceLastBatch AS SMALLINT = 4
	SET @Loginname = '<<Loginname>>'

	DECLARE Murderer CURSOR FOR
	SELECT spid FROM sys.sysprocesses WHERE loginame = @Loginname AND last_batch < DATEADD(HOUR, -1 * @HoursSinceLastBatch, GETDATE()) AND [status] = 'sleeping' ORDER BY last_batch DESC

	OPEN Murderer

sandorjanssen / magic.ps1

Created July 13, 2017 13:36

Get filenames from files in serveral subfolders that have a specific range for the LastWriteTime property

	# Get filenames from files in serveral subfolders that have a specific range for the LastWriteTime property
	$path = "FileSystem::\\path\to\files\**\in\several\subfolders"

	$start = Get-Date -Date "2017-06-27"
	$end = $start.AddDays(1)

	Get-ChildItem -Path $path -Recurse \| `
	Where-Object { $_.LastWriteTime -ge $start -and $_.LastWriteTime -le $end } \| `
	Select-Object { $_.Name }

sandorjanssen / windows-startup-folders

Created June 30, 2015 09:56

Open startup folder in windows (user or common)

	#Open startup folder in windows (user or common)

	##User
	- Run (WinKey+R)
	- shell:Startup

	##Common
	- Run (WinKey + R)
	- shell:Common Startup

sandorjanssen / Delete obj and bin folders recusive

Last active April 7, 2017 12:16

Delete obj and bin folders recusive

Get-ChildItem .\ -Include bin,obj -Recurse -Force | Remove-Item -Force -Recurse

sandorjanssen / powershell-profile

Created July 15, 2014 08:42

Powershell profile (edit using vim $profile) incl. .NET, Visual Studio, Azure, etc. tools

	$env:path = $env:path + ";C:\Windows\Microsoft.NET\Framework64\v4.0.30319"
	$env:path = $env:path + ";C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE"
	$env:path = $env:path + ";C:\Program Files (x86)\Vim\vim73"
	. (Resolve-Path "$env:LOCALAPPDATA\GitHub\shell.ps1")
	& 'C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\vcvarsall.bat' x86

	# Change the prompt to show only the current folder using a different color
	function prompt {
	$p = Split-Path -leaf -path (Get-Location)
	Write-Host "$p> " -nonewline -foregroundcolor Green

sandorjanssen / Node.js webserver for serving static files

Last active December 25, 2015 16:19

Node.js webserver for serving static files (run npm install connect first)

sandorjanssen / html5-template-semantic-tags

Created August 14, 2013 14:00

Basic HTML5 template using semantic tags

sandorjanssen / colored-current-folder-prompt

Last active December 21, 2015 01:39

Change the prompt to show only the current folder using a different color (add to $profile using vim $profile)

	function prompt {
	$p = Split-Path -leaf -path (Get-Location)
	Write-Host "$p> " -nonewline -foregroundcolor Green
	return ' '
	}

Sandor Janssen sandorjanssen