A friend of ours on the SQL Server doc team asked me to recommend some places to visit for their upcoming trip to Scotland so instead of dashing off a long list in email I thought I'd do it as a blog post so others can benefit too.

I'm going to concentrate on the areas I know well, which are the West Coast, Skye, and the North West of Scotland. Links are mostly to Wikipedia. I hope you find it useful – it's a bit of a brain dump of historical places, good scenery, and good drives - and I'm going to do it over multiple posts.

Also check out the photos I posted when I first took Kimberly to Scotland in 2009: Photos and stories from our Scotland trip - spot the photo I took that became my Twitter avatar…

And check out Kimberly's post about that trip: Scotland is amazingly beautiful but, ah, the weather IS worse than Seattle!

Before planning a trip check out the websites of the National Trust for Scotland and Scottish National Heritage to see what historic properties are near where you're going.

You can get part 2 (about the Isle of Skye) here and part 3 (about driving trips in the west and north west) here.

Part 1: Edinburgh, Glasgow, Stirling

First off you need to visit Glasgow, Edinburgh, and Stirling. I went to high school (Glasgow Academy) in Glasgow for six years, living 22 miles north in Helensburgh, by the large Royal Navy submarine base at Faslane where my father was based for many years. I went to the University of Edinburgh (majored in Computer Science and Electronics) and lived there for 8 years, and lived close to Stirling for a few years too – so I know all three cities extremely well. I think Edinburgh is definitely my favorite of the three, which is why I have more to recommend there. You can easily spend a week on these three cities alone, or a week just in Edinburgh.

Edinburgh

Places to visit: Edinburgh Castle (try to be there at 1pm when they fire the artillery gun), Holyrood Palace, drive through Holyrood Park (for the adventurous, I strongly recommend climbing Arthur's Seat for awesome views over the city and off to the famous Forth Rail Bridge). Try to be there at the time of the Edinburgh Festival in August and take in the Edinburgh Military Tattoo in the grounds of the castle (book in advance – it's sold out completely for every show over the last ten years – I used to have a student apartment one summer in the early '90s where we could see it every night). The Scottish National Gallery has an excellent collection of artwork and the National Museum of Scotland is very cool, including a bunch of the famous Lewis Chessmen. Lots of excellent restaurants – I strongly recommend The Witchery on the Royal Mile. Literally hundreds of excellent pubs – way too many to name – but check out Greyfriar's Bobby, Rose St Brewery, and anything down in the Grassmarket. I've only stayed in one hotel in Edinburgh – The Glass House – very cool boutique hotel. Oh, and also check out St Giles Cathedral on the Royal Mile too (although I'm not religous at all I love ecclesiastical architecture!). Make sure to do one of the cool spooky tours – underground or a ghost tour.

I also recommend taking a drive up the coast of Fife, checking out St Andrews (where my sister lives – awesome old city), Falkland Palace, and Hopetoun House. Check out the movies Restless Natives and Trainspotting (one of my top-5 – beware, not for the faint-hearted, like any of Irving Welsh's awesome books).

It's only an hour by train or road (via the M8) to Glasgow… I used to do it every day during the summer months between university years when I still lived in Edinburgh and worked for British Telecom at their Glasgow software engineering center (they sponsored me through university – thanks BT!).

Glasgow

Glasgow is a very different place from Edinburgh – it will always kind of feel like where I grew up as I went to school here from the ages of 11 to 18 (taking the train every day from home). There's huge rivalry between the two cities as well.

I don't know any of the hotels in Glasgow I'm afraid, but there are loads of good restaurants and pubs. I recommend any of the Sarti restaurants, The Italian Kitchen, the Ashoka in Ashton Lane, and my absolute favorite: The Ubiquitous Chip (also in Ashton Lane). Ashton Lane is in the 'West End', near Byres Road where there are lots of great pubs. It's also near the utterly fabulous Kelvingrove Art Gallery and Museum – a giant museum with incredible exhibits. Easily a day just for that. Also check out the nearby, and equally excellent, Riverside Museum of Transport and Travel. Both of these are near Kelvingrove Park, through which I used to walk to school in my final year of high school. You should also try to make it out to the Burrell Collection, another excellent museum.

Glasgow's a lot more industrial than Edinburgh and has less historical buildings. Kind of in a triangle between the two to the north is Stirling, easily accessible by road or train…

Stirling

For the last few years when I worked at DEC I lived in a charming, small village in Stirlingshire called Kippen, about forty miles from the DEC offices in Livingston (a 'new town' with nothing really interesting at all, except the original Livingston which is now called Livingston Village). Stirlingshire has excellent rolling countryside and is really at the south end of the highlands of Scotland.

Stirling is a really ancient place, dating from the Stone Age. First off you must visit Stirling Castle, which sits on an imposing 'crag and tail' rock formation just like Edinburgh Castle – that could be a day itself. Also check out the Wallace Monument, which commemorates Sir William Wallace (think Braveheart) and has his sword on display. Again, lots of good restaurants and bars – none that spring to mind as essential visits though. The only hotel I've stayed in nearby is Airth Castle Hotel – try to get a turret room – very cool. Try to walk around the Old Town of Stirling (down from the castle basically) to see lots of other historic buildings.

Nearby is Blair Drummond Safari Park. I'm not a big fan of zoos but if you're traveling with kids then this will earn you points with them. Bridge of Allan is also worth checking out, as is Doune Castle.

End of part one…