“I spotted them and I thought they were a really terrific band.” How David Bowie took one of the 90s’ big breakout rock bands under his wing – right before they blew up