Longtime Red Wings GM and Hockey Hall of Famer Ken Holland joined the NHL in a new consulting role just months after parting with the Edmonton Oilers.