mrled

Keybase proof

I hereby claim:

• I am mrled on github.
• I am mrled (https://keybase.io/mrled) on keybase.
• I have a public key whose fingerprint is 1E06 1357 A257 E10E C0AF 747E 56D3 8EFB 7465 6AA0

To claim this, I am signing this object:

mrled

{
  "variables": {
    "testinputartifact": "C:\\Windows\\system32\\cmd.exe"
  },
  "builders": [
    {
      "type": "file",
      "source": "{{user `testinputartifact`}}",
      "target": "testing.box"
    }

mrled

-- NOTE: Backs up to the default backup directory

DECLARE @prefix VARCHAR(20)     -- a prefix for the filename, set below
DECLARE @name VARCHAR(50)       -- database name, set automatically
DECLARE @fileName VARCHAR(256)  -- filename for backup, set automatically
DECLARE @fileDate VARCHAR(20)   -- used for file name, set automatically

SET @prefix = 'Autobackup'
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) 
 

mrled

{
  "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "storageAccountName": {
      "type": "string",
      "metadata": {
        "description": "Storage Account Name; must be a valid Azure DNS hostname"
      }
    },

mrled

<#
.synopsis
Show Octopus parameters defined in files
.parameter rootPath
Search recursively from here.
If the tree is large, this command will take a long time. If you're working in a Git repository of a project directory, it might be worth running 'git clean -fxd' beforehand. This will delete all your bin/ and obj/ directories (meaning any binaries you have built will be deleted), but will make this command run faster.
.parameter filePattern
Look for files whose name matches this pattern. By default, only look for *.Octopus.config files.
#>
function Show-OctopusVariables {

mrled

Converting timezones from Windows to IANA and back in Python

Spoiler alert: I couldn't end up doing this, jesus christ timezones are such a mess

General notes

There are many mappings between timezones.

1. Obviously I could maintain one myself, but it's sufficiently complex that I don't want to take this on
2. Unicode maintains a mapping of Windows to IANA zones, but it only has entryes for standard timezone names ("Pacific Standard Time") and not DST timezone names ("Pacific Daylight Time"): https://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml

mrled

Linux ip tricks

# call like 'getips <INTERFACE> <FAMILY>'
# e.g. 'getips eth0 inet' might return 192.168.1.1/24
# e.g. 'getips eth0 inet6' might return fe80::4008:c2ff:fee8:fc93/64
# Note that this will retur all IPs of the family assigned to the interface - possibly more than one
getips() {
    if test $# != 2; then
        return 1

fi

mrled

#!/bin/sh

usage() {
    cat <<ENDUSAGE
$0: Apply required virtual firmware changes so that El Capitan will run under VirtualBox
Usage: $0 <VM_NAME>
ENDUSAGE
}

if test $# -ne 1 || test "$1" == "-h" || test "$1" == "--help"; then

mrled

mrled

Git configuration

FSCK objects

You probably want to enable object fscking, which will protect against some hypothetical attacks on SHA1

git config --global transfer.fsckobjects true
git config --global fetch.fsckobjects true