Tuesday, 10 March 2015

ALTER AUTHORIZATION

(For my own reference)

To resolve this issue in Microsoft SQL Server (often observed when you restore a database that came from another server):

SQL Server Management Studio information dialog

Run this:

alter authorization on database::[MyDbName] to sa;

Thursday, 19 February 2015

MVA Figurines

In September last year I took part in the MVA ‘Become a hero’ promotion. By signing up, I got a free t-shirt (and if you know me well, you’ll know that makes perfect sense). In addition by completing a number of online courses from the MVA site, you could then get a novelty figurine (or maybe up to 6 if you did more courses).

I received my t-shirt, but my figurine never arrived. It appeared the super powers of “DevOps Captain Code” also included the ability to get lost in the mail. “Oh well, at least I’ve got a t-shirt”, I thought.

But then yesterday I got home to discover two packages from Microsoft. One was another t-shirt (yay), and the other was the full set of 6 figurines.

MVC Hero Figurines

So now we have (left to right)

  • SQL Server Query Controller
  • Azure Cloud Ninja
  • Device Management Dr Device
  • Windows Server Solid Server
  • DevOps Captain Code
  • Virtualisation Hypervisor

They’re now gracing my desk at work, much to the bemusement of my colleagues Smile

Figurines and t-shirts aside, if you’re after some quality free online training then there’s some excellent resources at the Microsoft Virtual Academy site. Most courses are run as a live event and then are made available on-demand a few weeks later (useful if the live event clashes with your preferred time to be asleep!)

Saturday, 7 February 2015

In the garden–February 2015

It’s summer time. We’ve had a bit of hot weather, including today (and more to come in the next week), but also some cooler patches too, which I think the garden has appreciated.

On hot days when it gets into the high 30’s and 40’s, I’ve taken to putting out shade for some of the smaller fruit trees. Bits of shade cloth and old sheets. The garden probably looks a bit like a weird art installation, but I think the trees appreciate a bit of help surviving the blistering heat.

I’ve harvested some cabbages (there’s still a few growing), and got some tomatoes just starting to fruit. I was a bit late planting these – my dad is already eating the fruit from his. I had planted some cucumbers and pumpkins but only two plants survived and they’re not really flourishing. I think I should try and get things started earlier next season.

There’s some corn that’s getting ready to flower, so hopefully we’ll have some corn cobs down the track.

Gala applesWe’ve got two apple trees that were planted almost 5 years ago. The ‘pink lady’ has fruited for the last couple of years, but this season is the first that we’ve had fruit set on the ‘gala’. Not sure if it just took a while to get ready, or if I pruned the wrong bits in winter previously.


Unripe QuinceNarelle planted a Quince tree behind our back fence a just over a year ago. It’s got some fruit growing on it, which hopefully will ripen as we approach winter

Sunday, 1 February 2015

Windows Phone app download stats

I’ve installed the Windows 10 preview build on my laptop, and one side-effect of this is that I can’t get the Windows Phone 7.1 SDK bits to work (they won’t install). Hopefully they will be supported eventually in later (or the final) versions of Windows 10, but for now it means I can’t do any 7.1 builds of my phone apps using my laptop.

I thought it would be interesting to find out how many 7.1 users are still downloading the app, to gauge whether I should still try and support the older devices. I took a look at the download data for one of my apps (Aussie Toilets) for the last 3 months:

Graph showing percentage of Windows Phone OS versions. 7.1 at 13%, 8.0 at 33% and 8.1 at 53%

So, just over half of the downloads were using 8.1 and a third are still on 8.0. Only 13% are still on 7.1

What about handset manufacturers? No surprises there – Nokia with 90%.

Bar graph showing handset manufacturers by percentage. HTC with 8%, LG with 1%, Nokia with 90% and Samsung with 3%

And the same for country/region – Australia with 89%. I assume the other countries were just curious, international travellers or possibly even immigrants who preferred their original country’s settings.

Bar graph showing downloads by region. Australia with 83%, other countries all below 6%

And finally just out of interest, age groups:

Bar graph showing age groups. Reasonably even spread from 15 - 22% across age groups

That’s a nice even spread across the various age groups.

So that might mean that for now I’ll have to leave the 7.1 users high and dry. If support for installing the old SDK is fixed, then I can look at giving them a few more updates in the future. Alternatively I might be able to convert my old system image into a VHD file and then I can boot the laptop back into the old Windows 8.1 image. I’d have to trim down the VHD file so it can fit onto the 500GB SSD I’ve got in my laptop though (that may not be that easy as the original image that’s still sitting on the old non-SSD drive was also 500GB).

The other messy part is that you can’t easily develop within a single version of Visual Studio for Windows Phone 7.1, 8 and 8.1. Visual Studio 2012 was the last to support 7.1 and also supported 8.0. Visual Studio 2013 can do 8.0 and 8.1 and Universal Apps (sharing code with desktop Windows).

Saturday, 24 January 2015

Tour Down Under 2015

Me and Dad approaching the finish lineYesterday, I took part in the BUPA Challenge Tour ride, part of the 2015 Tour Down Under. I rode with my Dad and Philip – all as part of the Mud, Sweat and Gears bike club. We followed the same route that the professionals would take later in the day. Apparently around 6,500 cyclist took part – some like us doing the full distance, others choosing to do shorter distances by starting at a number of locations along the route.

The official route started at Glenelg, but to save riding down to Glenelg and then back the same way, we started from the bottom of the Southern Expressway. We then headed south down the Expressway (a route not unfamiliar as the veloway parallels this) and then through Old Noarlunga, back onto Main South Road then past Aldinga to Sellicks Hill.

Sellicks Hill was designated as the “King of the Mountain” section for the professionals, but it really was just a gentle incline.

Nangkita food stopFurther along, after nearing Myponga, we veered off back towards Mt Compass. Just before Mt Compass it was great to have my in-laws Rick & Margaret cheering us on (they’re a regular fixture every year to see us during the ride and at the finish line). Passing through Mt Compass, we travelled a few kms before stopping for food and refreshments at Nangkita.

Back on the bikes, through Ashbourne, Strathalbyn, Macclesfield and then another drink stop at Meadows. No time to stop at the bakery unfortunately!

The final leg through Echunga and finishing at Mt Barker!Looking towards the finish line, Mt Barker

Here’s a summary of my ride captured by the Endomondo app on my phone. (Note that the distance/time includes travelling from my home, but I’ve edited out that part from the map).

We rode a total of 152km and took 7 hours, 4 minutes (including rest stops).

TDU 2015 Ride Summary

As you can see, we don’t set a blistering pace Smile - 20km/h is about our average. Those sharp dips on the bottom graph’s green line correspond to our rest stops. The grey line on that graph shows the elevation.

I think this year I had one of my better preparations for the ride. I’d been able to get in some regular rides to work and got out most Saturday mornings in the last few months. Whilst glad to finish, I felt in reasonable shape at the end. The weather certainly helped – it was very mild for most of the morning, and we even had a bit of drizzle as we passed through Sellicks Hill. It was only in the last hour and a bit that the clouds parted and the sun made itself felt.

The tour organisers did a great job. Lots of drink stops and well provisioned food stops. No complaints there.

TDU 2015 o

Here’s my Dad and I after the race – please ignore the helmet hair! It was a good day and a great ride.

Photo credits – My sister Fiona for the two photos of me and my Dad

Thursday, 8 January 2015

Riding in the wet

Unlike earlier this week when Adelaide was dealing with 40°C heat and the worst bushfires since Ash Wednesday in 1983, today is wet.

The weather radar image gives you an idea:

128 km Adelaide (Buckland Park) Radar - 8th January 2015, 11am

This is fantastic to help put out the bushfires (and water the garden). Not as much fun if you’re trying to get some exercise for the Tour Down Under ride in a couple of weeks.

I hadn’t ridden my bike earlier in the week because it had been so hot, so I was determined to ride to work today, even if it was a little moist outside.

One problem I’ve noticed on the rare occasion that I am out riding in the rain is that your feet get saturated. The water flicks up front wheel and goes straight onto your feet, so you feet end up sloshing around inside your shoes. It’s at those times that you wonder a) why you’re out riding in the rain in the first place, and b) is there anything you could do to make it a little more comfortable.

This morning I thought I’d try an experiment – putting plastic bags over my bike shoes. The plastic bags were just held on with my reflective strips.

Long story short.. it worked for about 15min, then I discovered that the other source of moisture in my shoes comes from the rain hitting my legs and trickling down into my socks.

David's shoe covered in a wet, muddy plastic bag

Maybe sticky tape might have helped a bit. I’ve also heard that you can get proper wet weather booties (apparently made of neoprene like a wetsuit). If you were regularly riding in the wet, I suspect they’d do a much better job.

At least now I don’t need to wonder anymore.

Sunday, 4 January 2015

2014 in review

As I write this, a major bushfire is threatening towns and some suburbs in the north eastern areas of the Adelaide Hills.

Smoke rising from bushfire

Here’s a photo I took on my bus ride home from work on Friday, looking north. You can just see the edge of the CBD on the left of the horizon. The smoke is towering up into the sky. Friday was very hot – it got to 44°C (~111°F). This morning (Saturday) when we woke up, the smoke had drifted south and was obvious in the air around our house.

Fortunately I live a fair way away from the fire front, but that doesn’t mean I’m not thinking about our preparations should we be put in a similar situation. Given where we live, it’s a real possibility every fire season.


So, that’s an interesting start to 2015, but what about last year?

User Groups

I’ve been involved with the SQL User Group since it started many years ago. The Adelaide .NET User Group (ADNUG) has been running even longer, but for most of that time the evening meeting time wasn’t that convenient. That changed earlier this year when I decided I wanted to take my user group involvement up a notch, by not only becoming a regular attendee at the ADNUG meetings but also stepping up to help organise them too.

I’m now charged with organising speakers for each month. Speaking of which, this month we’ve lined up Sayed Hashimi to speak to us live from Redmond (Washington, USA) on changes coming to the ASP.NET 5 project system – register now! If the live hook-up works well then we might plan these regularly – possibly alternating each month between in-person and virtual. It could be a way to book some more well-known US (or other overseas) speakers.

Work

A big change in 2014, with me leaving Eka at the end of September. I was feeling quite unsettled and was really not sure what the future held for me there, so I thought if I could take the initiative then I would, and applied for a position as a software developer at RL Solutions. It was a great start, and to be honest I’m really, really enjoying working with my new colleagues. In particular, I love the ‘team’ and ‘fun’ focus. I commented to the local guys when I began that unlike the Toronto office, we didn’t have a table tennis table in Adelaide. I’m pleased to report that oversight was remedied just before Christmas – just in time for us to be thoroughly ‘wiped off the court’ by our visiting CEO Smile

PowerShell

I was doing a lot of PowerShell earlier in the year, particularly in managing build servers and automating deployments. I’m still a PowerShell enthusiast, though those particular areas are no longer ones I need to worry about so much at the moment.

Windows Phone and Windows

I managed to get one new app out this year, but felt like I just didn’t have any spare time to devote to pushing out some upgrades to some of my other apps. I hope that gets rectified in 2015.

I’ve been running Windows 10 preview on my laptop with not too many dramas. I’m looking forward to seeing it progress through this year. I’m curious as to what changes will come to Windows Phone from this.

.NET

Wow, what big changes are happening for Microsoft and .NET. Who would have thought open source would be having such a big impact and become part of their culture like it has? It feels like the ‘new guard’ at Microsoft, particularly in the developer division have really started to have an impact in this area.

Cycling

One constant frustration with working at MatrixGroup/Eka was the lack of change facilities for those of us who like to ride our bike to work. I was very pleased to confirm that my new place of employment does provide both bike storage and shower facilities.

I’ve signed up to do the Bupa Challenge Tour ride (part of the Tour Down Under) on January 23rd.. Hmm, that’s only 20 days away! So it’s been great to be able to put in some rides to work as well as a few Saturday morning rides with the Mud, Sweat & Gears guys and girls.

Personal and family

Changing jobs feels like a big stress has gone. That is good. I’m still not sleeping well though, and am booked in to have a ‘sleep study’ later this month. I’m hopeful that might provide some clues and a way forward to not feeling tired most days.

Close friends and colleagues know that my family seem to have a few health issues that we have to struggle with. I don’t expect 2015 will be dramatically different. Put it this way – I realised that I now am reasonably confident navigating my way around the local Emergency Department (which otherwise resembles a rabbit warren) now that I’ve had to visit there quite a few times.

Looking ahead, other things to get done include getting an aquarium up and going (still deciding if we go for fish, or maybe a turtle). There’s also a chook shed that needs to be finished. The kids have already given names to our future chooks (you might sense a theme):

  • Princess Layer
  • Chook-backa
  • Hen solo
  • Bantam menace

Our oldest will start his last year of Primary School, so selecting a High School will also be on the agenda (we’ve already been doing some research towards this).

So there’s some of the things that stood out for 2014 and a few things coming up for 2015. I’m sure I’ve missed something!

What were your significant events for 2014 and what are you looking forward to in 2015?