If you have time while in Alpharetta, try to find Jekyll Brewing. Their Pineapple Habenero Hop Dang Diggity is awesome.
The Kroger off Windward Parkway actually has (or at least had last time I was there) a decent selection of local'ish beer.
If you get to "downtown" Alpharetta, Currahee Brewing has some decent beers and the BBQ place next door is good too.
I used to end up there twice a year for work and never got much of a chance to venture out from right around where we were, but there's some good beer to be had in Alpharetta.
Taco Mac has a pretty vast selection of local and nonlocal beers too, and decent food.
I've not had a chance to hit any of the breweries in Birmingham, but I have had quite a few of their beers.
The current standouts for me are "Judge Juicy" from Ghost Train, and the IPA from Good People. Trim Tab from Birmingham has some good stuff. The couple of things I've gotten from Avondale I remember being decent. "Naked Pig" from Back Forty is ok.
If you see anything from Yellowhammer in Huntsville, Cheatin Heart IPA, Belgian White, and T-Minus are all pretty tasty.