SQL: Replace strings for TEXT datatype

There might be a simpler way to do a replace of all occurences of a string in a SQL TEXT field, but this is the solution I came up with way back when. I needed it again tonight so I figured I might as well pin it to the interwebs.

-- UPDATE [TableToUpdate]
-- SET [Column] = cast(replace(cast([Column] as varchar(max)),'[StringToReplace]','[ReplacementText]') as text)
-- WHERE [Column] like '%[StringToReplace]%'


Google Chrome

Downloading and installing Google's new web browser, Chrome.

http://www.google.com/chrome/

Prius crisis averted. It's too much money and the Element looks brand new (to me) again after a weekend of cleaning.

I need an intervention, otherwise I might start payments on a Prius this weekend...

The New Doh!lar

Wouldn't it be cool if our money looked like this? When your currency looks this cool and can be modded in such a way, it's just all the more reason to support the switch to the Euro...
http://ping.fm/346rX

Fast Food Internet

Sitting in McD's doing client work instead of blinding people on the beach with my no-tan tan. Doh!!!

And now the explanation:

Well, long story very short (edited: not really)... I was waiting approval for a change on Friday, but it didn't come until after we were already on the road to OC. So... we were looking for open wireless connections on the way over but the lag on the iPhone's wireless selection screen was a bit too much for the speed I was driving. It was already after midnight by the time we arrived and my client's contract with another company bound them to posting content by midnight on the West coast.

So, I had to buy the wireless that OC provided to the condo and it was absolutely terrible. I actually had to leave the condo and sit on the front steps at 1:30 AM all the while watching my ever-draining battery indicator slip down to below 30%. My connection was so bad that I wasn't able to fully test the work on the production server before the laptop died and I had to crash.

The next morning I got up early and went in search of a better internet connection near an outlet and the waiter from breakfast said that McDonald's internet was the best on the 100+ side of OC. From my experience, I'd have to say he was correct. Also, since my client asked me to post a 20+ MB quicktime file to their homepage and I wasn't able to test the site under so poor conditions that I realized I needed to looking into some sort of streaming host. After a little research I discovered that for $30+ I could use QuickTime Pro to create a reference movie that allows QuickTime players to begin playing without having to download the entire .mov file. That's pretty much the definition of streaming. Another bonus of purchasing QTP was that I could finally resize the movie to make it fit on their home page properly.

Ping.fm is now pwning my blogs. We're officially one step closer to SkyNet.

My MySQL Experience

I've been doing a bit of development with MySQL for a client and I've had to do a bit of work under the hood since the original developer had made quite a mess of the database. One of the biggest issues/roadblocks I had to deal with was the fact that two database were using two different collations and were therefore not available for table joins. Not only that, but they were duplicating effort of managing two sets of records between the two databases. One table contained an important id value while the other didn't.

I don't have time now, but I will blog the solution that I had to implement in order to configure both databases (and their columns) to use the same collation. Perhaps someone who manages to find that post can direct me towards a better solution in the future as the one I came up with is slightly less than ideal due to the need to manually run each MySQL MODIFY statement. I know that there is a better solution.

Episodic Strongbad on Wii

Seems that the Brother's Chap are throwing their hat into the episodic gaming ring on the Wii and with the backing of Telltale Games (Sam & Max), it seems like a perfect match to me (rhyming was unintentional)!

"Telltale has been rejecting my ideas for green text adventures for years," laments thousandaire gadabout Strong Bad, "but we finally reached a compromise with this puffy 3D point-and-click-em-up adventure. They claim all the coding was done with green text, so I guess that's pretty cool."

[Telltale Games Press Release]

Chefography

Combining my love of documentaries with my love of Food Network chefs...I present to you, Chefography. Gin and I watched the Julia Child episode last night and found it completely enthralling. I can't wait for the episode on Duff.