Guides for working with remote servers

Practical write-ups on the problems that come up when you manage servers day to day — explained in plain language, without assuming you already know the jargon.

Troubleshooting

Why Browsing Folders Over SFTP Is So Slow (and What Actually Fixes It)

A single big file downloads at full speed, but opening a project folder takes minutes. Bandwidth is not the problem — thousands of tiny round trips are. Here is the arithmetic, and the one-command fix.

Guide

How to Upload a Large File to a Server Without Starting Over When It Fails

The upload dies at 90% and the progress bar resets to zero. Interruptions are normal and unavoidable — what matters is whether your tool can continue from where it stopped, and how you know the file that finally arrives is not quietly corrupt.

Guide

How to Keep a Folder on Your Computer and a Folder on Your Server in Sync

Dragging the whole folder over wastes minutes re-sending files that never changed; picking files by hand means eventually missing one. How folder sync compares the two sides, and the two settings that decide what gets deleted.

Tutorial

How to Connect to a Remote Database From Your Own Computer

Your database tool times out every time you point it at the server, and the advice you find online tells you to open a port to the internet. Here is why that is the wrong fix, and how an SSH tunnel gets you connected in a minute without changing anything on the server.

Troubleshooting

Why Your SSH Connection Keeps Dropping (and How to Keep It Alive)

You step away for five minutes and come back to a frozen terminal. It is almost never your internet — something in the middle quietly discarded an idle connection and told nobody. Here is what is really happening and the two settings that fix it for good.

Workflow

How to Stop Retyping the Same Commands Every Time You Log Into a Server

Change directory, activate the environment, check the logs — the same opening routine, every session, remembered entirely in your head. Three ways to write it down instead, and a clear guide to which one suits your situation.

Guide

Password or SSH Key: Which Should You Use to Log Into Your Server?

Everyone says use keys. Far fewer explain what a key actually is, why it is safer, or what happens if you lose one. A complete plain-English answer — including how to switch over without locking yourself out of your own server.