Skip to content

Instantly share code, notes, and snippets.

View erichexter's full-sized avatar

Eric Hexter erichexter

View GitHub Profile
@erichexter
erichexter / gist:c30f2f207023758a3087304977f7e866
Created March 19, 2022 01:52
DynamoDB resources for recovering sql server developers
AWS re:Invent 2020: Data modeling with Amazon DynamoDB – Part 1 https://www.youtube.com/watch?v=fiP2e-g-r4g&t=809s
AWS re:Invent 2020: Data modeling with Amazon DynamoDB – Part 2 https://www.youtube.com/watch?v=0uLF1tjI_BI
AWS re:Invent 2021 - DynamoDB deep dive: Advanced design patterns https://www.youtube.com/watch?v=xfxBhvGpoa0
Fundamentals of Amazon DynamoDB Single Table Design with Rick Houlihan https://www.youtube.com/watch?v=KYy8X8t4MB8
https://www.dynamodbbook.com/
https://github.com/alexdebrie/awesome-dynamodb
@erichexter
erichexter / info
Last active December 18, 2018 10:47
PS C:\> docker version
Client:
Version: 18.09.0
API version: 1.39
Go version: go1.10.3
Git commit: 33a45cd0a2
Built: unknown-buildtime
OS/Arch: windows/amd64
Experimental: false
{
"format_version": "1.8.0",
"minecraft:entity": {
"description": {
"identifier": "economy:banker",
"is_spawnable": true,
"is_summonable": true,
"is_experimental": false
},
"component_groups": {
fill 1 8 34 1 8 34 stone_stairs 0
fill 1 24 24 1 24 24 stone_stairs 4
fill 2 5 15 2 5 15 spruce_stairs 0
fill 2 5 17 2 5 17 stone_stairs 0
fill 2 5 24 2 5 24 stone_stairs 0
fill 2 5 31 2 5 31 stone_stairs 0
fill 2 5 33 2 5 33 spruce_stairs 0
fill 2 8 34 2 8 34 stone_stairs 5
fill 2 9 32 2 9 32 spruce_stairs 0
fill 2 9 33 2 9 33 spruce_stairs 0
use master
go
declare @dbnames nvarchar(max)
declare @statement nvarchar(max)
set @dbnames = ''
set @statement = ''
select @dbnames = @dbnames + ',[' + name + ']' from sys.databases where name like 'qs_a%' or name like 'qs_int%' or name like 'qs_ui%'
if len(@dbnames) = 0
begin
print 'no databases to drop'
$subscriptions=Get-AzureRmSubscription | select-object SubscriptionId -Unique
$rg=@()
$subscriptions | % {$_; Set-AzureRmContext -SubscriptionId $_.SubscriptionId ; $rg += Get-AzureRmResourceGroup|select-object Resourc
eGroupName}
mkdir c:\temp
cd c:\temp
Invoke-WebRequest -UseBasicParsing http://packages.diladele.com/squid/3.5.22/squid.msi -OutFile c:\temp\squid.msi
.\squid.msi #need to automate this or use chocolatey.org
New-NetFirewallRule -Name Squid -DisplayName Squid -Direction Inbound -Action Allow -Protocol TCP -LocalPort 3128
@erichexter
erichexter / brainstorming-docker-net.md
Last active October 4, 2016 13:42
proposed docker layering for legacy .net 4.xxx applications using octopus deploy

Container layering

# Name Description
1 WindowsServerCore Made and Versioned by Microsoft
2 App Dependencies IIS/Websockets/ARR/.Net 4.6/VSRuntime...ect - Made and versioned by [My Company] patched adhoc
3 Release Bits for Application Created as part of build process image per release/build.
4 Enviornment / Tenant specific Configuration Contains configuration files for that tenant release combination using octopus variable replacement - Created by Octopus Deploy (because this contains tenant configuration). It is not a onetime process but rather updated as we push out deployments.

Build/CI/Cd Pipeline

// ==UserScript==
// @name Refresh Queue page
// @namespace http://tampermonkey.net/
// @version 0.1
// @description try to take over the world!
// @author You
// @match https://*.quarterspot.net/Queues*
// @grant none
// ==/UserScript==
iwr https://gist.githubusercontent.com/erichexter/fcebbea98fdacb75a36f8ae83425fe82/raw/installapps.ps1 -UseBasicParsing | iex