Skip to content

Instantly share code, notes, and snippets.


Jeremiah Peschka peschkaj

View GitHub Profile
LitKnd / Mmmm_Chocolatey.ps1
Last active Dec 10, 2020 — forked from SQLvariant/Mmmm_Chocolatey.ps1
Install SQL / Data Developer Desktop Tools from Chocolatey
View Mmmm_Chocolatey.ps1
Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString(''))
choco install chocolatey -y
choco install sql-server-2017 -y #developer edition
choco install sql-server-management-studio -y
choco install azure-data-studio -y
choco install azuredatastudio-powershell -y
choco install git.install -y
choco install poshgit -y
View 1.cpp
#include <iostream>
using namespace std;
class Monster {
Monster(int initial_hp);
void attack() const;
binaerbaum / arch-linux-install
Last active Apr 6, 2022 — forked from mattiaslundberg/arch-linux-install
Minimal instructions for installing arch linux on an UEFI NVMe system with full system encryption using dm-crypt and luks
View arch-linux-install
# Install ARCH Linux with encrypted file-system and UEFI
# The official installation guide ( contains a more verbose description.
# Download the archiso image from
# Copy to a usb-drive
dd if=archlinux.img of=/dev/sdX bs=16M && sync # on linux
# Boot from the usb. If the usb fails to boot, make sure that secure boot is disabled in the BIOS configuration.
# Set swiss-french keymap

emacs --daemon to run in the background. emacsclient.emacs24 <filename/dirname> to open in terminal

NOTE: "M-m and SPC can be used interchangeably".

  • Undo - C-/
  • Redo - C-?
  • Change case: 1. Camel Case : M-c 2. Upper Case : M-u
  1. Lower Case : M-l
bigsnarfdude / gist:b2eb1cabfdaf7e62a8fc
Last active Mar 8, 2021
ubuntu 14.04 install scala 2.11.7 and sbt 13.9 and java 8 and git
View gist:b2eb1cabfdaf7e62a8fc
# scala install
sudo dpkg -i scala-2.11.7.deb
# sbt installation
echo "deb /" | sudo tee -a /etc/apt/sources.list.d/sbt.list
sudo apt-key adv --keyserver hkp:// --recv 642AC823
sudo apt-get update
sudo apt-get install sbt
peschkaj / match_queries_by_hash.sql
Created Mar 24, 2014
This will match SQL Server statements to the appropriate portion of the execution plan based on the query_plan_hash
View match_queries_by_hash.sql
SELECT QueryPlanHash,
CASE WHEN QueryType LIKE '%Stored Procedure%' THEN
QueryPlan.value('declare namespace p="";
sum(//p:StmtSimple/@StatementSubTreeCost)', 'float')
QueryPlan.value('declare namespace p="";
sum(//p:StmtSimple[xs:hexBinary(substring(@QueryPlanHash, 3)) = xs:hexBinary(sql:column("QueryPlanHash"))]/@StatementSubTreeCost)', 'float')
END AS cost, *
FROM #procs
mikesmullin /
Last active Aug 16, 2022
Notes on x86-64 Assembly and Machine Code

Mike's x86-64 Assembly (ASM) Notes

Assembling Binary Machine Code

Operating Modes:

These determine the assumed/default size of instruction operands, and restricts which opcodes are available, and how they are used.

Modern operating systems, booted inside Real mode,

pbailis / gist:5660980
Last active Apr 27, 2020
Assorted distributed database readings
View gist:5660980

Context: I was asked for a list of interesting reading relating to "distributed databases, behavior under partitions and failures, failure detection." Here's what I came up with in about an hour.

For textbooks, "Introduction to Reliable and Secure Distributed Programming" is a superb introduction to distributed computing from a formal perspective; it's really not about "programming" or "engineering" but about distributed system fundamentals like consensus, distributed registers, and broadcast. Used in Berkeley's Distributed Computing course (and HT to @lalithsuresh) Book Site

Notes from courses like Lorenzo Alvisi's Distributed Computing class can be great.

There are a bunch of classics on causality, [Paxos](ht

View LosslessJson.csx
using ImpromptuInterface;
using Newtonsoft.Json.Linq;
* This example was inspired by
* "Serialization is Lossy"