I don't think I do the second brain thing well but keeping some detailed notes (using a daily note at a scratch pad for one off queries, small scripts etc) and occasionally branching them off into dedicated markdown files like "Database debugging" or "MongoDB" has saved me a lot of time on aggregate.