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.

DINING-ROOM-1024x682

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

Zapato

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

trolley[16]

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!

59 comments:

  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

    ReplyDelete
  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.

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

    ReplyDelete
  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.온라인카지노

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

    ReplyDelete
  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!온라인카지노

    ReplyDelete
  7. Through www.amazon.com/mytv - how you can connect your mobile phone to Amazon Prime. Through amazon.com/mytv, 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.

    amazon.com/mytv | www.amazon.com/mytv

    ReplyDelete
  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: 휴게텔
    (jk)


    ReplyDelete
  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: 카지노커뮤니티



    (IVY)


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

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

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

    ReplyDelete
  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

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

    ReplyDelete
  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.

    ReplyDelete
  16. This comment has been removed by the author.

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

    ReplyDelete
  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

    ReplyDelete
  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.
    고스톱

    ReplyDelete
  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.
    스포츠토토

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

    ReplyDelete
  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.
    토토사이트

    ReplyDelete
  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 |

    ReplyDelete
  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.

    ReplyDelete
  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 |
    crypto.com exchange|

    ReplyDelete
  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|

    ReplyDelete

  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.

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

    ReplyDelete
  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

    ReplyDelete
  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. crypto.com exchange | coinbase wallet | trust wallet |

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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 |

    ReplyDelete
  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.
    Coinbase.com login |
    Pro.coinbase.com Login |
    Coinbase Wallet

    ReplyDelete
  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 | crypto.com login | pancake swap

    ReplyDelete
  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.

    ReplyDelete
  38. Crypto.com log in account on Apple devices. You can easily access the Crypto.com account on your iOS devices by getting its mobile application from the App Store. Once you get the mobile app, you will be able to log in to your Crypto.
    crypto.com exchange|
    crypto.com login|
    crypto.com login

    ReplyDelete
  39. 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.
    binance.com login

    ReplyDelete
  40. 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

    ReplyDelete
  41. 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 |

    ReplyDelete
  42. The Metamask login account was created out of the need to create more secure and usable Ethereum-based websites. To be specific, it clearly handles account management and connects the user to the Binance blockchain. It clearly supports the Chrome, Brave along with the Safari browsers.
    metamask |

    Gemini is a popular cryptocurrency exchange platform that helps you to buy Bitcoin, Ether, and other cryptocurrencies easily and securely. On this platform, there are several cryptocurrencies available like Bitcoin, Ether, Cardano, Dogecoin, XRP, Polkadot, and so on.
    gemini |

    MetaMask login is one of the most popular and trending web browser extensions that are used in storing Ethereum and ERC-20 tokens.. MetaMask is free of cost and a secure way to invest in cryptocurrency.MataMask operates on the concept of blockchain where you can uniquely record and transfer information into the network in a secure way.
    metamask login |

    ReplyDelete
  43. 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

    ReplyDelete
  44. Uphold login, then read the full article and follow all the steps. However, if after performing all the steps you’re not able to log in then visit the official website of Uphold for better assistance. uphold login
    MetaMask login is free of cost and a secure way to invest in cryptocurrency. metamask login
    metamask login available on your web browser, but please make sure that you keep your backup phrase safe with you and never disclose this to anyone. metamask login

    ReplyDelete
  45. 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

    ReplyDelete
  46. MetaMásk Login is your portal to the decentralized web, and knowing how to plan and prepare for it is crucial if you want to take full use of the platform's capabilities.
    metamask login
    Phantom Wállet: A friendly Solana wallet built for DeFi & NFTs Phantom is a non-custodial blockchain wallet for accessing decentralized applications on the Solana blockchain.
    Phantom wallet
    The Phantom wallet currently supports the following currencies: USDT, USDC Raydium (RAY), SRM (SRM), and every utility token launched with Solana’s DApps.
    Phantom wallet

    ReplyDelete

  47. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our.
    Exodus Wallet | Kucoin Login | Exodus Wallet

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

    ReplyDelete
  49. Get an official support of ij.start.canon and ij.start.cannon on our website. Here you will get a secure and easy platform to download canon setup.

    ReplyDelete
  50. Phantom Wallet It is famously named as the factor that bridges the gap between the Solana blockchain network and the crypto users. Currently, the wallet functions as a simple web browser extension but there are rumors of ongoing operations to soon launch a mobile application. Let’s not delay and get into the good part of this information guide.
    Phantom Wallet
    MetaMask Wallet
    Metamask Extension
    Metamask Log in

    ReplyDelete
  51. 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.
    huobi exchange| Coincheck exchange |lbank exchange

    ReplyDelete
  52. Coinbase Exchange helps institutional clients access one of the deepest pools of liquidity of any regulated crypto spot exchange.
    Coinbase Exchange | Coincheck exchange

    ReplyDelete
  53. Paxful is a peer-to-peer cryptocurrency exchange and digital wallet provider. Customers can buy and sell cryptos using 350+ payment methods. Our Paxful review will cover how to open a Paxful wallet, the account login process, minimum deposit requirements, sending fees, and more. Find out whether to start buying and trading Bitcoin at Paxful.
    paxful login
    In a shocking occurrence, a couple of years earlier the now-outdated Mt. Gox, which was correspondingly domiciled in Japan, experienced a hack in which 850,000 in bitcoin worth countless dollars was taken, driving the trade to seek financial protection. Coincheck stays dissolvable however the degree of the monetary harm still can't seem not entirely set in stone.
    Coincheck Exchange
    Over time, Spookyswap's exhibition has been consistently developing. Today, Spookyswap's cost has expanded by 31.18% and is exchanging at the cost of $32.31. The CyberFi group has seen the Fantom Opera organization's fast development and is presently teaming up with SpookySwap, the Fantom organization's most dynamic decentralized trade (DEX).
    spookyswap

    ReplyDelete
  54. Established in San Francisco in 2012, Coinbase is one of the biggest and most conspicuous computerized cash trades on the planet, and is many times the main port of call for cryptographic money rookies, because of its convenience and openness.
    Pro.coinbase.com Login
    One of the most well known Ethereum wallets is MetaMask. Clients might send bitcoin in standard exchanges and draw in with various decentralized applications utilizing this internet browser module. MetaMask is an Ethereum wallet that overcomes any barrier between Web3 UIs (like Mist programs and DApps) and regular web interfaces (for instance, Google Chrome, Mozilla Firefox, sites).
    Metamask Sign in

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

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

    ReplyDelete