A man has appeared in court charged with the murder of a part-time DJ whose body was found in a slurry tank two years after he went missing.