erichexter

erichexter

Prompt: build an Azure cost-and-waste wiki for our cloud footprint

You're going to set up a private GitHub repository that serves as a grep-optimized knowledge base of our Azure infrastructure, plus a human-readable reporting layer on top of it. The goal is to let me (or anyone with the repo) answer "what do we own, what does it cost, and where are we wasting money" without running ad-hoc az CLI queries each time.

Hard rules

1. READ-ONLY toward Azure. Never run az commands that mutate Azure state (delete, remove, purge, stop, deallocate, scale-down, tag-write, role-assign, etc.). Only list, show, query, and similar read APIs. If a finding suggests a mutation, write the recommendation into the repo and stop — a human will take the action.
2. Exclude personal subscriptions. When az account list runs, compare each subscription's tenantId against the company's tenant. Skip anything that isn't in our company's tenant. Confirm with me which tenant is "ours" before persisting anything.

erichexter

agent-team: Setup Guide (Docker)

Get the AI agent orchestrator running on any machine with Docker. One script handles everything.

Prerequisites

1. Docker Desktop — https://docs.docker.com/get-docker/
2. Git — https://git-scm.com/download/win (or winget install Git.Git)
3. GitHub CLI (optional, for generating runner tokens) — https://cli.github.com

erichexter

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

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

erichexter

{
  "format_version": "1.8.0",
  "minecraft:entity": {
    "description": {
      "identifier": "economy:banker",
      "is_spawnable": true,
      "is_summonable": true,
      "is_experimental": false
    },
    "component_groups": {

erichexter

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

erichexter

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'

erichexter

 $subscriptions=Get-AzureRmSubscription | select-object SubscriptionId -Unique
 $rg=@()
 $subscriptions | % {$_; Set-AzureRmContext -SubscriptionId $_.SubscriptionId ; $rg += Get-AzureRmResourceGroup|select-object Resourc
eGroupName}

erichexter

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