The Long Island native has had many memorable concerts at the venue. The “Piano Man” closed it–and reopened it 18 months later