Blog

Stockholm – Helpful People!

S

After arriving at around 6:30pm in Centralen (Central Station) I had a rough idea of where to go. Walking around aimlessly with large suitcases isn’t much fun, so after admitting defeat, I decided to find help. Help came in the form of a giant man, dressed in a long trench-coat. I asked him where Tulegatan was (the road our hotel – Birger Jarl) is on, and he immediately whipped out...

Selling Car Fraud

S

I’ve started this category to make people aware of various means of scamming car owners, when selling their vehicles. The general idea is this: Someone will contact you, after seeing your advert. They will seem interested, and sometimes ask for more pictures etc… After some “haggling” they will aggree to buy your car at your asking price (or very near) They will then send...

Trimming

T

If you have imported a large amount of data, or had some rogue users, helpfully putting a space at the beginning and / or end of a string, then this simple update will clear that out: UPDATE TableName SET ColumnName = RTRIM(ColumnName) Of course, if you only want to select the data, you could also: SELECT RTRIM(ColumnName) FROM TableNames SQL Server 2005 has both a RTRIM and a LTRIM function...

Arriving In Taba

A

We arrived at Taba Airport around 7pm, and, after a short (we’re talking 30 seconds) bus ride from the plane to the terminal, we were put into various que’s. One for people who wanted a visa, and one for people who didn’t. If you intend to leave the Sinai, you’ll need a Visa. That means, if you intend to go to Cairo, you will need one. If you only want to sit by the pool...

Marriott Resort

M

First impressions of the resort were very pleasant. Although we arrived at night, the grounds still looked good. We had filled in a check in card on the coach, so were checked in within literally 5 minutes, and shown to our room by a friendly chap. I’d read that the staff here seemed to be miserable, however I didn’t find this the case. After around 10 – 15 minutes, another man...