Adriaan, I was in Dubai back in the early 1990's. It's true that alcohol isn't allowed there, but there are quite a few hotels that have bars. So, yes you can get drunk in Dubai. Dubai is a lot more liberal than some other Arab countries. Actually, my sister is working near Dubai now, in Fujairah. It's a great place to visit.
Mike