AuthorAlex

Using Microsoft OneNote Across Multiple PC’s using Amazon S3

U

Technorati Tags: OneNote,Amazon S3,Microsoft Office,Cloud I love Microsoft OneNote, and use it on a daily basis to record any ideas I have, things I find on the Internet etc… The issue is, that, whilst using it at home is great, I sometimes also have "brain waves" when I’m out and about on my laptop, or at work. I needed a way to share my notebooks across the internet...

Drink Prices In Stockholm

D

Now, everybody knows that drinks are pricey in Stockholm… but what does an “average” drink cost? Well…. depends where you are: GK (Göta Källare) which is in Södermalm (in Medborgarplasten metro station) has an event called 360 on a Friday night. The age limit is 20 according to the door staff, however some people I was talking to in the club were 18/19 They seemed to have...

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...