Skip to content

Instantly share code, notes, and snippets.

View drmohundro's full-sized avatar
:shipit:

David Mohundro drmohundro

:shipit:
84 followers · 44 following
View GitHub Profile
@drmohundro
drmohundro / Playground.swift
Created February 20, 2015 17:02
SWXMLHash Lazy-Loading Approach
class IndexOp {
let index: Int
let key: String
init(_ index: Int) {
self.index = index
self.key = ""
}
init(_ key: String) {
@drmohundro
drmohundro / Open-MruSolution.ps1
Last active May 17, 2016 14:15
PowerShell script to open a recently used solution in Visual Studio
function Open-MruSolution($sln) {
$mruItems = "HKCU:\Software\Microsoft\VisualStudio\14.0\MRUItems"
$guids = Get-ChildItem $mruitems |
Select-Object -ExpandProperty name |
Foreach-Object { $_.Substring($_.LastIndexOf('\') + 1) }
[array]$mostRecentlyUsedSlns = $guids |
Foreach-Object {
$guid = $_
Get-ChildItem "$mruItems\$guid" |
@drmohundro
drmohundro / IisExpressJob.ps1
Last active December 25, 2018 06:47
PowerShell functions to start/stop IIS Express in the specified directory as a background job
$jobName = 'IisExpressJob'
function Start-IisExpress($pathToSource) {
Start-Job -Name $jobName -Arg $pathToSource -ScriptBlock {
param ($pathToSource)
& 'C:\Program Files (x86)\IIS Express\iisexpress.exe' /port:1234 /path:$pathToSource
}
}
function Stop-IisExpress {
@drmohundro
drmohundro / PingRdpPort.ps1
Created August 20, 2015 16:42
Determine if a specified server is listening on the default RDP port
# relies on portqry (see http://www.microsoft.com/en-us/download/details.aspx?id=24009)
param (
[Parameter(Mandatory=$true)]
[string]
$server,
[int]
$rdpPort = 3389
)
@drmohundro
drmohundro / scm-ignore.js
Created January 24, 2016 18:52
Bookmarklet to hide rows on various source hosting sites
var url = window.location.href;
var searchTextToIgnore = prompt('Enter text to ignore:');
if (url.match(/bitbucket/)) {
$('h1:contains(' + searchTextToIgnore + ')').closest('section').hide();
} else if (url.match(/gitlab/)) {
$('.diff-header span:contains(' + searchTextToIgnore + ')').parent().parent().hide();
} else {
alert(url + " doesn't match any known sites.");
}
@drmohundro
drmohundro / ConstraintsInPlayground.swift
Created March 5, 2016 21:28
Playing with Layout Constraints and VFL in Swift Playground
// playing with Xcode, Constraints and Playground
import UIKit
import XCPlayground
let hostView = UIView()
hostView.frame = CGRectMake(0, 0, 400, 200)
hostView.backgroundColor = UIColor.lightGrayColor()
XCPlaygroundPage.currentPage.liveView = hostView
@drmohundro
drmohundro / fix-casing-issues.rb
Created March 11, 2016 21:46
Fix git casing issues across all directories
# can just run this in pry
files = `git ls-files | grep Wrongcase`
files.split("\n").each { |file| system("git mv #{file} #{file.gsub('Wrongcase', 'WrongCase')}") }
@drmohundro
drmohundro / backup-example.sql
Last active January 4, 2017 01:58
Backup and Restore Database Examples (T-SQL)
BACKUP DATABASE MyDb TO DISK = 'C:\sql-backups\MyDb-20151119.bak' WITH INIT
GO
@drmohundro
drmohundro / has-more-than-one-example.sql
Created January 4, 2017 01:59
T-SQL Has More Than CTE Example
; WITH ForImport AS (
SELECT
DISTINCT
ve.BvcmsId
,vd.account AS CreditCardOrAch
,vd.account_expiration AS Expires
,vd.routing AS Routing
,vd.address1 AS Address1
,vd.address2 AS Address2
,vd.city AS City
@drmohundro
drmohundro / for-each-db-example.sql
Created January 4, 2017 02:03
T-SQL sp_msforeachdb example
EXEC sp_msforeachdb '
if ''?'' LIKE ''CMS[_]%'' begin
print ''?'';
use [?]
select setting as TransactionGateway, ''?'' as [Database]
from dbo.Setting with(nolock)
where Id = ''TransactionGateway''