Local And Global Temporary Tables In SQL Server

Some good information for those wishing to create temp tables in their stored procs...

It seems that CREATE TABLE #tablename is very local, however ## is not so local after all...

• http://techahead.wordpress.com/2007/09/27/sql-temporary-tables/
• http://stackoverflow.com/questions/126012/view-temporary-table-created-from-stored-procedure

Latest Dilbert. In Heaven.

Should Read About Subversion

Yup, externals: http://svnbook.red-bean.com/en/1.5/svn.advanced.externals.html

I Like These

http://ffffound.com/image/108c37d07526e3ad9434b3ffc1da87da3a7726fa

They are nice.

Google Feeds - Why RSS Should Be Embraced

Well, having previously thought Google didn't like to provide RSS feeds (you can see the content essentially being stolen) here's how they decided to implement it:

• http://www.readwriteweb.com/archives/how_to_use_the_new_google_web_feeds.php

Or, for broader information try:

• http://www.google.co.uk/search?hl=en&rlz=1C1CHMB_en-GBGB316GB316&q=google+search+rss&btnG=Search&meta=

If you want to filter and perform cool things with your feeds (or any feed) Yahoo Pipes can help, or Feed Informer:

• http://pipes.yahoo.com/pipes/
• http://feed.informer.com/
• http://marshallk.com/5-minute-intro-to-yahoo-pipes

It's Done. And I'm Shattered.

Well, thankyou to everyone who has (or will have) sponsored me for yesterday - you can now hit me up at http://original.justgiving.com/matthewwebster/

You can check out my tweets at #londonbrighton or http://www.twitter.com/horacebury and my photos at http://www.twitpic.com/photos/horacebury

London To Brighton Bike Ride For BHF

I would like to remind everyone that you can sponsor me for the London to Brighton (58 mile) bike ride on June 21, 2009: http://www.justgiving.com/matthewwebster

I really appreciate any and all sponsorship I can get.

If you want to take part, please visit BHF's website where, for the first year ever, you can sign up online: http://www.bhf.org.uk/

Too Awesome For Words...R2

http://www.wired.com/video/latest-videos/latest/1815816633/10000-fully-functional-r2d2/24892334001

R2-D2 droids for sale - $10,000 each.

Weirdness Abounds, Links An That...

I don't know what to say, just enjoy...

• http://lifehacker.com/5293823/heatmapper-helps-you-create-a-detailed-signal-strength-map
• http://lifehacker.com/5294758/feedstitch-combines-multiple-feeds-into-one
• http://lifehacker.com/software/feeds/geek-to-live--create-your-master-%20feed-with-yahoo-pipes-235726.php
• http://lifehacker.com/5295624/get-better-real+time-twitter-search-results-by-blocking-retweets
• http://gizmodo.com/5295656/microsoft-security-essentials-antivirus-software-codename-morro-available-on-june-23rd
• http://gizmodo.com/5296046/good-god-even-the-commodore-64-has-a-twitter-client
• http://gizmodo.com/5295987/myvibe-thighs+on-first-iphone-vibrator-app-approved-by-apple-nsfw
• http://www.tuaw.com/2009/06/18/diorama-will-tilt-your-mind/

Ok, so iPhone vibrators, MS do real security and feed stitching. It's all out there...

And the vid from the last link...

Today's Linked Fun, Augmented Reality

Movies, augmented reality Transformers and that...

• http://gizmodo.com/5292550/futuristic-movie-timeline-the-next-few-decades-will-be-eventful
• http://gizmodo.com/5293164/you-too-can-wear-the-head-of-optimus-prime-in-augmented-reality-of-course
• http://gizmodo.com/5292748/layar-first-mobile-augmented-reality-browser-is-your-real-life-hud
• http://www.youtube.com/watch?v=pzB4mIPdm9k&feature=player_embedded
• http://lifehacker.com/5292890/nexus-dock-has-leopard+style-eye+candy-effects

Pretending To Be Windows 7, Links An That...

From lifehacker and gizmodo, the usual, but with a Windows 7 tilt...

• http://lifehacker.com/5288408/viglance-converts-the-vanilla-taskbar-into-a-windows-7+like-superbar
• http://lifehacker.com/5289805/powerresizer-brings-windows-7s-window-sizing-to-all

More Google Wave...

• http://lifehacker.com/5288931/google-wave-questions-and-answers

Some advice for excel users...

• http://lifehacker.com/5288578/save-time-with-excels-double+click-tricks

And some photoshop help...

• http://lifehacker.com/5288622/a-beginners-guide-to-image-sharpening

And not a Photoshop job - Gundam Robot...

• http://gizmodo.com/5289548/activated-full-size-gundam-robot-looks-totally-absofrikinlutely-zomg
• http://www.pinktentacle.com/2009/06/gundam-night-pics/

An Interesting Piece Of Research On Weight Loss

This seems to back up the information about simply moving about more each day eating more healthy meals, rather than cutting down drastically and exerting yourself ridiculously, to be the key to successful weight loss:

• http://www.streetdirectory.com/travel_guide/47589/lose_weight/walk_77_miles_to_burn_off_1_pound__are_you_kidding.html

Subversion Explained

This enterprising young chap has broken the Subversion (SVN) source code control and versioning system down for all us pro techy geeks...

• http://coding-time.blogspot.com/2008/04/subversion-visually-explained-in-30sec.html

Windows 7 To Ship Without IE In Europe

Yep, finally, it's true and Opera's whinging has finally paid off. Sort of...

• http://arstechnica.com/microsoft/news/2009/06/windows-7-to-be-shipped-in-europe-sans-internet-explorer.ars

Or will they?...

• http://www.theregister.co.uk/2009/06/12/microsoft_windows_no_ie/

If they do, here's how to get a browser you like without a browser to download it with...

• http://www.boutell.com/newfaq/browser/installfirefoxwithoutie.html

Favourites From Salami Tsunami

Yes, it's true, Dusty Scott, aka Pork Tornado, aka Salami Tsunami, is the greatest blogger in the world...

• http://salamitsunami.com/archives/123 - Just Cuts It Off At The Base
• http://salamitsunami.com/archives/93 - Peachtree Flight Centre Website Support
• http://salamitsunami.com/archives/209 - TurboBitch 2001
• http://salamitsunami.com/archives/77 - I Hate Comcast
• http://salamitsunami.com/archives/198 - Choad Rage

Swine Flu Is a Pandemic

http://www.time.com/time/health/article/0,8599,1904062,00.html

Swearwords

If you want to block swearwords on your site, here's some resources. Things to think about are your intended audience, the seriousness of your site and how strict you want to be...

• http://www.bannedwordlist.com/
• http://www.banbuilder.com/
• http://www.noswearing.com/index.php
• http://www.lssu.edu/banished/current.php

Power Save, Bread And Back To The Future II

Lifehacker and Gizmodo to the rescue, again...

• http://lifehacker.com/5287092/switch-power-management-plans-with-a-hotkey
• http://lifehacker.com/5287212/make-fresh+baked-bread-in-five-minutes?skyline=true&s=i
• http://gizmodo.com/5287023/savant-virtual-control-makes-a-touch-interface-out-of-every-room-in-the-house?autoplay=true
• http://gizmodo.com/5286994/buy-the-hat-from-back-to-the-future-part-ii
• http://gizmodo.com/5067047/back-to-the-future-ii-jacket-on-ebay
• http://gizmodo.com/397866/back-to-the-future-mcfly-sneakers-unboxed-going-for-2000

Good Links That Are Good - Google Wave And More

Some links that are definately worth checking out...

• http://lifehacker.com/5285944/the-google-wave-highlight-reel *****
• http://lifehacker.com/5285831/mozilla-updates-firefox-add+ons-site-with-collections
• http://i.gizmodo.com/5286761/scientists-discover-superconducting-material-thats-just-two-atoms-thick
• http://i.gizmodo.com/5286709/star-radio-communicator-iphone-app-is-not-at-all-like-anything-from-star-trek
• Edit youtube videos: http://www.tubechop.com/

Acorn Gamez - Reliving The Wonder

While getting a bit hacked off with a PC yesterday, I went looking for some videos from years gone by. I found some videos by a guy who really should be linked: http://www.youtube.com/user/peetvanpeebles

I really have to say thank you to Peet Van Peebles here - these videos are so inspiring! I just want to fire up the old Risc PC and get playing again :)