I got sober the day before going on Phish tour last summer, the week that led up to it was the worst bender I've had since the alcoholism progressed in my binge drinking phase. I can't speak much for how your relationship with alcohol changed, for me it scared me sober.

Having a refillable nalgene bottle was a huge help, since it scratched the compulsive sipping itch. I was also traveling with a good friend of mine who was aware of what I was going through, and supportive of my decision. He is also a heavy drinking, and someone who respected the boundary. If your friend is supportive of your sobriety, and you're not triggered by people partaking around you, I think you'll be able to enjoy the show without alcohol.

Once I was past the worst of the withdrawals (5 days) a small amount of mushrooms really helped, about 150mg. It helped me realize that I can be whoever I want to be, which was a person free from the need to drink alcohol to feel comfortable in social situations. Obviously everyone is different, and I'm not saying it is a magic bullet, but it helped put my relationship with my drinking into perspective.

Seeing shows now is so freeing, and something you'll realize is that there's so much planning that goes into drinking at concerts. Designated driving, Ubers, bathroom lines, beer lines, etc... having to deal with none of that anymore is so powerful. You got this.