Skip to content

Instantly share code, notes, and snippets.

View abroadbent's full-sized avatar

Adam Broadbent abroadbent

  • MadeLabs LLC
  • Okemos, MI
  • 08:34 (UTC -04:00)
View GitHub Profile

Keybase proof

I hereby claim:

  • I am abroadbent on github.
  • I am abroadbent (https://keybase.io/abroadbent) on keybase.
  • I have a public key whose fingerprint is ECA6 26D9 795A BE6B DBC7 4F4D F23F 4B37 DF22 3137

To claim this, I am signing this object:

@abroadbent
abroadbent / gist:b000f160839f944bac82ae10254e773f
Created May 12, 2019 13:04
Boxstarter Dev Machine Setup
# Boxstarter options
$Boxstarter.RebootOk=$true # Allow reboots?
$Boxstarter.NoPassword=$false # Is this a machine with no login password?
$Boxstarter.AutoLogin=$true # Save my password securely and auto-login after a reboot
#### WINDOWS SETTTINGS #####
Disable-UAC
#--- Configuring Windows properties ---
@abroadbent
abroadbent / gist:483c3105002a1012390046e9c53d3cea
Created February 10, 2018 18:09
Endpoint for connecting to shared input and output hubs
Endpoint=sb://cloudcityab20180210.servicebus.windows.net/;SharedAccessKeyName=RootManageSharedAccessKey;SharedAccessKey=S8VGFRDCnJaY/+7WoACp6+lziIZRcdN/HSou4auMA/4=
@abroadbent
abroadbent / States.SQL
Last active December 4, 2021 23:31
SQL Server T-SQL for a US States and Canadian Province Table
CREATE TABLE States (
Id int IDENTITY(1,1) NOT NULL,
Name varchar(40) NOT NULL,
Abbreviation varchar(2) NOT NULL,
CountryId int NOT NULL,
CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [uc_States_Abbreviation] UNIQUE NONCLUSTERED ([Abbreviation] ASC)
);
SET IDENTITY_INSERT States ON
@abroadbent
abroadbent / Countries.SQL
Created August 14, 2013 17:39
SQL Server T-SQL For Countries Table
CREATE TABLE Countries (
Id int IDENTITY(1,1) NOT NULL,
Iso varchar(2) NOT NULL,
Name varchar(80) NOT NULL,
Iso3 varchar(3) NULL,
NumCode int NULL,
PhoneCode int NOT NULL,
CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [uc_Countries_Iso] UNIQUE NONCLUSTERED ([Iso] ASC)
)