Monday, May 03, 2010
Tuesday, April 20, 2010
Windows Azure Pricing Calculator Spreadsheet
I’ve mentioned this at a heap of sessions I’ve presented at and have never managed to get around to posting it.
So. Attached is my Windows Azure Pricing spreadsheet.
Pretty simple. has three worksheets.
- A simple Table storage calculator that determines the cost of table storage.
This includes overhead calculation – i.e. what is the ration of name to value in your name/value pairs
It also checks your key lengths fall within the 260 char URI limit and a few other things.
- A model of session state pricing.
Basically shows that SQL Azure will typically be a cheaper option for Session state storage (or anything with little data on disk and high read/write counts).
- A detailed (very detailed) model of PhluffyPhotos.
For more detail please see my MIX10 session on Storage in Windows Azure Platform
Windows Azure|Tuesday, April 20, 2010 9:06:10 PM UTC||
Thursday, January 07, 2010
Chris and Dave do Denniston
Denniston is a former coal mining area situated on an alpine plateau about 30km North of Westport on the West Coast of New Zealand (Wikipedia here). It was actually an active mining area right up until the 1960’s. In recent years it has fallen under the ambit of the Department of Conservation. Along with the Buller Cycling club they have been building out a bunch of Mountain Bike tracks around the area.
You can pull details on the cycling area from the DoC site and from the Buller Cycling club.
Dave and I decided we’d try and visit the tracks as part of our summer South Island road trip. We drove in via Murchison as we did some paddling along the way. We had a couple of days in the Murchison region where the water levels were well up. Paddled a few runs that I’ve done before as well as a new run down the mangles that started with about a 2m waterfall- pulled quite a crowd when we ran that one for some reason… didn’t seem that difficult.
We drove into Westport the evening before we planned to ride and found ourselves a nice motel (Buller Bridge Motel) with free WiFi. Got up early and headed up the hill. This place really is quite the plateau. The hill rises steeply off the ocean almost to an altitude of about 650m at the carpark. The views were pretty good for us; on a really fine and still day I can imagine you’d be able to see all the way up to Karamea.
Once we got to the top we had a bit of a potter around looking at some of the old mining ruins. Denniston is famous for the Denniston Incline which is a frighteningly steep, two pitch, coal railway that literally goes straight up the side of the hill. Check out this video from the NZ Archives for an idea of what it was like.
Then we headed up the hill to the Museum Car park which is the designated starting place for the Mountain Biking trails. While getting organized we saw the Google Car driving around- yes, even in the middle of bloody nowhere there is Google!
We started out with the Ropers Hotel Circuit.
Straight away the riding was quite different to anything we’d ridden before in New Zealand. Lots of slick rock and ledges. Was quite fast riding and reasonably hard on the suspension. A 6” trail bike is ideal- we had a Trance and a Mojo. The last part of this track before it hits the road is walking only- for ecological reasons rather than ride-ability. You definitely want to do this track in the predominant direction indicated on the map as it would be a pain to walk up that hill.
Next we rode out on one of the longer trails. This was nominally on 4WD track but I’d challenge most people to take their 4WD there and get it back in one piece. The track was Sullivans Circuit and it went off the other side of the Plateau back down towards Westport.
This track had plenty of challenging riding. Lots of large rocks and ledges. it was all too easy to go far faster than 0.1mm of lycra really should justify.
Finally we rode the Miners and Drill track circuits. Again, lots of hairy riding with a bunch of sketchy single track, some of which we both had to walk.
There was still plenty of sign of the old coal mining stuff and indeed the coal itself.
Despite only doing about 30km (in 3.15hr!) we were in need of a beer once we got back to the car.
Here’s the GPS dump
And the full TCX file of my Garmin 310XT is here:
Adventure Sports | Gettin Fit|Thursday, January 07, 2010 5:42:29 PM UTC||
Friday, January 01, 2010
Interesting Stats from 2009
Thought it would be interesting to do a blog post of my stats for 2009.
It was a pretty hellish year for travel. It’s the first full year that I’ve used TripIt which has proved to be a really useful tool. TripIt also provides travel stats.
Now not all of this was work travel (I had a couple of overseas holidays) but it was still a pretty full on year.
This is borne out in my exercise stats. Obviously my most exercised location was Wellington, but, I also did a whole heap in Issaquah, Washington and also in Bangalore, India.
I remained pretty steady over the course of the year in terms of the amount of exercise I did. It was still really hard to maintain anything approaching a good training program though.
Once again it was a shitty year for me skiing wise, though these stats do miss out a bit of skiing I had in January. I also did far less mountain biking than I would have liked to.
I did do over 300hr of exercise over the year and travelled 2700km. I also burned 65,000 calories.
Will be interesting to see what I can manage this year.
Adventure Sports | Gettin Fit|Friday, January 01, 2010 3:42:44 AM UTC||
Wednesday, October 21, 2009
Monday, October 19, 2009
My Hopeless Gym Experience at the Mandalay Bay Spa
So… I genuinely object to paying US$20/day to use the hotel gym. But, needs must sometimes and so it was that I found myself at the Mandalay Bay Spa $20 the poorer this morning. Been working reasonably hard in the build up to the K1 road race in a couple of weeks so needed to get some time in on the stationary trainer.
Well, what an utterly useless experience that was. I got inside the Gym to find that;
- They had two consumer grade exercycles and that was it as far as bikes went.
- None of the cardio equipment was available anyway
So even if I had been able to get on the equipment it wouldn’t have been much good for the Interval workout I had planned- I ripped the crank off a consumer grade exercycle in Bangalore this year so it’s just downright dangerous.
In the end I threw my toys out of the cot, got myself a refund of my fees and went for a run up the strip.
Think I’ll try and find someone friendly at the Luxor for the Gym tomorrow and will not be staying at the Mandalay Bay for MIX10 next year that’s for sure.
Gettin Fit | SPC09 | Travel|Monday, October 19, 2009 2:43:18 PM UTC||
Tuesday, September 22, 2009
Smashed a new PB on my hill repeat ride
Got out for hills this morning on the road bike. Turned into a shorter ride, but, I pushed the 2nd interval really hard (100% MHR) and in doing so smashed about 7% off my PB up the short pinch climb I do.
The average power was 450 Watts over the 4min 31 seconds. Pity the hill wasn’t a touch longer as it meant my new PB 5 minute power ended up being only 431 Watts i.e. 30 seconds of my rest break at the top was included.. Goal for the next few weeks is to really work on lifting my power profile. I think I’ll probably look at doing Peak 1’w and 5’w on Happy Valley road as it certainly appears to help going up a hill. At the moment my 1’w isn’t even on the chart and I’d like to work on getting my entire profile into the Cat 4 region over the next few weeks in the lead up to the K1 race. Means I need to be targeting 350 Watts for 60 minutes which I think is going to be the hardest bit.
The other interesting thing is to see just how much temperature variation affects my (supposedly temperature compensating) barometric altimeter on the Polar s625x. All 5 of those intervals should be the same height, but, there is a definite trend downward over the set.
Adventure Sports | Gettin Fit|Tuesday, September 22, 2009 8:16:12 PM UTC||
Thursday, September 03, 2009
Essential Tools for SQL Azure Development
Much like Wade Wegner I think that SQL Azure is the jewel in the cloud for Microsoft. None of the other vendors have anything like it. While it can be a bit sticker-shock-ish given that nominally a gig in SQL Azure is 65 times the price of a gig in Azure storage, once you actually run some real world scenario models it turns out to be really well priced. Think of a SQL Azure instance not as 1GB (or 10GB… but I see no reason to use 10GB partitions) of storage but rather as the cheapest damn fully backed up and HA relational database solution you’ll find anywhere- and yes FOSSers I include your stuff in that calculation; no greasy haired, under washed and over WoWed engineers needed here.
Anyway… I digress.
A major PITA in using SQL Azure is that the tooling is tantalizingly close to be OK… but in many ways it just doesn’t work. Dumping a SQL script and then re-creating the DB in SQL Azure is a painful exercise in find and replace- check out the hands on lab on Migrating a DB to the cloud in the Azure training kit for the gory details…
Wade has a blog post up about a freebie tool written by George Huey that automates this process for you. Essential for your Azure kit bag. It will parse out all the unsupported stuff.
I ran it up and gave it a nice brutal challenge…. the AdventureWorksLT script that’s used in the aforementioned lab. This includes both schema and data and is a decent effort to parse. The tool churned for a good 3 or 4 minutes…. but I got a script out! The original script includes some real curve-balls like XML Indexes and some tables with data to populate but no clustered index (SQL Azure needs a clustered index before you can insert into a table). I don’t expect it’ll get everything right., but, let’s take a look at how it does against my hand crafted script…..
It doesn’t support cut and paste or saving of the script yet so I’ll need to go and change the source first… More reporting back from me later. This looks really promising and I’m confident it’s going to solve 90% of the pain points I’ve been hitting trying to move complex (hell even simple) databases to the cloud.
Windows Azure|Thursday, September 03, 2009 11:12:12 AM UTC||