Skip to content

Instantly share code, notes, and snippets.

View aaronsteers's full-sized avatar
💭
...building stuff...

Aaron ("AJ") Steers aaronsteers

💭
...building stuff...
View GitHub Profile
@aaronsteers
aaronsteers / keybase.md
Created March 4, 2020 22:26
keybase.md

Keybase proof

I hereby claim:

  • I am aaronsteers on github.
  • I am aaronsteers (https://keybase.io/aaronsteers) on keybase.
  • I have a public key ASBYlx4etJQXAgE9xCqRk_hMz9GwjoE8osu7rmrVRmoWzgo

To claim this, I am signing this object:

@aaronsteers
aaronsteers / README.md
Created December 31, 2019 22:10 — forked from cerebrate/README.md
Recompile your WSL2 kernel - support for snaps, apparmor, lxc, etc.

Recompile your WSL2 kernel - support for snaps, apparmor, lxc, etc.

Yes, I've done this, and yes, it works. It is, however, entirely unsupported and assembled through reasonable guesswork, so if you try this and it explodes your computer, brain, career, relationships, or anything else, you agree that you take sole responsibility for doing it, that I never claimed it was a good idea, and that you didn't get these instructions from me .

Also note: I have done this with Debian Stretch. While one kernel ought to fit all, some of the packages you need to build it may be different. Adapting to other distros is up to you.

Step One: Install the stuff you need to build the kernel

@aaronsteers
aaronsteers / AIDungeon.ipynb
Created December 14, 2019 01:28
AI Dungeon
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aaronsteers
aaronsteers / Choco-One-Click.js
Last active April 17, 2022 01:11
Choco install script for TamperMonkey/GreaseMonkey
// ==UserScript==
// @name Choco-One-Click
// @namespace http://tampermonkey.net/
// @version 0.1.1
// @description Install software from chocolatey.org with one-click. This requires choco:// protocol support (choco install choco-protocol-support).
// @author AJ Steers
// @include http://*chocolatey.org/*
// @include https://*chocolatey.org/*
// @grant none
// ==/UserScript==
@aaronsteers
aaronsteers / docker_bootstrap.sh
Created October 22, 2019 19:57
Docker bootstrap script
#!/bin/bash
# Echo this entire script to a logfile.txt
exec > >(tee -a $HOME/logfile.txt) 2>&1
echo "Initializing hostname (needed for ECS)..."
echo "Detecting 'eth1' interface..."
DETECTED_IP=$(ifconfig -a | grep -A2 eth1 | grep inet | awk '{print $2}' | sed 's#/.*##g' | grep "\.")
if [[ -z $DETECTED_IP ]]; then
@aaronsteers
aaronsteers / profiles.json
Created October 9, 2019 23:04
Windows Terminal Settings
// To view the default settings, hold "alt" while clicking on the "Settings" button.
// For documentation on these settings, see: https://aka.ms/terminal-documentation
{
"$schema": "https://aka.ms/terminal-profiles-schema",
"defaultProfile": "{2c4de342-38b7-51cf-b940-2309a097f518}",
"profiles":
[
{
@aaronsteers
aaronsteers / Sample Dark Theme.json
Last active January 5, 2023 22:26
Dark and Light Power BI Theme Files (Scroll down to view the light theme)
{
"name": "Sample Dark Theme",
"background": "#000000",
"backgroundLight": "#9b9b9b",
"backgroundNeutral": "#535353",
"foreground": "#ffffff",
"foregroundNeutralSecondary": "#ffffff",
"foregroundNeutralTertiary": "#ffffff",
"tableAccent": "#0c62fb",
"dataColors": [
@aaronsteers
aaronsteers / DeployTSQLScripts.ps1
Created December 4, 2017 22:40
DeployTSQLScripts
### This script will execute any T-SQL scripts located in a named subfolder (taken as the first script argument).
### Any references to the templated schema name ("DWCI_Test") will be replaced with the value that is provided
### as the 2nd command line argument.
Param(
[string]$subFolder,
[string]$deploymentSchema
)
$ErrorActionPreference = "Stop"
@aaronsteers
aaronsteers / .gitlab-ci.yml
Created December 4, 2017 22:38
Sample GitLab CI file (YAML)
## A simple CI script that builds the data warehouse and tests that any dependent views are still able to compile
##
##
## Schema Names:
## dw production schema
## dev shared development schema
build_on_master:
stage: build
@aaronsteers
aaronsteers / CalendarGenerator.m
Last active December 13, 2023 08:54
Power BI Calendar Function
# Step 1: Create a CalendarGenerator() function and paste the contents below into the Advanced Editor
let CreateDateTable = (StartDate as date, EndDate as date, optional Culture as nullable text) as table =>
let
DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),
RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date])),
InsertQuarter = Table.AddColumn(InsertYear, "Quarter Number", each Date.QuarterOfYear([Date])),