Shaun Mccran

My digital playground

01
N
O
V
2010

Securing server side Coldfusion code with cfcompile

If you ever need to protect your intellectual property, or you have suspicions that your code maybe be accessed on a server to be tampered with, then your best option is to compile your code base.

This article addresses how to use the cfcompile command, and what it actually does to your code base.

[ More ]

18
O
C
T
2010

GetJar mobile App changes its billing model, launches GetJar+

I've never used the getJar application market place, I had heard of it, but never really considered it as competition for the regular Android market. I was recently approached by their PR agency with a press release detailing how they are launching a pilot program, called getJar+. It looks like they are switching to an AD based revenue stream rather than a pay per app system.

I'll give them a try, but I'm holding back on judgement until I've seen what they host, and how easily they interface with my mobile platform.

The full press release is included below.

[ More ]

09
O
C
T
2010

Lionhead studios launches GPS based fable 3 mobile App - Kingmaker

Lionhead studios have just launched 'Kingmaker', a mobile application that uses your GPS data to mark locations as 'owned' by you. You work on behalf of one of two teams, and receive gold coins to be spent within the game, every time you log a location in the application.

http://www.fable3kingmaker.com/Default.aspx

From a technology point of view this is an interesting example of many different platforms all converging to drive people towards pre ordering and buying a game.

The initial interaction is through several different mobile platforms (iPhone, Android, Blackberry and Windows 7 mobile). Each GPS 'tagging' posts to social media platforms, such as Facebook and Twitter, and the virtual gold is credit to your account. The account itself is an Xbox 360 account (windows live account), which will interface with the game, and you're in-game character ends out with the gold you have accrued.

It's an interesting proposition, and is trying to integrate several differing data platforms into one cohesive direction. It really is joined up thinking.

03
O
C
T
2010

How to find out the size of data in MS SQL databases

If you are running Microsoft SQL server you may already be familiar with how the database file system can enlarge itself to astronomical proportions. There are 'Auto shrink' and 'Auto grow' options, but these are really not recommended for production environments.

So how do you go about determining how much space is being used by actual data IE records, and how much is being used by log files etc? This article will show you how to run a query that will return the size of all the tables in your database, and highlight a TSQL command that will clean up the file storage of a database.

[ More ]

_UNKNOWNTRANSLATION_ /