I unfortunately didn't have a chance to go to any of the festivities, but I heard there was a plenty of celebrating. You could certainly hear the cheering coming from all directions during the hour after we won. Though I doubt it was anything like after the Sox won back in 2004, which came after their infamous 84-year losing streak. I know the police were certainly well prepared for rioting this time; while walking to a friend's dorm before game 4, I came across a group of about 50-70 police officers gathering around and getting briefed or whatnot in preparation for a win that night. And that was just in one random spot on the edge of campus. There also would have probably been more rioting if the Sox had won at Fenway park instead of in Denver, but we would have had to lose two games for the series to end in Boston (like that was gonna happen

). Nonetheless, on the walk back to my dorm after the game there were at least five or six helicopters flying around in the sky that I could spot.
So it doesn't sound like there was anything insane that happened this time around (at least not that I heard about), but all of Boston was really quite happy ;-)