kmatt / EnableRDP.ps1

Created August 21, 2025 21:43 — forked from asheroto/EnableRDP.ps1

Enable RDP on a computer with PowerShell.

	# Warning
	Clear-Host
	Write-Output "Run this script on the computer you want to access via RDP"
	Write-Output ""

	# Ask
	Write-Output "Remote address can be an IP address or network with CIDR"
	Write-Output "Example: 192.168.0.5 or 192.168.0.0/24"
	Write-Output ""
	$RemoteAddress = Read-Host "Remote Address"

kmatt / zeddiff.md

Created July 10, 2025 17:11

Side-by-side diff in Zed

~/.gitconfg

[core]
    pager = delta

[interactive]
 diffFilter = delta

kmatt / slugifile.sh

Last active July 1, 2025 19:49

Slug filenames in directory

	#!/bin/bash

	if [ "$#" -eq 0 ]; then
	echo "Usage: $0 FILENAME \| 'WILDCARD' (in single quotes)"
	exit
	fi

	slug() {
	# Replace non-alpha characters and rename file
	f=$(basename "$1")

kmatt / postgresql_is_enough.md

Created May 15, 2025 04:47 — forked from cpursley/postgresql_is_enough.md

Postgres is Enough

PostgreSQL is Enough

Background and Cron Jobs

kmatt / gistbackup.sh

Created January 10, 2025 05:30

Download all Gists using Github CLI

	# Download all Gists
	for i in $(gh gist list -L 1000 \| cut -f1); do echo "ID: $i"; gh gist view $i > $i; done

	# Rename each file with a slug of the first line / description
	for f in *; do mv -v $f $(gawk 'NR==1{gsub(/[^[:alnum:]]/, "-"); gsub(/-+/, "-"); print $0 "_" FILENAME}' $f); done

kmatt / airline.zsh-theme

Created January 8, 2025 00:29 — forked from stooj/airline.zsh-theme

	#
	# This shell prompt config file was created by promptline.vim
	#
	function __promptline_host {
	local only_if_ssh="0"

	if [ $only_if_ssh -eq 0 -o -n "${SSH_CLIENT}" ]; then
	if [[ -n ${ZSH_VERSION-} ]]; then print %m; elif [[ -n ${FISH_VERSION-} ]]; then hostname -s; else printf "%s" \\h; fi
	fi
	}

kmatt / wef.ps1

Created December 20, 2024 21:42

Select and browse Windows event logs with FZF

(Get-EventLog *).Log | fzf | % { Get-EventLog -LogName $_.Trim() -after (Get-Date).AddDays(-7) } | fzf

kmatt / SMOScripter.ps1

Last active November 20, 2024 02:13

Script SQL Server database to individual files for schema history

	param ([string]$s, [string[]] $d, [switch]$commit, [switch]$verbose, [string]$path=(Get-Location))

	# Install-Module -Name SqlServer -Scope CurrentUser

	# Systemd service unit:
	# ExecStart=/usr/bin/pwsh /localdata/SMOSchema/scripter.ps1 -s ALL -commit
	#
	# Add to $SERVICENAME.service.d/override.conf
	# [Service]
	# Environment=SQLCMDUSER=

kmatt / pl_to_sql.py

Last active November 19, 2024 02:05 — forked from bthaman/df_to_sql_fast.py

Polars dataframe to SQL Server using pyodbc, without Pandas or SQLAlchemy dependencies

	def pl_to_sql(df, table, replace=False):
	"""
	to_sql() without Pandas
	Appends or overwrites a SQL Server table using data from a DataFrame

	Parameters:
	df (DataFrame): df used to create/append table
	table (str): Name of existing SQL Server table
	replace (bool): Truncate before insert
	Returns:

kmatt / ddb_rowhash.txt

Created November 11, 2024 15:21

DuckDB rowhash

	SELECT tbl::TEXT, HASH(tbl::TEXT), MD5(tbl::TEXT) FROM tbl;

	D create table tbl as (select 1 as a, 2 as b, 3 as c);
	D select tbl::text, hash(tbl::text), md5(tbl::text) from tbl;
	┌──────────────────────────┬────────────────────────────┬──────────────────────────────────┐
	│ CAST(tbl AS VARCHAR) │ hash(CAST(tbl AS VARCHAR)) │ md5(CAST(tbl AS VARCHAR)) │
	│ varchar │ uint64 │ varchar │
	├──────────────────────────┼────────────────────────────┼──────────────────────────────────┤
	│ {'a': 1, 'b': 2, 'c': 3} │ 6764392534128998287 │ e31681d6e7ab078c9679fcd4f50136eb │
	└──────────────────────────┴────────────────────────────┴──────────────────────────────────┘