There was a very enlightening and candid series of posts written on here a few years ago by a pilot who suffered from alcoholism, but sadly I cannot remember his name.
Use the search function to see what you can dig up. I will keep looking and let you know if I find anything.