Category: Tutorials

  • How to: Dual Boot Windows 11 and Kubuntu Linux on Microsoft Surface Laptop 4

    —

    by

    ro
    in

    Last update: Oct 2025 Motivation I got a pretty neat refurbished Surface Laptop and I will use it as my swiss army knife when it comes to troubleshoot computer stuff. I have equipped it with a 2TB SSD. In short we will do the following: 1. Preparation– enable Secure Boot– ensure there are no other…

  • How to: Crack Excel sheet protection

    —

    by

    ro
    in

    Last update: Sept 2025 Motivation One client asked me how to make adjustments to a protected Excel worksheet. He forgot the password which he used longer time ago. This has been tested with latest MS Excel version 16.101. Part I: Creating a test file I have opened Excel, entered some random text, added a specific…

  • How to: Linux LVM

    —

    by

    ro
    in

    Last update: Nov 2024 Preface / Motivation Everybody who experienced a default installation of Ubuntu 24.04 or Ubuntu 23.10 and wanted the default encryption to be enabled, will inevitably come across the same problems. Ubuntu’s new installer does not allow you to use your predefined LUKS partitions anymore. LVM (Logical Volume Manager) is mandatory now.…

  • How to: Install PiHole (DNS-Adblocker) and WG-Easy (Wireguard) on Ubuntu with Docker

    —

    by

    ro
    in

    Screenshot Sources Metadata Last update: Dec 2024Tested on: Ubuntu 24.04 Server

  • Cheatsheet of useful Linux commands

    —

    by

    ro
    in

    Last update: Oct 2025 Motivation I am using this for noting my snippets for everyday use. Mostly those commands are tested and developed on latest Ubuntu. Warning Many of those commands here are dangerous and will potentially mess up your system. Be warned: Don‘t use them if you do not know what you‘re doing! Secure…

  • How to: Install PiHole (DNS-Adblocker) and PiVPN (Wireguard) on Ubuntu

    —

    by

    ro
    in

    Metadata Tested with: Ubuntu 24.04, PiHole 5.18.3, PiVPNLast Update: Nov 2024 Requirements 1. Install PiVPN 2. Install PiHole 3. Add powerful adlists Further Configuration Keep in mind that the default setting for WireGuard is ALLOWED_IPS=”0.0.0.0/0, ::0/0″. This means all traffic will be sent through the VPN tunnel. If you plan to make just some specific…

  • How to: Install Nextcloud AiO using Docker and NGINX Proxy Manager

    —

    by

    ro
    in

    Metadata Tested with: Ubuntu 22.04, NC AiO 9.7.0, NPM 2.11.3Last Update: Oct 2024 Requirements Steps 1. Install Docker 2. Config 3. Start containers 4. Config NPM 5. Initial installation Troubleshooting Credits

  • How to: Dualboot Windows +Bitlocker and Kubuntu +LUKS

    —

    by

    ro
    in

    Preparation Tested with Tested with: Win 11 Pro 23H2, Kubuntu 24.04Last Update: 2024-09-29 Environment Steps 1. Create partitions 2. Install Windows 3. Install Kubuntu Both systems can boot up properly now. You will be asked by GRUB which operating system to boot now: Ubuntu or Windows Boot Manager. 4. Activate Windows Bitlocker Good to know…

  • How to: Install VirtualBox 7.1 on Ubuntu 24.04

    —

    by

    ro
    in

    Preparation none Tested with Tested on: Kubuntu 24.04, VirtualBox 7.1Last Update: 2024-10-15 Environment Steps We will install the packages by adding the official repository and installing the packages from there. 1. Adding repository 2. Installing packages 3. Installing Secure Boot Key During reboot you will be asked by UEFI BIOS to enroll the VirtualBox key:…