Thomas' Tech Tips
Weekly technical tips and tricks
Hiatus
10 April 2024
Date range from week number in Excel or LibreOffice
19 March 2024
Import CSV file into SQLite table
12 March 2024
Show table structure in SQLite
5 March 2024
How to disable GPU acceleration in New Teams
25 February 2024
Set keyboard repeat rate and delay in MacOS
18 February 2024
Reload tmux configuration file
11 February 2024
How to make bootable Windows 10 install USB from Linux
4 February 2024
Avoid saving command in shell history
28 January 2024
sudo without password
21 January 2024
CIDR IP Subnets
24 December 2023
NATO phonetic alphabet
17 December 2023
Disable .DS_Store File Creation on Network Volumes on MacOS
10 December 2023
Rip the sound off of a video file and save it as mp3
3 December 2023
Make a copy of a video file without the sound
26 November 2023
Convert numbers stored as text in Excel to actual numbers
19 November 2023
Delete all files except certain type from a batch file
12 November 2023
Fix issue with missing photos when connecting iphone to windows
5 November 2023
Use spell-checking in Vim
29 October 2023
Find top N clients in apache webserver log
20 October 2023
How to manually trim SSD without fstrim
13 October 2023
How to sleep for X seconds in a Windows batch file
6 October 2023
Restore missing advanced power settings in Windows
29 September 2023
Graphical ping in terminal using gping
22 September 2023
List installed Debian packages sorted by disk space usage
15 September 2023
Start Windows performance monitor data collector automatically at start up
8 September 2023
Escape Question Mark in Excel Conditional Formatting
1 September 2023
Generate a stream of ones
25 August 2023
Record terminal session using script
18 August 2023
Kill processes running on a specified port
11 August 2023
How to use Wake on LAN
4 August 2023
Extract specific pages from PDF
28 July 2023
Enable Dark Mode in Microsoft Office 365
21 July 2023
Merge video and audio files into one a single mp4 file
14 July 2023
Fix display issue with Microsoft Remote Desktop on Dual Monitor system
7 July 2023
Canonical URLs in Jekyll templates
30 June 2023
Sort collection by property in Jekyll liquid template
23 June 2023
See size of each snapshot in restic backup repository
16 June 2023
How to manage iptables firewall rules on Ubuntu in Oracle Cloud Infrastructure
31 May 2023
How to list tables in an SQLite Database
24 May 2023
How to undo close window in Firefox
17 May 2023
Print only first N characters of string in Django template
10 May 2023
Add N days to current date in PostgreSQL
3 May 2023
Redirect output of SQL query to a file from inside psql
26 April 2023
How to mount network drive from command-line on Windows
19 April 2023
Show query execution time in PostgreSQL
12 April 2023
How to disable AutoSave by default in Microsoft Office
5 April 2023
How to create encrypted LUKS volume in a file
29 March 2023
Serve git repository using built-in git daemon
22 March 2023
Send email reminders from the shell
15 March 2023
How to start a detached process inside a screen on boot
8 March 2023
How to detach a screen nested within another screen
1 March 2023
Rescue non-bootable Linux system from a rescue cd and chroot
22 February 2023
How to fix issue with Linux unmounting filesystem immediately after mounting
15 February 2023
Enable or disable memory compression in Windows
8 February 2023
How to restore the default document template in Microsoft Word
1 February 2023
How to fix "yt-dlp" error "download_content() got an unexpected keyword argument"
31 January 2023
How to disable Cortana in Windows 10
25 January 2023
How to disable a user's password in Linux
18 January 2023
How to increase Keyboard Repeat Rate to more than KDE Systems Settings allow
11 January 2023
Increase keyboard repeat rate to more than Keyboard Settings in Windows Control Panel allows
4 January 2023
How to configure Keyboard Repeat Rate in KDE
30 December 2022
How to increase Keyboard Repeat Rate in Windows
23 December 2022
Change keyboard layout in Linux from command-line
17 December 2022
Poor man's iperf using netcat
10 December 2022
Fix broken packages on Red Hat Linux on Azure
3 December 2022
Fix trust issues with Let's Encrypt TLS certificates on Red Hat Enterprise Linux 7
27 November 2022
How to stripe over multiple disks using LVM
20 November 2022
How to connect Keychron K8 Pro keyboard via Bluetooth
15 November 2022
How to pair bluetooth device with LibreElec using bluetooth authentication code
13 November 2022
Print all except the first and last few lines of a file
6 November 2022
How to enable timestamps in dmesg
30 October 2022
How to view and flush DNS cache on Windows
23 October 2022
Access BIOS and boot from USB on Lenovo Yoga Slim Pro 7i
16 October 2022
Make MacOS hosted Minecraft games visible over LAN
9 October 2022
Use netcat to copy a file over the network
2 October 2022
Shrink LUKS volume with ext4 filesystem
27 September 2022
Convert LUKS volume from version 2 to version 1
20 September 2022
How to verify SSH host key fingerprint
13 September 2022
How to change passphrase on an SSH private key
6 September 2022
How to generate new ed25519 SSH host keys
30 August 2022
How to suppress SSH banner on login
23 August 2022
Fix X-Forwarding on Linux
16 August 2022
How to escape single quotes with awk
9 August 2022
Disable ACLs in Cygwin
2 August 2022
Install Cygwin packages easily with apt-cyg
27 July 2022
Enable Cygwin Bash Prompt Here Context Menu in Windows
20 July 2022
Reload PostgreSQL configuration without restarting
14 July 2022
Show battery percentage in MacOS
10 July 2022
Move a window by clicking anywhere on it in MacOS
5 July 2022
Convert FLAC to MP3 using ffmpeg while retaining all ID3 metadata
30 June 2022
Search and Replace across multiple lines with Vim
24 June 2022
See the size of PostgreSQL databases
10 June 2022
Enabling TRIM/DISCARD on Debian, ext4, luks, and lvm
3 June 2022
How to determine which LUKS passphrase belongs to what key slot
27 May 2022
How to enable BIOS mode on Corsair Strafe RGB
20 May 2022
Enable debug info with Kerberos and ssh
13 May 2022
How to speed up Cygwin startup time
6 May 2022
How to list installed Cygwin packages
29 April 2022
How to utilize 256 colors in Konsole
22 April 2022
How to disable desktop effects in KDE
15 April 2022
Configure DNS search domain on Red Hat
8 April 2022
DNS lookups through SOCKS proxy with Firefox
1 April 2022
Using sparse files in Linux
27 March 2022
Convert HTML files to PDF
20 March 2022
Fix ping for regular users in Linux
13 March 2022
How to trim filesystem from PowerShell
6 March 2022
See current connections in PostgreSQL
3 March 2022
grep trick to hide grep in ps process list
27 February 2022
Have grep show results from binary files
20 February 2022
Tags
analytics
apache
apple
apt
at
audio
awk
azure
backup
bash
bat
batch
binary
bios
bluetooth
boot
calc
calendar
chroot
cidr
cloud-pc
cmd
config
conversion
csv
cygwin
darkmode
databases
debian
django
dns
dpkg
encryption
excel
ext4
ffmpeg
finder
firefox
firewall
fix
flac
games
git
gnu
gpu
grep
grub
hacks
hardware
hdparm
howto
icloud
initramfs
ip
iphone
iptables
ipv4
jekyll
kde
kerberos
keyboard
keyboards
keychron
konsole
lenovo
letsencrypt
libreelec
libreoffice
linux
liquid
list
locale
logs
luks
lvm
mac
macos
mail
markdown
mdadm
meta
microsoft
minecraft
ms-office
multimedia
netcat
network
o365
oci
office
onedrive
openssh
oracle
pdf
perfmon
performance
ping
postgresql
powerpoint
powershell
pqsl
privacy
ps
psql
python
raid
redhat
reference
remote-desktop
restic
rhel
samba
screen
script
security
seo
shell
spreadsheet
sql
sqlite
ssd
ssh
storage
sudo
systemd
teams
template
tip
tips
tls
tmux
tools
troubleshooting
ubuntu
video
vim
wakeonlan
web
windows
windows-365
wol
word
x
xfs
youtube-dl
yt-dlp
zsh