Sky on Tech

Wow, it has been a while since I'm summarized my Delicious tags, so a bit of a longer list than usual. These stories are related to:

• SQL and DB2
• Cloud Computing
• Collaboration software
• Software development
• Innovation, business, self-improvement
• Podcasts
• TED talks

And for those of you on Twitter, the stories relate to: @carlsafina @sivers @lukewdesign @timveal @Tunglerocks

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

It seems like an obvious question, but when someone on an IBM developerWorks forum asked how to use wildcards as literals in SQL I realized I didn't know the answer off hand! How DO you find all the records with a part number that contains an underscore, say? SELECT * FROM partno WHERE part LIKE '%_%' doesn't work as we'd like!

The Toronto City Council has a Twitter feed that I follow ( https://twitter.com/TorontoCouncil ) and when they announced they had a short survey to see how they were doing, of course I wanted to help out. Things went OK until...

At a personal level we all want to remain healthy, and keep our kids healthy. We also want the environment in our citites to be as healthy as possible.

Genetics + Lifestyle + Environment = Risks

There is a lot of focus on two parts of the equation, genetics and lifestyle, and over the last few years technology has been providing us with more and more data to better understand the environmental risks for everyday people.

My summary of interesting URLs from last week, including stories related to:

• SQL and DB2
• Data Visualization
• Collaboration software
• Software development
• Podcasts
• TED talks

And for those of you on Twitter, the stories relate to: @evgenymorozov @lorifisher @rashmi

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

My summary of interesting URLs from last week, including stories related to:

• SQL and DB2
• Innovation, business, self-improvement
• Podcasts
• TED talks

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

My summary of interesting URLs from last couple of weeks, including stories related to:

• SQL and DB2
• Software development
• Web tools and standards
• Innovation, business, self-improvement
• Podcasts
• TED talks

And for those of you on Twitter, the stories relate to: @Tunglerocks @DanielPink @tgoetz @hershco @max_webster

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

I had what I thought was a simple requirement, sort a set of MySQL 5 rows in order by the day of the year, regardless of the year. April 22nd before April 21st, etc... In particular I wanted to show photos from 'this day in history' going back over a hundred years! My DAYOFYEAR() code worked perfectly, until the Great Toronto fire of 1904...

My summary of interesting URLs from the last couple of weeks, including stories related to:

• SQL and DB2
• Web tools and standards
• Podcasts
• TED talks

And for those of you on Twitter, the stories relate to: @max_webster @dotspots @HiddenBrain @mattjamestaylor @djhomeless

(As always, most of the text is lifted directly from the related websites and isn't my own text.)

My summary of interesting URLs from the last couple of weeks, including stories related to:

• SQL and MySQL and phpMyAdmin
• Location aware applications
• Software development
• Podcasts

And for those of you on Twitter, the stories relate to: @chamillionaire @QD3 @dozba @glennplatt @voidfiles @theCSSninja

(As always, most of the text is lifted directly from the related websites and isn't my own text.)