David Mohundro drmohundro
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| class IndexOp { | |
| let index: Int | |
| let key: String | |
| init(_ index: Int) { | |
| self.index = index | |
| self.key = "" | |
| } | |
| init(_ key: String) { |
drmohundro
/ Open-MruSolution.ps1
Last active
May 17, 2016 14:15
PowerShell script to open a recently used solution in Visual Studio
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ IisExpressJob.ps1
Last active
December 25, 2018 06:47
PowerShell functions to start/stop IIS Express in the specified directory as a background job
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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
/ PingRdpPort.ps1
Created
August 20, 2015 16:42
Determine if a specified server is listening on the default RDP port
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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
/ scm-ignore.js
Created
January 24, 2016 18:52
Bookmarklet to hide rows on various source hosting sites
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ ConstraintsInPlayground.swift
Created
March 5, 2016 21:28
Playing with Layout Constraints and VFL in Swift Playground
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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
/ fix-casing-issues.rb
Created
March 11, 2016 21:46
Fix git casing issues across all directories
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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
/ backup-example.sql
Last active
January 4, 2017 01:58
Backup and Restore Database Examples (T-SQL)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| BACKUP DATABASE MyDb TO DISK = 'C:\sql-backups\MyDb-20151119.bak' WITH INIT | |
| GO |
drmohundro
/ has-more-than-one-example.sql
Created
January 4, 2017 01:59
T-SQL Has More Than CTE Example
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ; 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| EXEC sp_msforeachdb ' | |
| if ''?'' LIKE ''CMS[_]%'' begin | |
| print ''?''; | |
| use [?] | |
| select setting as TransactionGateway, ''?'' as [Database] | |
| from dbo.Setting with(nolock) | |
| where Id = ''TransactionGateway'' |