All blog posts

RSS feed for all blog posts
Arrows representing a cycle, followed by the text "Automated Releases Versioning and Publishing".

Automated Releases Versioning and Publishing using Github Actions, Conventional Commits, Release-Please and Renovate

#programming #devops
Read

Check the tools I use for the versioning and publishing of my releases

Four laptops seemingly connected to a huge central microship.

Developing Ansible playbooks with Vagrant - Tips & Tricks

#programming #sys-admin #infra-as-code
Read

Do you want to develop Ansible playbooks and test them under Vagrant? Here are some random tips&tricks

A seated bearded man holding a hammer in his left hand while looking pensively at it, suggesting that he is tempted to use it to break the computer that is in front of him

Safely delete large number of records by using a loop

#programming #sys-admin #sql
Read

Deleting a large number of rows is risky in SQL as it involves a resource intensive transaction. This article presents a method to split that single transaction into multiple smaller ones.

Conceptualized image showing a digital fingerprint, linked by electronic traces to servers

Generate new (random) integer ID when ID column is not identity

#programming #sys-admin #sql
Read

Tip to generate integer IDs in SQL databases when the ID column does not have the identity specification

Split in two. Left half shows the bandcamp logo on a purple background; right half shows musicbrainz picard's logo on a blue background. A plus sign is shown in the middle.

Rename Bandcamp single for easier consumption by MusicBrainz Picard

#misc
Read

Learn how to organize singles downloaded from Bandcamp into artist/album/track so it can be consumed more easily

Official lineage os logo

Install LineageOS with MicroG and playstore

#misc
Read

Install LineageOS with MicroG and full playstore support

Bearded man seen from the back, sat in front of a computer screen. A loading wheel appears on said screen along with the title "Recovery"

Restore a MS SQL Server backup on Linux

#programming #sys-admin #sql
Read

Because restoring a MS SQL Server backup from a Windows server onto your machine can be a pain

Big padlock along with the title "SSH". A physical server is visible in the background.

Manage SSH keys between a Linux client and Server

#sys-admin #linux
Read

Learn how to create an SSH key-pair a copy the public key onto a remote server for passwordless access

Screenshot of a website showing a grid of cards

Infinite and responsive CSS grid

#programming #css
Read

Learn how to create infinitely long and responsive CSS grids for displaying various repeating items