As today is New Years eve I thought it would be a good chance to look back over the last year. At the start of the year I finally got agreement for the installation of a 30MB leased line. This was an amazing achievement as I had been really struggling to keep everything working on our ADSL connections and the...
I saw this tweet on twitter. He’s making a database, He’s filtering twice SELECT * FROM customers WHERE behaviour = Nice Santa Clause is Coming to town. This started me thinking surely in a normalized database structure behaviour wouldn’t be stored in the customer table, so I propose the following change. He’s making a...
Moving house, lack of internet and lack of inspiration has caused a lack of posts recently but hopefully more to come. Been doing some filing and found an old software developer quiz. Thought I would have a go. Many thanks to Keith for originally writing the quiz. Questions: Write a function that determines if a...
On Friday night I had the urge to fire up Visual Studio and tomorrow (Monday) I move house. What’s with that? Why am I in a programming mood when I have boxes to pack and shelves to take apart? For the last few weeks I have been too busy with other things to do much programming or when I had the time I felt more like...
I listen to the dot net rocks podcast and they ask this question every show. (If you don’t listen then you should!) I don’t know what my answer would be as there are so many gadgets and cool things that I like the sound of. I might get a surface pro 3, it’s a tablet with attachable keyboard that’s more powerful than my...
I have done a few interviews from both sides of the table, I’m not very good at either but thought I would have a go at answering my favourite questions. Describe an IT disaster and what you did to turn it around? The question is all about the turn it around bit. I’ve had lots of answers that emphasise the problem...
Let’s continue looking at a database schema for storing details of every Star Trek Episode. If you are new to databases, a schema is just the design of the structure of the database. We have three tables, Episode, EpisodeWriter and Writer. See my last post for more details of these. It has been suggested that a slight...
My last post proved quite popular so I am wondering if I can combine a post about IT and Star Trek. Years ago I used to have lists of Star Trek episodes, which included such information like original air date, production number, episode title and brief description. One thing that was hard to keep track of was how many...
As a break from my usual topics I am going to talk about what I did over the weekend. I am a huge star trek fan, so me and my wife Laura went to Destination Star Trek, a convention held in London. This is a picture of us in costume, my wife created a tribble costume (A tribble is an alien race that just consists of a...
Like many systems administrators I watched as the news came out yesterday about the latest version of windows. What would it be like? What would it be called? Would it be better or worse than previous versions? I was shocked when the name of the new operating system was revealed to be Windows 10. What really!? At first...