The veteran record executive didn't sing or play an instrument. But his instincts made him one of the surest spotters and nurturers of talent in pop history.