There is no such hard and fast rule, that for every surgery, patient has to be unconscious. Especially during surgeries like brain, the actual functioning of it would be known better, if the patients are awake.

Also read: Man plays guitar during his brain surgery

Here is one such surgery, where his brain is being operated behind and he is singing song and talking with the people around him.    

By Phani