Situation: There is a table in our SQL database which contains rows which we consider duplicate based upon the values in some or all of the columns. We wish to delete these duplicate rows. Objective: To demonstrate and explain a short memorable method of deleting duplicate rows in a SQL database table using a common […]

Situation: You are reaching or exceeding the RAM limits of your Linux VPS. Objective: An increase in the amount of non-virtualized memory available to your applications on your VPS without resorting to paying for an upgraded VPS. Plan + Execution:

Situation: We have an Acer C720 Chromebook and want Chrome OS removed and Bodhi Linux installed on it. Additionally we want to have it boot to Linux by default without having to start SeaBIOS manually by pressing Ctrl + L at the white boot splash screen. Objective: Acer C720 Chromebook with Chrome OS removed and […]

Situation: You wish to have certain files encrypted on your VPS and you do not want to repartition to accommodate an encrypted volume on a partition or logical volume. Objective: A mountable LUKS encrypted volume based on a file in the filesystem. Plan + Execution: Install cryptsetup: If cryptsetup is not installed already, use the […]

Situation: You are reaching or exceeding the RAM limits of your Linux VPS. Objective: An increase in the amount of non-virtualized memory available to your applications on your VPS without resorting to paying for an upgraded VPS. Plan + Execution:

Situation: Following a guide on the internet such as this one here for getting Linux installed on an Acer C720 Chromebook, summarized you: Switched the Chromebook to Developer Mode Enabled SeaBIOS Made SeaBIOS default on boot. Installed Linux Objective: Restore the Acer C720 Chromebook back to factory stock. Plan + Execution: