GuyHarwood

MSSQL Patterns

Sourced from https://github.com/jon-shipley/patterns/blob/master/mssql-idempotent-sql.md

Table of contents

1. Columns
2. Constraints
3. Indexes
4. Tables
5. Views

GuyHarwood

#!/bin/bash
set -e

if [ -z "$1" ]
  then
    echo "storage account name required"
    exit 1
fi

if [ -z "$2" ]

GuyHarwood

// decorator example

export interface IWork {
  doWork (work: any): void
}

export class ImportantService implements IWork { 
  doWork (work: any): void {
    // important work done here
  }

GuyHarwood

MSSQL CLI

github...

UI

https://dbeaver.io/

sqlcmd -S <ip> -d <dbname> -U <username> -P <password> -I

GuyHarwood

const checkMachine = Machine({
  id: 'check',
  initial: 'untaken',
  context: {
    restarts: 0
  },
  states: {
    untaken: {
      on: {
        ALLOCATE: 'allocated'

GuyHarwood

export class StorageService {
  setItem (key: StorageKey, item: any): void {
    localStorage.setItem(key.toString(), item)
  }
}

export class StorageKey {

  private key: string

GuyHarwood

#!/usr/bin/env bash
set -x
CWD=$(pwd)

# deploy app1
ADMIN_APP="${CWD}/app1"
TEMP_DIR=$(mktemp -d)
cd ${TEMP_DIR}
cp -a "${ADMIN_APP}" .
cd admin

GuyHarwood

'use strict'

const https = require('https')
// set the id of your github PR label below...
const ciEnabledLabelId = 0 
const orgAndRepo = 'yourOrg/yourRepo'
// Example call: 'https://api.github.com/repos/myorg/myrepo/pulls/557?client_id=xxxx&client_secret=yyyy'
const pullRequestId = process.argv[2]

if (!pullRequestId) {

GuyHarwood

#!/bin/bash

# exit on error
set -e

# input parameters
# $1 resource group to target
# $2 cosmosDB instance name

# Set variables for the new account, database, and collection

GuyHarwood

install iterm configure iterm to pick up settings file from iCloud install homebrew install zsh install zpresto

iterm key bindings