🎣

Stephen Griffiths SteGriff

🎣

Aspiring Jesus follower; successful nerd.

SteGriff / clock.htm

Created April 11, 2018 09:08

Vanilla JS loading indicator using Unicode clocks

	<!DOCTYPE HTML>
	<html>
	<head>
	<title></title>
	<meta http-equiv="content-type" content="text/html; charset=utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<style>
	.big{font-size:120%;}
	</style>
	</head>

SteGriff / base.htm

Last active August 14, 2023 14:17

Base HTML

	<!DOCTYPE HTML>
	<html lang="en">
	<head>
	<title>Hello</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<!-- <link rel="stylesheet" href="/css/tachyons.css"> -->
	<style>

	</style>

SteGriff / RegAsm.bat

Created November 9, 2017 10:19

A foolproof 32/64 bit regasm script

	@echo off
	REM
	REM Fill in your DLL directory on the cd line
	REM Fill in your DLL name on the two RegAsm lines
	REM
	echo "Registering (thing)..."
	cd "%programfiles(x86)%\Location\OfMy\Library"
	echo "Changed directory. Trying 32 bit..."
	%WINDIR%\Microsoft.Net\Framework\v4.0.30319\RegAsm.exe MyLibrary.dll /tlb /codebase
	if ERRORLEVEL 100 (

SteGriff / Get-WindowsAzurePowerShellVersion.ps1

Created November 7, 2017 11:47

PowerShell cmdlet to get current Azure PowerShell tools version

	# Originally from http://www.maxtblog.com/2014/03/find-your-windows-azure-powershell-cmdlets-version
	function Get-WindowsAzurePowerShellVersion
	{
	[CmdletBinding()]
	Param ()

	## - Section to query local system for Windows Azure PowerShell version already installed:
	Write-Host "Windows Azure PowerShell Installed version: "

	(Get-Module -ListAvailable \| Where-Object{ $_.Name -eq 'Azure' }) \|

SteGriff / Get-Azure-Resource-Types.ps1

Created November 6, 2017 18:10

PowerShell script to recurse thru azure-quickstart-templates, pulling out every azuredeploy.json file and listing the Resource.Types they use

	# PowerShell script to recurse thru github.com/azure/azure-quickstart-templates,
	# pulling out every azuredeploy.json file and listing the Resource.Types they use

	# Initialise an empty list of $types and an optional $limit for how many files to process
	$types = @()
	$limit = 100

	# Set up your cloned repo directory here
	$directory = 'C:\Projects\Ste\azure-quickstart-templates'
	cd $directory

SteGriff / ResourceTypes-2017-11-06.txt

Created November 6, 2017 18:08

All Azure Resource Types used in gallery templates

	Microsoft.ApiManagement/service
	Microsoft.ApiManagement/service/providers/diagnosticSettings
	Microsoft.Authorization/roleAssignments
	Microsoft.Automation/automationAccounts
	Microsoft.Automation/automationAccounts/modules
	Microsoft.Automation/automationAccounts/runbooks
	Microsoft.Backup/BackupVault
	Microsoft.Backup/BackupVault/registeredContainers/protectedItems
	Microsoft.Batch/batchAccounts
	Microsoft.Cache/Redis

SteGriff / attributes.htm

Created August 15, 2017 15:17

Custom HTML attributes in pure JavaScript

	<button type="button"
	submit-item
	data-url="/Controller/Action"
	data-item-code="ABC123">Submit ABC123</button>

	<script>

	//Helper to get data-items without jQuery
	Object.prototype.data = function(x)
	{

SteGriff / bigedit.htm

Created July 27, 2017 14:04

Big Editor

	<!DOCTYPE HTML>
	<html>
	<head>
	<title>Big Edit</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<style>
	body
	{
	font-family: -apple-system, BlinkMacSystemFont, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", sans-serif;

SteGriff / TruthyFalsyVBA.bas

Last active May 3, 2017 13:52

Test which values are truthy and falsy in VBA

	'VBA
	' Results:
	' 1 is truthy but not equal to True
	' -1 is truthy and == True
	' 0 is falsy and == False
	' "True" is truthy and == True
	' "False" is falsy and == False
	Public Sub Test()

	If "True" Then

SteGriff / add-if-not-exists.sql

Last active July 25, 2018 10:07

MS SQL cheat sheets for common tweaks

	-- Add column to table
	if not exists (
	select *
	from sys.columns
	where object_id = OBJECT_ID('MyTable')
	and name = 'MyNewColumn'
	)
	begin
	alter table MyTable
	add MyNewColumn nvarchar(20) null