Nov 122014
 

In case you missed it, Microsoft created a free version of Visual Studio 2013, named the community edition. You can create free or paid apps (and more), with restrictions when you use this version within a company. No such restrictions for the individual!

Download Visual Studio 2013 Community Edition

Thank you, Microsoft.

BTW I like this checkmark:

Visual Experience options

Visual Experience options

Nov 092014
 

I edited /etc/sudoers without visudo, and made a mistake. That will prevent you from successfully using sudo again. No real harm done, but it takes rebooting to get it fixed.

1) reboot in recovery mode (press escape when booting so the grub options are shown)
2) drop to a root shell (option in the recovery menu)
3) mount -o rw,remount /
4) visudo (emacs based editor)
5) reboot the system

You should be up and running again!

Oct 232014
 

Thank you, Rabobank, for detecting fraud on my creditcard and automatically blocking the card and rejecting the payments. This has saved me at least 500 euro! Thank you, thank you, thank you.

 Posted by at 13:07
Sep 182014
 

You can’t use ROW_NUMBER() in an update statement in SQL Server, so:

UPDATE TheTable
SET    TheColumn = ROW_NUMBER();

won’t work. But sometimes that’s just what you want. This will do the trick:

UPDATE  Target
SET     TheColumn = RowNum
FROM
(
    SELECT  t.TheColumn, ROW_NUMBER() OVER(ORDER BY t.ID) AS RowNum
    FROM    TheTable t
	WHERE    ...
) AS Target;
Aug 222014
 

Just prolongated my KPN subscription and ordered the Samsung Galaxy S5. Samsung offers a free S-View cover and 32GB memory card until the end of the month, so if any of you (local) S5 owners is interested in the S-View cover, let me know.

Jun 092014
 

I’ve used CyanogenMod before and was very satisfied with it. No bloatware, latest features and stable. Had it on my Motorola Droid (special version, since it’s not officially supported), on my Galaxy Nexus, I have it on my Galaxy S4 (my work phone) and after the latest KitKat update from Sony that drains the battery faster than a crackwhore needs her next shot, I decided to give in.

Bootloader unlock, which means a factory reset (you have to request the unlock key from Sony support). Which was the alleged solution to the battery problems anyway, so what could go wrong.

Enter Murphy.

My Windows 8.1 laptop does not recognize the XPeriaZ in fastboot mode. On neither USB port. Not with Android drivers, not with Sony drivers. Just an unknown device with a yellow exclamation mark in the device list. So I hooked up my phone on my Linux server. Yep. That just works.

CyanogenMod usually works perfectly with the ClockWorkMod recovery instructions. Boot in fastboot mode, flash the boot.img and reboot. Flash the custom rom image, and while your at it the Google Apps, and reboot and done. Not this time. The phone is stuck at the CM boot logo. Read the instructions again. Okay, mandatory “factory reset/wipe data” when doing a fresh CM install. I thought I did that, but hey, let’s restart. Flash boot.img, reboot, factory reset/wipe, install CM, install Google Apps. Reboot. Same thing: the CM boot logo. WTF?!

Google is your friend. I wasn’t the only one with this problem. Seems that the data partition made by Sony is encrypted in a way, and CWM does not wipe it properly or doesn’t wipe it at all. TWRP (TeamWin Recovery Project) should be able to do it properly. Next restart: flash the twrp image, reboot. Wow, nice GUI! No fiddling with the volume buttons, just point and click. Wipe the data partition/factory reset. Put the CM and Google Apps zip in the update queue (!) and flash them. Reboot. Wait. CM boot logo. Wait some more.

YES!!!! It asks for my PIN to unlock the SIM card.

Enter Google account credentials and……..oh wait. I have 2-factor authentication and the authenticator was …. on this phone. What now? Damn you Murphy. Turns out you can install the authenticator on another device, scan a barcode (the squares thingy) from a browser on your desktop and then it “moves” the authenticator to that device.
After that, I could succesfully login on my Google account with my fresh CyanogenMod installation.

Only to find that it does not automatically download all my apps. In fact, none of them. Ah well, at least it’s working again.

One more word: if you play games that are Google Play Games enabled, make sure you install Google Play Games first and then the games. Doing it the other way around will give you strange and unpredictable results. In The Gate for example, I got an “Download failed because you may not have purchased this app” which is very weird, since it’s a Free-2-Play game. Just uninstall, install Google Play Games, and then install your games.