I have been recently working on a database that hasn’t been designed but has been hacked together by lots of people over the years. It started life as an Microsoft Access database created by my director to keep track of all the projects that our company does. It was not much more than one table listing everything. At...

So my first Raspberry Pi project is a security camera. If you have read my previous Raspberry Pi posts you will know that I have been playing about with the camera but I had one or two problems with Pidora so I am using Raspbian for this example. To take a photo with the camera module you can use the command...

I am currently buzzing with excitement about my Raspberry Pi. I will try to document here what I have done so far. I decided to buy the camera module along with my Pi. It was straightforward to connect them up, lift the connector behind the network port, insert the ribbon cable, push connector back down. Next I...

TeamCity is a Continuous Integration software package which is very easy to install and set up. So easy I managed it over a weekend. First of all I fired up a VM in Azure. I found that a Basic A1 VM was sufficient so running a CI server doesn’t have to be expensive, alternatively you could always set a Virtual or...

I recently went to an event called ITBoss organised by Core Com Consulting . It was really good, helped partly by a free bar and great food. The event was hosted in a pub in central Leeds, so I rushed to the train station from work to get there. And yes I was the first to arrive (Why do I always do that?). The event...

Every developer uses source control, it is a great tool for keeping track of changes to your code, seeing who has done what. However I keep messing up, my use of it. I am fairly disciplined when creating new features, all my changes will get committed to source control and when I am happy I will deploy these changes to...

I have spent most of the day tweaking my Azure websites. Lots of fun! Last week unfortunately Azure had some problems and many websites that were running in the North Europe data centre were unavailable for several hours. And you guessed it my websites were hosted here. All hosting providers are going to have downtime...

My desktop is always a mess. I constantly download files there and forget all about them. Every now and then I copy files into sub directories, so my desktop looks sane for a day or two before it gets out of control again. Why don’t I write a script that I can schedule to do this for me. Then my desktop will always be...

One of my jobs is adding extra features to our internal databases. There is a fair amount of risk in doing this. I could make a change to one of the queries in the database that stops the rest of the company using it as they need to. This could be a costly mistake, almost as bad as the database server being...

I work for a company that provides a cloud computing website, but what is Cloud Computing? Wikipedia defines it as “Cloud computing involves deploying groups of remote servers and software networks that allow centralized data storage and online access to computer services or resources.” Erm. What does that mean? Well...