Norwegian and SAS have flights from Copenhagen to Aalborg, while Norwegian and other airlines also offers international direct flights from European cities. The airport is located north of the city. Take Bus no. 2, 22 (late night), 70, 71 and 200 or a taxi (approximately 170 Kr) to town. If you have little luggage and small budget, you can walk ~2km until the Lindholm train station. A extension of the railway is planned from Lindholm to Aalborg Airport and will be ready in a few years. It is also possible to walk by foot all the way from the Airport to the city, 6km, approximately 1 hour)
Bus or train to the center should be still available after midnight.
Aalborg Busterminal on John F Kennedy Plads (The John F Kennedy square, phone: 98 12 87 13) right by the station is a large regional hub for long distance, regional and local buses. Express buses (XBus) leaves several times per day towards Aarhus (via Hadsund), Rønbjerg, Nykøbing Mors, Løkken, Frederikshavn, Asaa, Holstebro, Viborg (via Silkeborg) and Esbjerg. In addition regional buses connects to nearly every city of some size in North-Eastern Jutland.
There are ferries from Norway/Sweden/UK coming to North Jutland (Hirtshals or Frederikshavn). From there you can take bus or train to Aalborg. Cruises visit Aalborg Waterfront often in the summer period.
From Frederikshavn: Use the E45 southbound to Aalborg.
From Hirtshals: Use the E39 southbound to Aalborg.
From Aarhus: Use the E45 northbound to Aalborg
In the center it's easy to walk by foot. To go further, there is a good public bus system and you can purchase a ticked from the bus driver; the standard tickets costs 20 Kr and allows you to travel within two zones (for example from city center (zone 1) to any other surrounding zone) within one hour. Taxis are very expensive.
The best way is still to get around by bicycle and you can rent one close to tourist information office. There is also a city bike scheme (doesn't work during the winter time, though) where you may borrow a bicycle from any of the 20 city bike stands shown on this map; you'll need to make a 20 Kr deposit to unlock the bicycle and you get the coin back when you return it to any of the bike stands. For longer stays, a better option is buying one. Police has auctions once per month, you can ask about them in the police station (the auction is held in Danish, so it's better to come with someone who speaks this language).
Nørresundby is north of the big bridge.
Aalborg Akvavit. Distillery.
Aalborg Castle (Aalborg Slot), Slotspladsen 1, . A castle that does not look like a castle.
Aalborg Tower, Søndre Skovvej 30.
Aalborg Townhall, Gammel Torv 2, ☎ +45 9931 3131. Built in 1759.
Aalborg Zoo, Mølleparkvej 63, . Cosy zoo with many "classic" zoo animals such as giraffes, elephants and big cats. The biggest enclosure is the savanna, where several African animals are free-ranging. There is also a big playground and a nice restaurant.
House of Music, Musikkens Plads 1, . Concert hall designed by the international well known CoopHimmelb(l)au. It wil be fully opened in March 2014
Elbjørn, (firstname.lastname@example.org), . Icebreaker now working as a restaurant and culture ship at the Aalborg harbour. It has a restaurant, a bar, glass workshop, and a museum.
Jens Bangs house (1623-1624)
Jens Bangs Stenhus, Østerågade 9. Beautiful renaissance house, built in 1624 by the merchant Jens Bang.
Jørgen Olufsens House, Østerågade 25. Well preserved renaissance house from 1616 by the merchant Jørgen Olufsen.
Lille Vildmose, (southeast of Aalborg and hard to reach by public transport). The largest raised bog in western europe, good wildlife exebition center with small cafe and restaurant and excellent bird watching.
Royal Taxhouse, Strandvejen 1. Built in 1902 representing national romantic architecture. In 2005, it was brought back to its original style. Next to the house is a musical fountain, during summer at noon, 3PM, 6PM and 9PM Händel's Water Music accompanise the splashing water.
Utzon Center, Slotspladsen 4, ☎ +45 7690 5000 (email@example.com), . Tu-Su 10AM-5PM. A cultural centre exhibiting art, architecture and design. Focuses on Jørgen Utzon's own work and other work somehow related to him. Also has a restaurant.60 Kr, seniors 40 Kr, students 20 Kr, children under 18 years free, group 40 Kr.
Aalborg Karnival, . The biggest carnival in Northern Europe. If you want to have fun with Danish people this is a great opportunity.
Bicycle. Rent a bicycle and go along the fjord.
Casino Aalborg, Ved Stranden 16, ☎ +45 9810 1550 (firstname.lastname@example.org, fax: +45 9933 7099), . Su–Th 8PM–3AM, F-Sa 8PM–AM. Offer American Roulette, Black Jack, Poker and slot machines. Nice experience, but the atmosphere here is not as chic and international as you might expect.50 Kr.
Egholm. Take a ferry to this small island in the fjord.
Ice-skating, C.W. Obels Square (behind the Student House).
Jumboland, Gøteborgvej 33, ☎ +45 9818 8843 (email@example.com), . M-Tu during holiday 10AM-6PM, W-Th, Su 10AM-6PM, F 10AM-7PM, Sa 9AM-7PM. Indoor playground of 2,400 sqm. Does also have a café.60 Kr, children 18 months-15 years 80 Kr.
Open Swimming Pool (Friluftsbad), Skydebanevej 14. Free.
Habour Bath (Havnebad), Jomfru Ane Parken. Free.
Cheapest supermarkets are Netto, Fakta, Aldi and Rema 1000. Working hours are 9-20 on weekdays and 8-17 on Saturdays. Aldi is open 10-16 on Sundays.
Algade and Bispensgade. Main shopping streets. Most shops close at 6PM M-F and 4PM Sa, Su shops are closed unless it is a special Sunday (usually first of the month).
Medinaen, Reberbansgade, Urbansgade, Holbergsgade and Jens Bangs Gade. Shopping area with a number of unique small shops.
Salling, Algade. Department store.
Wet Market, Aagade. Sa, We mornings.
There are several restaurants in Jomfru Ane street. In the city there are around 300 restaurants.
Fontænen: has the cheapest hot dogs in town, low budget fast food, what you need after a night out.
1000fryd: an alternative bar, vegan dinner on Tuesdays for 20dk. You have to sign up before.
KN Pizza & Kebab 2: a small pizza place known for its quality food, but it is not cheap actually quiet the opposite.
Friends: nice location toward the street junction and have the option to stay outside. A snack with salmon salad and mixed fruit cocktail juice costs ~90 Kr. Make sure to have the Kr currency on you, since they are not accept Euro.
Emiki Pizza: small pizza place & freindly staff I took vigge pizza with Coke for 45dk.
Utzon Restaurant : restaurant in Utzon Center. It serves "smørrebrød" in a new nordic way. Beautiful view at the waterfront.
Jomfru Ane street
The longest street bar in Scandinavia.
The Wharf. Borgergade 16, tel: 98117010 has the best beer in town (same owner as Charlies in Copenhagen).
The Irish House. Østerågade 25, tel: 98141817, 
London Pub. Boulevarden 7, tel: 98117770.
Jomfru Ane Gade is a short street with 30 restaurants/bars. Drinks are cheap and the bars are open late. You will see signs advertising 10 Kr drinks and 10pm - 12pm happy hour.
1000fryd: Kattesundet 10, tel: 98132221, is Aalborg's only bar run by activists. 1000fryd has been around since 1984 when Aalborg's alternative scene bought the place. Now the place is known for their ecological beer, underground music scene and D.I.Y attitude towards life. 1000fryd has two reoccurring festivals, namely their Punk/HC festival and their Queer festival. 
Student house [www.studenterhuset.dk] right across the Budolfi church hosts international evenings on wednesdays, as well as various concerts on Fridays. Very informal.
Behag din smag, Maren Turis Gade 5, ☎ +45 8734 0486, . M-F 9AM-6PM, Sa 9:30AM-4:30PM. Coffee, tea and chocolate. If you enjoy good coffee, then this is the spot. One of the owners was the Danish Barista champion of 2007.
Aalborg is also the home of De Danske Spritfabrikker which produces a great number of distilled beverages. Their most famous product is the Aalborg Taffel Akvavit, colloquially known as a "Rød Aalborg" (Red Aalborg).
Eyvind Andreasen B&B Kronprinsens alle 34, tel: +45 98172562, email:firstname.lastname@example.org. Friendly place just north of the bridge. Has three rooms sharing bathroom, kitchen, separate entrance. TV, beer and wine available in the kitchen at very reasonable prices. 270 Kr, 325 Kr (double).
Scheelsminde Hotel & Gastronomi Scheelsmindevej 35 - DK-9100 Aalborg, tel: +45 98 18 32 33 - Fax +45 98 18 33 34 -email:email@example.com. A nice 4 star hotel-restaurant mostly for business people.
Radisson SAS Limfjord Hotel Ved Stranden 14-16 - DK-9000 Aalborg, til: +45 98 16 43 33 - Fax +45 98 16 17 47 - email: firstname.lastname@example.org. Big 4-star hotel with a view towards the Limfjord. Prices from 1200 - 2000 Kr per night.
Danhostel Aalborg, Skydebanevej 50 - DK-9000 Aalborg. A hostel outside the centre of Aalborg which contains some huts on an island. It is cheap to sleep at this hostel and the ferry to Egholm is not far from it.
Aalborg Bibliotekerne, Head Libary (library) [aalborgbibliotekerne.dk], Rendsburggade 2, section Nørregadehjørnet.
Baresso (coffee shops) [baresso.dk], at Nytorv and Bredgade Torv.
There are lots of beautiful nature around, easily accessible only by car.
Rubjerg Knude - impressing sand dunes and a half-sunken lighthouse in the sand. Hard to reach during the weekend, since there are no buses during that time.
For beach, you can take a bus to Blokhus or Løkken (North Sea, around 40km) or Hals (Baltic sea, around 30km) and walk some 3km north, or take a less frequent bus that passes Hou, to, e.g., Bisnap strand (Baltic sea). The North sea is more windy most of the time, and there are nice sand dunes there. There are German bunkers from World War II near to Løkken, and they can be also interesting to see.
Fårup Sommerland. This amusement park can be reached by bus from Aalborg Rutebilstation. The amusement park has many rides and a water park.
This is a usable article. It has information for getting in as well as some complete entries for restaurants and hotels. An adventurous person could use this article, but please plunge forward and help it grow!