“Brett was a trusted collaborator to country’s greatest names, and a true advocate for his fellow songwriters," ASCAP said