It is possible to drive back and forth but not recommended. Depends a lot on where you live in Dubai. Somewhere on the south side with good access to SZH will help.
Foggy mornings make it a very dangerous drive.
I did the Deira side of the Creek in Dubai (the wrong side) to Masdar City (very close to SZC) for 6 months. OK going in the morning. Approx 1 hour. Nightmare coming back in the evening - solid traffic from Jebel Ali inbound.
There may also be restrictions on where you live if you are drawing an accommodation allowance from the Abu Dhabi Govt.