The SQL that saved my life…

Pretty simple find and replace:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);

OMG, I am glad I listened in the database classes all those years ago 🙂 I’m upgrading an older WordPress blog to the latest version and that lil query saved my life!

Vancouver Earthquake

On the news today they were discussing this. Seismologists were discussing small quakes in the Pacific just off the coast of Vancouver Island, they were saying how these mini-quakes could, in fact, be “gradually unlocking the tension in the Juan de Fucas and North American plates”.

This is good news for us all, perhaps we won’t have that BEHEMOTH quake that they’ve all been predicting!

Habs 59fifty New Era Hat

Tim Mason sends me an elaborate fake email, follows up with a heartbreaking IM chat about how New Era can’t get him the Habs 59/50 hat. Then he told me a few minutes later that he was tinkering on my Linux machine in work.

Check out what happened:

Tim says: where did u go for lunch…??
Tim says: got some bad news for you by the way….
Tim says: will forward u the email…
Carlo says: phat
Carlo says: bad news about a certain new era hat?
Tim says: read the email
Carlo says: sent it yet?
Tim says: sorry buddy….
Tim says: i tried
Carlo says: thats BS man.
Carlo says: i appreciate your help. balls.
Tim says: i can call the US rep and see what i can do
Carlo says: i can get it shipped to a US address then sent up here.
Carlo says: my uncle lives in SF.
Tim says: that might work…
Carlo says: So all the Montreal Canadiens hats are in the US?
Carlo says: and… NOT in Canada?
Tim says: yeah they don’t make that style anymore
Tim says: on the yanks where them they said
Carlo says: holy moly
Tim says: lots in USA… not pop in canada for hockey… just baseball and football
Carlo says: yeah, the other hats are wack, if I can’t get that one then its all good. thanks for trying, i know you busted one trying to get it.

He then sent this fake email…

Tim,

I apologize for this but we won’t be able to get the New Era cap to you as we can not access it. Not too mention that there are issues with the border crossing.

Once again I apologize and hopefully we will be able to introduce a new Montreal hat in the future.

NEW ERA FITS!!!

Here’s the rest of the MSN conversation after reading the email:

Tim says: let me ask u a question
Tim says: i was messing around on the back computer
Tim says: the server one that you use…
Carlo says: yeah, did you log in?
Tim says: yeah but it ate my disc….. i put a dvd in there….can’t get it out
Tim says: can u try for me….
Carlo says: weird. i will go fetch.
Carlo says: one sec.
Carlo says: you have a log in for that comp?
Tim says: tmason…. username mase
Tim says: but u might have to shut it off and back on again…
Carlo says: where’d you get the username from?
Tim says: but try and open the disc player
Tim says: kirk
Carlo says: ok.
Carlo says: trying now…

I doddle over to the computer to try and work this out for the mase man, and there’s a box on the computer. I thought “Who left a box on my server”. So I pick it up and there’s something inside. My name is on it, I pop it open and Tim (from here onwards and forever known as) “The Legend” Mason has hooked me up with this hat from New Era via Alabama!

montreal-canadiens-new-era-cap.jpg

Vancouver earthquake revisited

Just checking in with the situation on the Vancouver Earthquake situation and there could be some good news in store for us if scientist can manage to coax some really helpful bacteria to save us all!

Researchers at UC Davis have discovered microbes that can quite literally help the process of rock forming by converting lose sediment into the hard stuff. Although only tested on a lab scale, Bacillus Pasteurii, could be the answer to soil liquefaction caused my earthquakes.

It is suggested that the majority of the destruction from a Vancouver Earthquake could come in the form of mass movement or soil/earth liquefaction, a process where soft deposits such as clay, are converted to a jellylike state by severe shaking causing a situation where structures (buildings) could sink and collapse. Eeeeek!

Check out the other articles about a potential Vancouver earthquake here:

Keep up to date with global earthquake activity.

Top 10 Mr T Facts

(Similar to the Chuck Norris Facts)

  1. Mr T is the only person who can pronounce the exclamation mark.
  2. Mr T drives on the right side of the road, no matter where in the world.
  3. Mr T is allergic to doorknobs. Thats why he can only kick through doors.
  4. Mr T is not black, the sun is just too afraid to shine on him.
  5. Mr T took Mother Nature from behind, hence the Big Bang.
  6. Mr T captured all 150 Pokemon. He keeps them in cages in his van.
  7. Mr T once fell into a pool of lava and nearly drowned.
  8. Mr T invented fools. Realizing his mistake, he invented pity.
  9. Mr T doesn’t breath, he pities.
  10. Chuck Norris round house kicked Mr.T, Chuck got owned “PWND!”

I need a replacement for #4, its a bit crap, anyone have any ideas? Which is your favourite?

Post a comment below, thanks!

Vancouver earthquake update

So whatever happened with this big ‘ole Vancouver earthquake that’s supposed to be hitting us? I haven’t heard much in the news recently.

A quake registering 7.3 on the Richter scale was last experienced way back in 1946. A quake of 7.3 is classified as “major” on the Richter scale and can cause serious damage over larger areas. One thing we have to remember is that construction and infrastructure standards have come a long way so I wonder if these scales of magnitude (like Richter or Mercalli) actually take into consideration these new developments? The Richer scale was developed in 1935 and Mercalli in 1902, surely this needs to be updated? Does anyone have any thoughts on this?

I wish a scientist or geologist would comment on this blog because a lot of people have emailed me and asked me about this. Read the other article.

Vancouver Earthquake and Plate Tectonics

Apparently, Vancouver is going to be hit by a “big one”. At school, before I went to university I studied Geography at school as well as Geology. I know a little bit about plate tectonics and how and why earthquakes and mass movement occur. When will the Vancouver earthquake hit

Juan de Fuca plate - a big player in a possible Vancouver EarthquakeThe Juan de Fuca plate is being forced under the North American plate creating a “subduction zone”. This subduction has formed a lot of magnificent mountain areas in the Cascade Volcanic Belt (where volcanic mountains have formed that are not all within the Cascade Range). The movement of one plate beneath each other is never a smooth process. These plates tend to lock up until it reaches a point where there is so much pressure and stress that it violently moves. It is this mass movement that causes an earthquake.

This could trigger a Vancouver earthquake.

I can see Mount Baker from my window. There are many other mountains that you may have heard about in and around Vancouver, BC such as:

  • Mount Silverthrone
  • Devastator Peak
  • Mount Fee
  • Black Tusk
  • Cinder Cone
  • Opal Cone
  • Mount Garibaldi
  • Watts Point

Baker incidentally still shows steam/fume activity from its crate but is considered dormant. They also said this about Mount St. Helens which erupted famously in 1980 and was observed around the world in the media. Luckily, that did not trigger a Vancouver earthquake.

I definitely do not believe that we’re going to die, but if we were living on Vancouver Island I would be worried. Vancouver Island is a direct formation resulting from plate tectonic activity. Good reads for this include Global Tectonics and Earth as an Evolving Planetary System. (I believe the latter was on my course reading list at school).

NHL 07 and the dead PSP

I can make this a really long story, I could make this an 80 hour plus story but no, I will tell it to you in a few minutes.

I was playing NHL 07 offline, Montreal Canadians, the hardest level, full-length games, and manual shot control. I don’t screw around, I play the real deal. Anyway, I keep saying “long story short”, so here it is the punchline. I played that game for 80 hours plus, I was lying in bed finishing off a game versus Buffalo which I won 6-1 Kovalev got a hat trick and Souray was blasting in 2 goals with Koivu picking up one. Who cares who scored for The Sabres?! It was Afinogenov 😉

Regardless of that game, I always save the career every game. I saved it as usual and the next day fired it up, I decided to put the game away and wait to play The Leafs when I was more awake. I thought how much I really wanted to kick their asses so I wasn’t fully awake to be ready to kick their ass. So the next day I woke up and was ready to play, I was in bed and was ready to go. I flipped the switch and tried to load up the profile and lo and behold the game was corrupted.

I was so annoyed.

I can’t even begin to tell you what I did next. Dang, here goes, what an idiot. I put the PSP down and put my fist through it, well I tried. The screen was smashed so to make sure I killed the PSP I threw it across the room and went to sleep. I had to buy another PSP and start my career again, what a sham.

I was so annoyed with myself but I blamed EA, after all, it was their game that bugged and sent me into a rage. Does that sound irrational?