I suggest your SIL (sister-in-law) find a support group or counselor. Alanon is a support group for friends and family members of alcoholics. It is based on the same 12 steps and 12 traditions of AA (Alcoholics Anonymous).
I appologize: I will not be able to help you determine if your brother is an alcoholic or if he is just immature.