Rambling

My own meandering thoughts and rants. Stuff that might not go anywhere else

Say what?May 15th, 2009

A few weeks ago I was sat in a waiting room when I heard the receptionist say “I’ll delete that”. Being bored out of my mind, I started thinking about those three words. Or more specifically, the verb in the middle.

Of course, the word ‘delete’ isn’t exactly new: it’s been with us since the late 15th century with little (if any) change to the usage. But what really got me thinking was how commonplace words related to technology has become: the receptionist used the term ‘delete’ was used because it’s the word that appears in Microsoft Windows.

Had the good old system of pen-and-paper been used, then perhaps the phrase would’ve been “I’ll rub that out” or “I’ll get rid of that”. But instead, the programmer’s default phrasing was used instead. (Whether or not this is good phrasing on the programmer’s side is an article for another week…)

A number of new words have also been coined in a massively short period of time, the most common being podcast and blog; and a lot of words have been given new meanings. Words such as desktop, tweet, network and port would sound alien to somebody from the past.

It’s always interesting to see how language usage changes over the years. Which new words are being introduced, which buzzwords from last year aren’t being used as much, how the words are formed. It’s our own little lexicon, with the added joy of terms being added and removed all the time.

No wonder those who don’t follow technology changes closely are easily confused!

DIY web designApril 24th, 2009

With the likes of Twitter, Facebook, Livejournal and Google Sites, it’s never been easier to publish content on the Internet. And this is a great thing, it’s a new and growing media that lets anybody have their own little soapbox and gives those who wouldn’t otherwise have the chance to be creative to create stuff cheaply and easily.

But if you run a business, should you save money and make your own website? Well, I reckon it all depends.

I like to compare websites to leaflets and posters. On one hand you get the professionally printed coloured leaflets on glossy paper, and on the other hand you get the home-printed, black-and-white, inkjet-printed and library-photocopied leaflets that get shoved through your door advertising local fairs or plumbing services.

If you’re a plumber then people don’t expect professional leaflets, and it would only be a waste of money. But if you’re a business with its own premises you want to give a top impression to your customer, and what better way than with a professionally made and created site?

I’m never one for making the web industry a snobbish and exclusive one, and so think that home-made sites do have their place. As do sites created by amatuers — these sites are often cheaper (or free), lets the designer enjoy his hobby, and allows him to learn more about creating websites.

It’s certainly cheaper to create it yourself if you don’t have the budget, but you get what you pay for. Going professional is worth every penny, and the designer will know the very latest techniques and will create you a site that will get you out there (with knowledge in SEO), will make you money, and will show you in the best light possible.

But if you do choose to make your own, please don’t use free hosting sites like Geocities and Tripod. You won’t get your own domain name, you won’t have complete control, and they’ll shoehorn adverts onto your site.

5 things I learnt at SQLbitsApril 10th, 2009

Yes yes, I know it was a while ago now, but here are five things I picked up from the various sessions at SQLBits last month, and talking to the speakers afterwards.

If you’re using MS SQL 2005, upgrade to 2008

The default settings in MS SQL 2005 are a bit rubbish, to say the least. So if you can, upgrade to 2008. If you can’t, make sure to disable the admin user. There are also other settings and services that should be disabled if you aren’t using them.

Log all login attempts: even successful ones

You never know when you’ll get a disgruntled admin or user. I’ve even gone as far as logging whenever something has been removed from the database (such as a product) at the application level, although this isn’t as necessary.

Use the correct data type

By selecting the wrong datatype you could be wasting more space than you realise. Small things such as using an integer instead of a bit to store a flag can make all the difference

Use specific data for testing

Never use empty data: run your test with specific data and then roll back.

Pester your DBA

If you notice a lag in your application, then pester your DBA and ask him to run a trace. He’ll love you for it, and it will help you improve your SQL where there are problems

Thankyou

A big thankyou to the organisers, speakers, and volunteers at SQLbits who made it a great conference

Data security: is there a solution?October 31st, 2008

With data still being lost all the time by public bodies and private companies, you know there’s something wrong. When we give our information out, especially to public bodies, you expect them to be kept safe. But they’re not: printouts are being left on trains, laptops are being lost, and CDs are being lost in the post.

There are laws stating that data should be kept secure and removed once no longer needed, but this isn’t always followed. Whose fault is this? Do we blame the law for being too confusing, do we blame the staff for not following the law, or do we blame the corporations and the government for not training the staff?

The fact is, whoever is to blame there is still the problem that USB sticks are still being left on trains and CDs are still being lost in the post. No matter what data security policies are in use, they don’t seem to be followed. Afterall, humans are humans and they will always be lazy, slip up, and this is where things go wrong.

But how do we fix this? I’ve always believed that if somebody does something wrong on a computer, it’s not the fault of the user but of the software for letting them do it in the first place (or not making it clear enough that this is the wrong thing to do). Sounds confusing, but bear with me.

How is it possible to put all this data on USB sticks and CDs in the first place? Who would ever need to get access to all of this anyway? The National Audit Office only needed a small amount of the child benefit database: personal details weren’t needed and so the data could be anonymous. But the whole lot was sent anyway because it would cost too much to extract that small amount. The questions that should be asked are “Why was this person able to do this?” and “Why did it cost so much anyway?”. The lessons that should be learnt is to improve the database to stop these accidents from happening again, not toughening policies.

But then again, maybe I’ve got it all wrong. Should we be tightening data protection policies instead? Maybe bigger fines for those companies that don’t follow them: afterall, companies would try harder to keep their data safe if they knew it would be financially damaging otherwise… or would they?

I guess data security is going to be one of those debates that will be with us for a while. Perhaps there’s just no easy answer, and the current government are doing the best they can. What do you guys think? How would you make data more secure? Who do you think is to blame?