Thursday, October 10, 2013

PASS Summiteers Guide to SQL Pub Crawls

During the last few days’ preparations for the PASS Summit opening in my home town of Charlotte, the idea was tossed around that a pub crawl may be in order. This got me thinking and I’m hoping to lead one next week for anyone that is interested in joining me! It looks like Thursday would work best and I’m actually working on a couple of options. One would make use of the SQL Sentry Shuttle which would allow us to include NoDa and other locations just outside uptown. The other would be an uptown walking loop, as there are plenty of great pubs within walking distance of the Charlotte Convention Center and the many hotels where Summiteers will be staying.


Alexander Michael’s Tavern

Live Updates

In preparation, I’ll be using the Twitter hashtag, #SQLPubCrawl. If I am able to lead this first hand, I’ll post updates and let people know where we are live as the crawl commences. This will also allow anyone to post questions any time from now till the end of the Summit. Maybe you’ve stumbled on a great place with great music, or an unbelievable drink special. Anyone could use the #SQLPubCrawl hashtag to spread the word to the rest of the SQL community!

In case I’m personally unable to lead the crawl, or if there’s enough interest in more than one, I’ve decided to post a couple of options that anyone can follow. Note I’ll refer to the Summit Map & Area Guide as much as possible to make it really easy for anyone interested to guide yourself or your own group throughout the city. Also refer to Greg Gonzalez’s (@SQLsensei) blog on The Craft Beer Scene in Charlotte and Uptown After Hours for more ideas. Some of the stops I’ll mention, while on the map, are not detailed in Greg’s blog. There’s also a chance other SQL Sentry teammates may lead other crawls if the demand calls for it.

Before I detail the possible routes, I actually want to mention one pub that is a bit removed from the rest in uptown but, you should try to get there if you can. That is Alexander Michael’s in Charlotte’s historic 4th Ward. If I lead a crawl, I’m going to try to arrange a special shuttle stop there before starting the rest of the crawl. I would start there as they officially close at 10pm but may stay open later if there are enough customers to do so.

Alexander Michael’s Tavern (Fourth Ward: marker 38)

From their website… “In January 1983 A. Michael Troiano Jr. & Alexander Copeland III (now you know where the name came from) opened a Restaurant & Tavern in the newly revitalized “4th Ward” of Charlotte, North Carolina. It occupies what is historically known as the Crowell-Berryhill Store that originally opened in 1897… The Bar and Back Bar were made from solid oak doors that were originally in the Independence Building which stood on the square at Trade & Tryon streets. The beer cooler is circa 1920 from a Charlotte grocery store.”

As you can see from the map it’s only about a six block walk from stop 3 of the SQL Sentry Shuttle, and worth the side trip. If I can, I’ll try to lead a crawl that provides a “special stop” near there to kick off the crawl. Otherwise an uptown walking tour should start at historic Brevard Court which is two blocks west of the Convention Center straight down MLK Jr. Blvd.

The Walking Tour


Note I’m including the shuttle stop numbers for navigation purposes only, as the following pubs are listed in order of an easy walking route around uptown Charlotte.

Brevard Court (area C: stop 7)

Courtyard Hooligans (marker 20)

Set in one of the most unique and interesting areas of uptown Charlotte, Hooligans describes itself as “…an International Sports Pub with a large import and craft beer selection, along with full liquor bar. The Sports focus is on International sports (soccer/football rugby etc.) along with NFL, NBA, NHL, MLS, and MLB.” If you go, you may want to ensure you know the Manchester United song. Those hooligan’s take their football seriously. If you don’t believe me, just watch this YouTube clip from the last group who went in unprepared. Be forewarned there is one instance of vulgar language in the clip.

The Belfast Mill (marker 19)

I know what you’re thinking, “Another faux Irish themed bar”. Not the case here. In addition to being located in Brevard Court, The Belfast Mill has gained a reputation for being authentic and unassuming. This is a great place to relax and hoist a pint.

Valhalla (marker 23)

From their website…” Named for the "Hall of Slain" featured in Norse Mythology. Valhalla is decked out of brick and wood paneled walls, dark wood benches and dimmed lights (Bring your own breast plates and horned hats). A good selection of beers flows freely along with wine and a nice line-up of single-malt Scotch, while feasting is covered by a Scandinavian inspired pub menu.”

Now we leave Brevard Court and head a couple blocks north to 5th Street. If you haven’t already, and are up to the walk, make the detour to Alexander Michael’s on 9th and Pine now if it’s before 10pm. Otherwise head to:

Dandelion Market (Uptown: Stop 6 or 3, marker 50)

“Taking its name from the famous outdoor market that thrived in Dublin back in the early 70's, Dandelion Market provides Uptown Charlotte with a place for friends and family to gather and enjoy the best in food and drink, served with a smile, in a cozy pub setting.” Note there are bars on both floors, so if things seem crowded downstairs, see if the accommodations are better on the second floor.

Connolly’s on 5th (Uptown, Stop 3, marker 49)

“You are not likely to find your matching shillelagh and shamrock sweater, what you will find are good times, new friends and great beers. If the action inside gets too much, chill out on the largest patio in downtown Charlotte.” Connolly’s is easily one of the most popular downtown pubs, and centrally located even if not on a pub crawl.

EpiCentre (area A: stop 2)

BlackFinn American Saloon (marker 1)

“BlackFinn American Saloon is a modern day adaptation of a "big-city" saloon, with the welcoming charm and friendly faces found in the traditional neighborhood tavern of yesteryear.”  BlackFinn also has two floors, so feel free to check out both to find a spot to settle in with a drink.

Mortimer’s Pub (marker 5)

Even though the EpiCentre is a fairly new development to uptown Charlotte, Mortimer’s still manages to provide that old town pub feel. It actually sits on a cobblestone alley within EpiCentre that feels like it’s more hidden away from all the surrounding shops and restaurants.

That should be sufficient for a full night’s walking tour of some of the most notable pubs in uptown Charlotte. If you notice on the map, Alexander Michael’s aside, it’s more or less a big clockwise loop starting at the Convention Center, and ending just north of there at EpiCentre.

Now for a variation, I’d like to offer taking advantage of the SQL Sentry Shuttle and mention some locations that are well worth the trip.

The Shuttle Tour


From the Convention Center take the shuttle to stop 9, NoDa neighborhood center.

Revolution Pizza and Ale House (NoDa : stop 9, marker 33)

Basically a converted house on the main intersection of this eclectic neighborhood, Revolution has a large selection of craft beers on tap and in bottles from NC along with many of the most popular ones from other locales. The also offer a great food selection and plenty of outdoor seating.

Growlers Pourhouse (Noda: stop 9, marker 29)

As Greg mentions, “Voted one of "America's 100 best beer bars" the past two years running, Growlers has 14 rotating taps, including a refurbished 1936 beer engine for serving hand pulled cask ales. You will also not find a more beer-friendly menu in Charlotte.” 

Heist Brewing (NoDa: stop 9, marker 30)

The only actual brewery I’m including as it has the most convenient location to include in this crawl. That said, a brewery crawl in itself is a great idea. So many options! Anyway, Heist is also one of the recent additions to Charlotte’s craft brewing scene, and has quickly established itself, not only as a great brewery, but also a place for terrific food.

Now head back to shuttle stop 9 for a ride to the NC Music Factory, area B on the map.

Small Bar (NC Music Factory, stop 4, marker 15)

Small Bar actually was built in the space of an old loading dock in the NC Music Factory complex. It’s worth a stop simply for the novelty. It’s roughly 900 square feet, but they do have a large patio to go with it. They’ve mostly made their reputation on the novelty as well as very reasonable prices on drinks.

Now you can either hop back on the shuttle to stop 5 or take a short walk around the Music Factory complex to VBGB’s.

VBGB’s (NC Music Factory, stop 5, marker 17)

Compared to Small Bar, VBGB’s will seem very big. In fact, VBGB stands for “Very Big German Beer”. They have a great selection of craft beers on tap, a frost rail that runs along the entire bar, and a huge outdoor patio out back with all kinds of games and entertainment. While you’re there take a minute to admire the 40+ year old neon JFG Coffee sign which was preserved by Historic Charlotte.

Well I think I’ve covered quite a bit. As I mentioned, I could go on forever with all the options available, but I’ll stop here. If you have time after NC Music Factory, I’d definitely add stop 7, Brevard Court, on your way back to central uptown with all the options I listed there. That will certainly provide for a full evening’s entertainment.

Keep an eye on #SQLPubCrawl on twitter for more info and hopefully live updates throughout the Summit, and feel free to ask for any additional tips along the way. Cheers!


  1. Really appreciate this wonderful post that you have provided for us.Great site and a great topic as well i really get amazed to read this. Its really good. Get for more information late night food midtown

  2. It is important to seek hotel & hospitality research paper writing services and hotel & hospitality assignment writing services since students find help when they visit Hotel & Hospitality Writing Services.

  3. Hello to all, the contents existing at this web page are truly remarkable for
    people knowledge, well, keep up the good work fellows.온라인바둑이

  4. Hi, constantly i used to check blog posts here in the early hours in the daylight, as i love
    to gain knowledge of more and more.온라인카지노

  5. Wow i can say that this is another great article as expected of this blog.Bookmarked this site..온라인카지노

  6. I've proper selected to build a blog, which I hold been deficient to do for a during. Acknowledges for this inform, it's really serviceable!온라인카지노

  7. Through - how you can connect your mobile phone to Amazon Prime. Through, you can watch your favorite TV shows, series movies. You can watch prime videos anywhere on your device. Users need to create an Amazon account if they don’t have an Amazon account and enter the Amazon my TV activation code to watch Amazon prime videos on your device. |

  8. I want to start a blog to write about everything that happens at school and
    with friends…anonymously…any sugestions?.

    Try to check my blog: 휴게텔

  9. That is a really good tip especially to those fresh to the blogosphere.

    Simple but very accurate info... Many thanks for sharing this one.

    A must read post!

    my website: 카지노커뮤니티


  10. Nice Article. Very informative. I learned new information from your article, you are doing a great job.
    salesforce admin training

  11. I think this is a very good site and will continue to use it. Thank you for sharing.
    Ccsp Certification

  12. Nice article, thanks for sharing informative content. I like the content of the post.
    Salesforce Training

  13. such a Great blogger and your website is inspiration for me to start a blog. This article is very helpful for us.
    Aws course

  14. Thank you for sharing such good information. Very informative and effective post. Keep it up!
    cyber security course

  15. Thank you for sharing this post. I was also looking for a Assignment Writing Service when I landed on your post. I went to the website you mentioned, and it is absolutely stunning. I think it can help me with my Assignment Writing Service, but I will decide after visiting some other websites because I might get the best service at a cheaper price.

  16. This comment has been removed by the author.

  17. Great post, and great website. Thanks for the information! 백링크

  18. I think this is a really good article. You make this information interesting and engaging hire someone to write your essay. You give readers a lot to think about and I appreciate that kind of writing

  19. You have choose very good topic here that really useful for every visitor. I hope I will see more good news in coming future. Thanks.

  20. Your way of working is very great and cool. This article is very informative and helpful for a lot of people. Thanks for sharing and keep sharing.

  21. Definitely I got a very very attractive blog that really helpful for every one who is looking good knowledge. Thanks.

  22. Your blog is really great and cool post. it's really awesome and cool post. Its really awesome and good post. Thanks for sharing the nice and cool post. Thanks for sharing the nice and cool post.

  23. Gemini Exchange is a cryptocurrency trading service that combines an exchange, a fiduciary custodial service for digital means, and an advanced trading platform.
    uniswap exchange |
    uniswap exchange |
    gemini exchange |
    gemini exchange |
    log in att email |
    log in att email |
    coinbase exchange |
    uniswap exchange |

  24. Thank you for sharing this article with us. When I came across your post, I was also hunting for an Assignment Writing Service. I visited the webpage you described, and it is breathtaking. I believe it will assist me with my Masters dissertation proposal help, but I will determine after checking a few other websites to see if I can find a better service at a lower cost.

  25. Thanks for the great post you posted. I like the way you describe the unique content. The points you raise are valid and reasonable. I am a tech support expert telling you about.
    best cryptocurrency exchange|
    kraken exchange|
    uniswap exchange | exchange|

  26. Thanks for the great post you posted. I like the way you describe the unique content. The points you raise are valid and reasonable. I am a tech support expert telling you about.
    crypto wallet|
    exodus wallet|
    metamask wallet|
    trezor wallet|
    phantom wallet|


  27. The KuCoin exchange is a popular name in the crypto world. To buy coinbase pro login | vend cryptos on this exchange, you're asked to subscribe up for a new account. Losing access to your Coinbase account .cryptocurrency. At times, users create a kucoin login account and then do not use it for a long duration.But, the next time they try to log in, they seem to have forgotten the Coinbase login password.

  28. The world’s most trusted and safest crypto exchange platform that is known as login also cares for the issues that users commonly face.
    You can contact support login team via email, chat, and phone. The detailed processes are given below in the next sections.
    You can contact support by login sending an email. The official email address of can be found on the login page.
    You can chat with a login agent to get a proper solution for the issue that you are facing.
    This is the most convenient login way to contact login support.
    Make sure to follow the instructions login of the support agent carefully to fix the issues instantly.

  29. I am feeling very greatfull to go to here, thank you for you a lot for sharing the precious information
    exodus wallet |
    robinhood wallet |
    coinsmart login

  30. Crypto Exchange is one of the best platforms for you if you are looking for a place to invest in the overgrowing wave of online currencies. exchange | coinbase wallet | trust wallet |

  31. Thanks for the great post you posted. I like the way you describe the unique content. The points you raise are valid and reasonable. I am a tech support expert telling you about.
    robinhood wallet
    Robinhood Crypto Wallet
    MetaMask Login

  32. Cryptocurrencies have evolved and managed to leave a mark in the next chapter of the financial industry along with tech improvisations.
    binance us login |
    ledger wallet |
    kucoin login

  33. Cryptocurrencies have evolved and managed to leave a mark in the next chapter of the financial industry along with tech improvisations. It has been quite the journey for the digital currencies from no financial worth to hundreds of dollars’ worth. robinhood wallet | robinhood crypto wallet

  34. MetàMask Lògin is a cryptocurrency handbag which can be used on the Chrome, Firefox as well as Brave browsers. It’s likewise a browser extension. metamask login | metamask wallet | metamask extension |

  35. Finances in our world were given an online existence and backed with digital cryptography, it is now known as cryptocurrency. To make crypto easily accessible to the entire world, crypto exchange platforms came to life along with crypto wallets to provide a safe space for your crypto funds. login | Login |
    Coinbase Wallet

  36. This is one of the largest crypto exchanges that are being used by a lot of Americans to trade with digital currency. On the Coinbase login exchange, you cannot only trade with crypto but also store the purchased crypto by signing up for a Coinbase wallet. coinbase down | login | pancake swap

  37. Whether it's a problem with the writer or a problem with the payment provider, our representatives are here to help. You will learn everything you need to know to become a better writer in addition to producing the best argumentative essay to your professor. All students who want to enhance their writing skills can get individual help from our professionals. As a result, get in touch with us and take advantage of our premium services. We offer a responsive online paper help team that responds to all enquiries and concerns promptly.

  38. Binance is a cryptocurrency exchange that provides a platform for trading various cryptocurrencies. In addition, it provides a crypto wallet for its traders, where they can store their electronic funds.
    binance us login
    The exchange also has supporting programs that help traders make investment decisions. In addition, Binance has its blockchain-based token, Binance Coin. login

  39. Uniswap Exchange is an innovative exchange protocol built on Ethereum. It allows anyone with an Ethereum wallet to exchange tokens without the involvement of any central party. Kráken Ĺǒgiń : Bitcoin & Cryptocurrency. uniswap exchange Kraken Login | Sign In to Kraken. That is the reason crypto trade stages and crypto wallets have been advancing toward the spotlight so fast. Line through the characteristics that Kraken login. kraken login Gemini Login is a straightforward, beautiful, and safe platform for building your cryptocurrency portfolio. Gemini is a cryptocurrency exchange that allows consumers to invest their money in cryptocurrency trading. This exchange is one of the most popular for Bitcoin trading owing to its user-friendly and safe trading features. gemini login Available as a browser extension and as a mobile app, MetaMask equips you with a key vault, secure login, token wallet, and token exchange—everything you need to manage your digital assets. Explore blockchain apps. MetaMask provides the simplest yet most secure way to connect to blockchain-based applications. You are always in control when. metamask login

  40. Uphold is a cloud-based digital platform that provides financial services to users worldwide. It offers 58 cryptocurrencies, 27 fiat services, and four types of precious metals and enable the users to securely convert, hold, move and transact in various sectors.

    uphold Login |

  41. MetaMask allows its customers to access the wallet via its browser extension and mobile app. You can use the wallet on your mobile or computer or a separate device.
    MetaMask Login |
    MetaMask Login |
    uphold login

  42. If you have the details that you need to fill up your Uphold sign-up form then you need to jump to the next section to start the sign-up and login process.
    uphold login
    Kraken is considered one of the most preferred crypto exchanges for Bitcoin trading. Trading Bitcoin kraken is safer on this exchange.
    kraken login

  43. Excellent 'greenhouse'. Very adequate for my needs and comes with wonderfully clear instructions for assembly laptop outlet discount code Delighted with the purchase.

  44. Thanks for your kind review and happy shopping Cornwalls Cottages Discount Code. That is a great discount, hope you enjoy your purchase.

  45. Absolutely! There are Deliveroo promotion codes, best payroll service and offers accessible.

  46. You must also decide how long the Assignment will be and how you will continue with it. If you are not able to do this, then go for Assignment Help Qatar. Contact us our professional support team. we are available 24*7 hours.

  47. This exclusive Exodus walletfocused read is everything you’d need to understand the service along with steps to make transactions via your wallet accounts. You can read my blog with a click on the button above Exodus Crypto wallet Bitcoin wallet app | Bitcoin Wallet

  48. charges a fee for credit/debit card crypto purchases via its app. If you metamask sing in pay using a credit card, your card issuer may also charge a cash advance fee if you use it to buy cryptocurrency. app
    metamask sign in

  49. Gemini has opened up a shortlist for intrigued purchasers, who can get early admittance to the application, alongside the north of 10,000 individuals on Blockrize's shortlist. Gemini Credit Card
    On July 6, 2021, BlockFi, a crypto monetary administrations organization focused on supporting monetary consideration and expanding worldwide admittance to the crypto economy, sent off the world's first crypto rewards Mastercard, BlockFi Rewards Visa® Signature Card, determined to assist purchasers with acquiring openness to crypto markets and latently develop their riches. Blockfi Credit Card|

  50. Thanks for writing this quality informational content. I just want to thank you for taking the time to share with us. I get inspired by the writing skills of the writer. Thanks for sharing amazing pictures with us. Now it's time to get Appointment Setting for more information.