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!

48 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. Hello to all, the contents existing at this web page are truly remarkable for
    people knowledge, well, keep up the good work fellows.온라인바둑이

    ReplyDelete
  3. 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
  4. Wow i can say that this is another great article as expected of this blog.Bookmarked this site..온라인카지노

    ReplyDelete
  5. 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
  6. 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
  7. 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
  8. 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
  9. This comment has been removed by the author.

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

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. Excellent 'greenhouse'. Very adequate for my needs and comes with wonderfully clear instructions for assembly laptop outlet discount code Delighted with the purchase.

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

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

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

    ReplyDelete
  23. Crypto.com 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.
    crypto.com app
    metamask sign in

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

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

    ReplyDelete
  26. Great Blog
    Looking for reliable and efficient Homework Help UK? Look no further than Diploma Assignment Help UK! Our team of experienced tutors and experts provides top-quality assistance for all your academic needs. We offer Homework Help online in the UK, making it easy and convenient for you to get the help you need, wherever you are. With our personalized approach and affordable prices, you can trust us to deliver the results you need to succeed.

    ReplyDelete
  27. nice blog

    If you are looking for someone to write your assignment in Ireland, consider hiring an experienced and professional assignment helper from a reputable writing service. With their expertise and knowledge, they can deliver high-quality assignments that meet your academic requirements and deadlines. Don't hesitate to reach out to a trusted assignment writing service in Ireland for assistance.



    ReplyDelete
  28. Best Institutes Offering Digital Marketing Course in Vaishali Nagar, Jaipur - With a range of options available, it's important to choose an institute that offers comprehensive digital marketing training, practical learning, and industry exposure to students.

    ReplyDelete
  29. This is a very interesting and informative post. I really like how you presented the information. It has a great flow and is simple to understand. I believe that having access to this information will be beneficial to a large number of people. I also like how you used visuals to illustrate your points. They are extremely beneficial and aid in comprehending the concept. Overall, this is an excellent post that I am glad I found. Thank you for your contribution. keep posting.
    playa de virginia manual de divorcio sin oposición

    ReplyDelete

  30. Break language barriers and connect with Thai-speaking audiences effortlessly. Our team of expert translators ensures accurate and culturally sensitive translations that resonate with your target market.Experience seamless communication and unlock new business opportunities today. Don't miss out on reaching your Thai audience! Visit here Thai Translation Services Malaysia

    ReplyDelete
  31. I recently collaborated with an app design and development company, and I'm thoroughly impressed with their comprehensive approach, from design to development. Their expertise and professionalism made the entire process seamless. Highly recommended!

    ReplyDelete
  32. As of September 2021, there is no specific information about "steve.blogs.sqlsentry" or its associated reviews. SQL Sentry is a software product used for SQL Server performance monitoring and optimization, but "steve.blogs.sqlsentry" appears to be a specific blog or content related to this software. To find reviews or information about SQL Sentry, one can perform an online search using the term "steve.blogs.sqlsentry reviews" or "SQL Sentry software reviews." If the blog is a specific content creator, one can contact them directly through their blog's contact information or social media profiles. Visit the official website of SQL Sentry or the company behind the software to find customer testimonials, case studies, or resources related to the software's performance and reviews. Explore online SQL Server communities, forums, or user groups where users discuss their experiences with the software. Check social media platforms like Twitter, LinkedIn, or Facebook for mentions of "steve.blogs.sqlsentry" or "sqlsentry." If you are part of online communities or forums related to SQL Server or database management, ask fellow members if they are familiar with "steve.blogs.sqlsentry" or have any opinions or reviews to share.Abogado de Accidentes Camiones VA

    ReplyDelete
  33. Hats off to you for crafting such a remarkable blog. Your dedication to quality content is evident in every post, enriching readers like me.New Jersey Domestic Violence Defense Lawyer

    ReplyDelete
  34. The "PASS Summiteers Guide to SQL Pub Crawls" could benefit from a more detailed introduction, focusing on its purpose and intended audience. It should provide responsible drinking guidelines, prioritizing safety and moderation. Including maps, addresses, or links to featured pubs and bars can make it easier for attendees to plan their evenings. Additionally, a section should highlight special events, promotions, or discounts at each pub to enhance the overall experience. Finally, quotes or anecdotes from previous PASS Summit attendees can add authenticity and excitement to the guide.División de Propiedad de Divorcio de Nueva York

    ReplyDelete
  35. Steve.Blogs.SQLSentry is an informative and insightful blog authored by Steve Wright, covering a range of topics related to SQL Server and database management. With expertise and experience in the field, Steve shares valuable insights, tips, and solutions to help readers navigate the complex world of SQL and database technology.
    Abogado DUI Rockingham VA

    ReplyDelete
  36. embroidery digitizing software said...
    Embarking on a SQL Pub Crawl at PASS Summit is not just a journey through databases but a vibrant exploration of camaraderie and shared knowledge. The PASS Summiters Guide to SQL Pub Crawls is an immersive experience, where data enthusiasts connect over drinks, exchanging insights that go beyond the conference halls. It's a unique blend of learning and networking, turning SQL discussions into memorable connections. Cheers to an unforgettable SQL adventure!

    ReplyDelete
  37. Get the legal advice for DWI charges from a skilled attorney. Manassas DWI Lawyer VA

    ReplyDelete
  38. That is really informative and also if you wan more information Best Vacuum Cleaner For Computers

    ReplyDelete
  39. Our legal team has a successful track record and focuses on complex federal cases. In order to defend your rights, we offer strong and tactical representation. Put your trust in a federal criminal defence lawyer in Virginia who has the expertise needed to handle your case with commitment and superior legal acumen.Abogado Criminal Federal de Virginia

    ReplyDelete
  40. The PASS Summiteers Guide to SQL Pub Crawls is a comprehensive guide for database enthusiasts, guiding them through SQL-themed pubs, offering a blend of networking and knowledge, ensuring a memorable and educational night out. Stipulation of Settlement Divorce New York

    ReplyDelete
  41. The PASS Summiteer's Guide to SQL Pub Crawls is an indispensable companion for SQL professionals seeking a perfect blend of networking and relaxation. This curated guide navigates through the vibrant world of SQL-themed pub crawls, offering a spirited itinerary for PASS Summit attendees.
    divorce center new york ny

    ReplyDelete
  42. Seeking bankruptcy assistance? bankrupsy lawyers near me Find experienced bankruptcy lawyers near you who can guide you through the process, assess your options, bankrupsy lawyers near me and provide legal support for a smoother financial recovery.

    ReplyDelete
  43. Good job! Thanks for sharing wonderful information with us. Traffic Ticket Lawyer Fairfax VA

    ReplyDelete

  44. "Pass Summiteers' Guide to SQL Pub Crawls" likely refers to a humorous or informative document providing tips and suggestions for navigating pub crawls during the Pass Summit, an annual conference for SQL Server professionals. It may offer recommendations on pub locations, drink specials, networking opportunities, and responsible alcohol consumption, catering to attendees seeking social interactions outside of the conference sessions.
    dui lawyer fairfax va
    tax and estate lawyer
    henrico traffic lawyer
    virginia uncontested divorce

    ReplyDelete