matthiasguentert

Smoothing out a video...

ffmpeg -i input.mp4 -filter:v "minterpolate='mi_mode=mci:mc_mode=aobmc:vsbmc=1:fps=30'" output.mp4

Crop a video

ffmpeg -i input.mp4 -filter:v "crop:1920:1080:100:50" output.mp4

matthiasguentert

Show response headers & body

curl --include https://somehost

Show only response header

curl --head https://somehost
curl -I https://somehost

matthiasguentert

Get AKS pods logs

let startTimestamp = ago(1h);
KubePodInventory
| where TimeGenerated > startTimestamp
| project ContainerID, PodName=Name
| distinct ContainerID, PodName
| join
(
    ContainerLog

matthiasguentert

create table debug.employee_trail (
	id serial PRIMARY KEY, 
	operation varchar(6) not null, 
	employee_id integer not null, 
	timestamp timestamp not null
);

create or replace function debug.f_employee_changed() returns trigger as 
$$

matthiasguentert

Iterate over all tables in a db and count its rows

declare @name varchar(100)
declare @sql nvarchar(300)

declare cur cursor for
    select name from sys.tables where type = 'U' and schema_id = 1
open cur

fetch next from cur into @name

matthiasguentert

Base64 Encode String

$input = "Foobar🤪"
$byteString = [System.Text.Encoding]::UTF8.GetBytes($input)
$base64String = [System.Convert]::ToBase64String($byteString)

Base64 Decode String

$input = "Rm9vYmFy8J+kqg=="

matthiasguentert

Count all tables in a database

-- Count number of tables 
select count(*)
from information_schema.tables
where table_schema = '<my-schema>'

-- Warning! Might return inaccurate results!
select TABLE_NAME, TABLE_ROWS
from information_schema.tables

matthiasguentert

Set default resource group

az config set defaults.group=MyResourceGroup

Set default subscription

az account set --subscription <name or id>

matthiasguentert

Azure CLI version

az monitor action-group create --name ag-notify-admins --resource-group rg-training --action email action-send-mail admin@host.org

# Install App Insights extension (requires Azure CLI 2.0.79 or higher)
az extension add --name application-insights 

# Retrieve resource id 
$scope = az monitor app-insights component show --app appi-demo --resource-group rg-training --query id --output tsv

matthiasguentert

Forwarding ports

kubectl port-forward --namespace=<namespace> <pod> <localport>:<podport>

# JVM remote debug 
kubectl port-forward --namespace=<namespace> <pod> 5005:5005

Forcefully remove a PVC & PV