Just got the news that Sprite Software released version 2 of 117151 Sprite Backup for Smartphones. Apparently upgrade from v1 to v2 is free to current users, so I visited their website looking for my download. Found the new version, installed on my Windows Mobile Smartphone and got "The evaluation period for Sprite Backup has completed"... What? Ok, go back to their website - and nowhere there's ANY information about how to get this update. I then opened a support request, which was responded in a couple of hours - well we're an the same timezone, I wouldn't expect less... However, replies to that e-mail are not accepted, I had to go back to their site to update the ticket. Not happy.
An example of good update is from Anton Tomov. He sent an e-mail to all registered users of it very good 52913 Pocket Hack Master program for Pocket PC, including the new key to activate the program. Much better doing like this! His program is a really good overclock utility for Pocket PC.
Also, installed an application other day and didn't like it. After removal I found out that the remove programs routine is not removing an entry from the notification database. Now every time I place the Smartphone in the cradle it comes with a "Can not execute program...". Of course, the program is not there anymore. Should have an easy way of fixing this.
As you know I'm working on migrating the Geekzone database to a more robust platform. I'm in the middle of testing the current code with Microsoft SQL Server 2000. For this I have Virtual PC 2004 SP1 running Windows 2003 Server. On this virtual machine I have IIS and SQL Server. Of course thi is not our production machine.
The site is hosted by Intellihost, an Iconz service, based in Auckland. The guys are good, and work fast when needed. As I found out a couple of times, even during weekends when there's no formal support I still can call their help desk and get some action going on.
Back to this migration stuff... I have been changing lots of the scripts to use Stored Procedures. However I've noticed some weird stuff. For example SELECT * returns all columns on Query Analyzer, but on the ASP script some just come back as nulls! Someone suggested on the SQL newsgroup that I should invoke the columns by name, and move some to the end of the SELECT statement. It worked, after moving some of the columns. Why? Why? Why?
So, after spending a couple of hours on this problem, I'm back on the coding bench. Good stuff is coming out, performance increased at least four times on my test machine!