Jeremy Jameson jeremy-jameson

# Sign PowerShell profile

$cert = Get-ChildItem Cert:\CurrentUser\My -CodeSigningCert

Set-AuthenticodeSignature -FilePath $PROFILE -Certificate $cert

# Download PowerShell profile

$url = "https://raw.githubusercontent.com/jeremy-jameson" `
    + "/Toolbox/main/PowerShell/Microsoft.PowerShell_profile.ps1"

Invoke-WebRequest -Uri $url -OutFile $PROFILE -UseBasicParsing

# Configure symbolic links for Git repositories

# Configure symbolic links for GitHub repos not stored in "\NotBackedUp\GitHub"

Push-Location C:\NotBackedUp\GitHub

cmd /c mklink /J jeremy-jameson "C:\BackedUp\GitHub\jeremy-jameson"
cmd /c mklink /J technology-toolbox "C:\BackedUp\GitHub\technology-toolbox"

	Name	StartupOrder
	CIPHER01	4
	CON-ADFS01	302
	CON-DC05	300
	CON-DC06	301
	CON-W10-TEST-03	303
	CRYPTID	0
	EXT-ADFS01A	0
	EXT-ADFS03A	108
	EXT-ADFS03B	109

# Start and stop cluster VMs (using System Center Virtual Machine Manager)

# Create cluster VM list with "startup order"

$url = 'https://gist.githubusercontent.com/jeremy-jameson' `
    + '/913c11a4550efe428bbe7d6e1c82c955/raw'

Invoke-WebRequest `
    -UseBasicParsing `

Bulk Create Test E-mail Accounts in Poste.io

$uri = "https://mail-test.technologytoolbox.com/admin/api/v1/boxes"

$userPassword = "{specify test mail password here}"

$adminUsername = "[email protected]"
$adminPassword = "{specify Poste.io admin password here}"
$credentials = "${adminUsername}:${adminPassword}"

	USE [MDW]
	GO

	SET ANSI_NULLS ON
	GO

	SET QUOTED_IDENTIFIER ON
	GO

	ALTER PROCEDURE [snapshots].[rpt_query_stats]

	IF OBJECT_ID('tempdb.dbo.#CommandQueue', 'U') IS NOT NULL
	BEGIN
	DROP TABLE #CommandQueue
	END

	CREATE TABLE #CommandQueue
	(
	ID INT IDENTITY (1, 1)
	, SqlStatement VARCHAR(1000)
	)