Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
SQL upgrade done, new game, games review, and Pocket PC Phone Edition
Posted on 6-Nov-2004 10:50 by M Freitas | Filed under: Blog


SQL upgrade done, new game, games review, and Pocket PC Phone Edition
Well, the Geekzone Microsoft SQL upgrade is now done. All scripts are using stored procedures to try and improve performance, plus some other niceties. I've found a couple of problems when it went live, even though it worked ok on my test environment. For development I run a Microsoft Virtual PC guest machine running Micorosft Windows 2003 Server, Microsoft SQL 2000 (all from my Visual Studio .Net Enterprise Architect box). After migrating I found a couple of problems with Primary keys and database ownership. All sorted, and working. The migration itself was really fast, but I'm working on a 10mbps connection from home, some this is expected. Downloaded the current database from my hosting provider, uploaded a new database script, run a DTS package to migrate from my local data to the remote server, and all in less than 15 minutes!

Found the problem with my SELECT ColA, ColB, ColC, ColD statement sometimes not returning anything on some columns. It seems I have to explicitly move long fields to the right (end) of the query selection and use then in order. How strange is this? Coming from the mainframe world this seems rather odd. Just the field contents, sir...

Anyway, got an e-mail telling me about a review of the HTC Magician, also known as i-mate JAM (pictured) or QTEK S100. This is a Windows Mobile 2003 Second Edition for Phone Edition (long name, uh?) based Pocket PC. It's very small, the size of a Smartphone, and way smaller than the i-mate PDA2k (a.k.a T-Mobile MDA III, O2 XDA IIi, etc). Looks like a cool product and the review has lots of comparison pictures and short video clips.

Ballshooter has annouced a new game, called Crackout. In the meantime I'm doing the review of two games, 129999 Legacy: The Legend and 131284 Giza. Really cool games, you'll see.

Now back to fixing the last couple of problems I found on these scripts...





Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:



Trending now »

Hot discussions in our forums right now:

2019 Novel Coronavirus Covid-19 Discussion
Created by Batman, last reply by Batman on 5-Jul-2020 22:53 (11654 replies)
Pages... 775 776 777


Signal issue at certain time of evening (with signal booster installed)
Created by danepak, last reply by snnet on 5-Jul-2020 22:50 (15 replies)

Bank Charges for Paywave
Created by beenz, last reply by Handle9 on 5-Jul-2020 18:24 (60 replies)
Pages... 2 3 4


LED Downlights - can it be covered with insulation?
Created by samgdan, last reply by snnet on 5-Jul-2020 22:39 (12 replies)

2Deg fiber & access to ASB.co.nz
Created by ANglEAUT, last reply by ANglEAUT on 5-Jul-2020 23:44 (11 replies)

Wiring & Maintenance charge on Fibre.
Created by kiwifidget, last reply by old3eyes on 5-Jul-2020 20:39 (10 replies)

Canon "Compatible" Ink Cartridge for Printers
Created by biggal, last reply by MurrayM on 3-Jul-2020 11:34 (20 replies)
Pages... 2


Courier Post delays
Created by cyril7, last reply by quickymart on 2-Jul-2020 20:18 (551 replies)
Pages... 35 36 37