Arrive on Friday night, preferably at city airport and head east to Brick lane for a curry. After dinner have drinks at the Vibe bar or 93 feet east. If you are feeling super energetic see what is going on at Sosho, Cargo or Electricity showrooms before getting a good night of sleep.

Saturday morning, get up early and have breakfast at Patisserie Valerie in Knightsbridge. Have a wander around Harrods for an hour or two making sure that you check out the food hall. Jump on the tube and head over to Camden. You may enjoy the market – I don’t – but if the chaos isn’t for you get off at Chalk Farm station rather than Camden to avoid it all. Grab lunch at Thanh Binh one of the best cheap Vietnamese restaurants in London, I recommend the Pho.

After lunch, walk to the top of Primrose hill for one of the best views of the whole city. On the way back to the tube, stop for a pint or two outside The engineer or The queens.

I’d suggest a rest at this point so you can make the most of your evening. For dinner book Latium and have cocktails before/after at the Sanderson.

You are on your own for the evening. I don’t really do clubbing any more, but the one piece of advice I give is don’t just wander to Leicester square and choose a venue, there are some absolute hovels. If you are just after a few more drinks after dinner I like the bar at the Charlotte street hotel.

Sunday morning, make sure you enjoy a full English breakfast to start your day. Your hotel probably serves one and to be honest there isn’t any particular culinary skill involved in making one so it is hardly worth hunting down an ‘authentic greasy spoon’ cafe.

Get a tube to Westminster and walk over the bridge enjoying the uber tourist views of Big ben and the houses of parliament. Get a boat from Waterloo pier next to the London eye to Bankside pier, browse Tate modern for a while then cross the river using the millennium foot bridge, head up to St. Pauls Cathedral and check out thewhispering gallery.

Make sure you use the Thames Clippers commuter boats. The tourist boats are over priced and very slow.

Back on the boat to Greenwich, from Blackfriars pier. Walk through the grounds of the naval college and into the park, up to the observatory for another view over London. If you have time check out the three markets in Greenwich.

Finish your trip with a late Sunday roast and a beer at the Plume of feathers (you’ll need to book a sitting at 2 or 4pm). Get on the DLR and head back to city airport!

That is just one of many ways of spending a weekend in London. I missed out Fish and Chips, some great markets and many of my favourite pubs simply because of time constraints. I also tried to leave plenty of spare time between my recommendations so you can wander off the beaten track and discover your own London – in my experience, just wandering is one of the true joys of travel.

My final tip, here is what  to avoid. Leicester Square, Theatre Land, The London eye, Buckingham palace. Some Londoners may passionately disagree, but I think you’d be wasting valuable time.

So, if you are reading this and thinking of visiting, enjoy my city. Arguably the greatest on earth.


Creating a Simple WCF application

After looking around and playing with WCF for a while, it had come to my notice that all the examples that I could find were over complex, then I came across Ralf’s Sudelbücher blog entry for “A truely simple example to get started with WCF“, so simple, so to help you along here is the C# source code that I have written, with a few additions in that the solution also has a client console that calls the WCF application to show a true sence of what is happening. (21.68 kb)

SQL 2008 Activity Monitor

Okay, where has the Activity Monitor gone in Microsoft SQL Server Management Studio 2008?

  1. Open Microsoft SQL Server Management Studio.  
  2. In Object Explorer, right click on the server and select Activity Monitor.  Please note that the Activity Monitor is not available in the context menu unless you select the server.  You cannot launch the Activity Monitor when you select a database, another folder, etc. 
Why did Microsoft move this, I don’t know

Visual Basic auto compiler

Working hard with VB.Net, hard work, as I find C# much cleaner, but VB.NET does have the advantage of be able to edit code while debugging.  And it compiles while you are working, but I have found that with 64 projects in my solution that the automatic compiler sometimes, quite a lot of the times hogs the machines resources, it would be nice to be able to turn the auto compiler off.

Viewing the SQL that is generated from LINQ to SQL

There comes a time when you are using LINQ to SQL that you just have to find out what SQL is being generated, for what ever reason that is, here a a few ways to get the SQL you are looking for:

You can use SQL Server Profile to see the traffic going to and from the database

But if you are like me you want more control over your processes, so you can use the DataContext.Log, and output the log to a window, or in the case below the console window

One last method is to just write out an objects SQL, using the GetCommand, as seen below