judgement day

I've come across the phrase a few times and don't fully understand it. What was it? Why were people tense? Why did Tricky reference it? Why did the person below think the arrival of the millennium was a blow to Ballard? I remember talk of the millennium bug, but there's clearly more to it than...