Post #125
Rudy Limeback
13th January 2004, early afternoon | Comments (14)
My Grandma came over yesterday:
- Dunstan
Hey Grandma.
- Grandma
Hello darling, what are you up to?
- Dunstan
Ugh, well, I’m stuck. I’m trying to understand adjacent lists, modified pre-order tree traversal and x-depth recursive nested queries, to get this SQL statement to work.
- Grandma
Hmm, have you tried limiting your query loops to a set depth? That’s what your Grandad and I always do. Or a four-way left outer self join might do it, to show the current level, plus 3 levels of the tree?
- Dunstan
Well that’s just it, I don’t want to go that route. It’s too limiting.
- Grandma
Yes… tricky. Well, why don’t you give that nice foreign man, Rudy Steinbeck a call, dear. He’s always been very helpful in the past hasn’t he?
- Dunstan
It’s ‘Limeback’ Grandma, ‘Steinbeck’ was the Of Mice and Men chap. But good point, old thing, I’ll give Rudy a buzz.
And you know what, she was right. She might not have the first clue about appropriate SQL statements ("a four-way left outer self join" — I ask you!) but she surely knows her database gurus.
Rudy Limeback: The LEFT-JOIN Lothario of Toronto; The Query-Kidd of Canada; The 2003 SitePoint Database Guru of the Year, is my SQL go-to guy. And he could be yours as well.
Rudy’s list of achievements are pretty impressive: one of the founding members of Evolt; Technical Editor at Digital Web magazine; published author; and last year’s SitePoint Database Guru of the Year. He’s a remarkably friendly, talented and affordable fella.
Rudy Limeback has worked with commercial databases since the mid-1970’s, starting with IDMS, a Codasyl network system, and progressing through IBM’s DB2 and Microsoft’s SQL Server relational databases. He has developed data warehouses and transactional databases, always with an emphasis on making them easy to use for developers and end users alike. He specializes in writing SQL statements that are simple and easy to maintain
In 1997 Rudy took a year’s sabbatical from SQL work to prepare for his biggest challenge to date — to become the last man to tightrope walk over Niagara Falls before the practice was outlawed. Unfortunately bad weather and a terrible bout of diarrhoea put paid to this heroic feat, and Rudy, bowed, but not broken, returned to the fold and his place as the industry’s SQL Man Of Choice.
As a contractor, Rudy is always looking for work. So if you have a job, no matter how large or small, get in touch with him. He’s easy to find, easy to work with, easy to pay, and very effective.
His site can be seen at: http://r937.com/
Jump up to the start of the post ↑
Blogmarks
A collection of miscellaneous links that don't merit a main blog posting, but which are interesting none-the-less.
Our enemies are innovative and resourceful, and so are we. They never stop thinking about new ways to harm our country and our people, and neither do we.
— George W Bush (9)- What WordPress is doing to combat comment spam. (1)
- Mobile web tools, from Pukupi. (1)
- Pukupi’s top 10 hints for building interoperable mobile Web sites. (3)
- The photography of E.J. Peiker. (4)
Stuff from the intersection of design, culture and technology.
(3)- Some handy tips for advanced Google use. (35)
- Make your own church signs, or view some real ones. (8)
- Michael Heilemann is doing a great job with his new WordPress theme; Kubrick. (1)
- I’m late to the party, but Dan has a book out. (1)
- What a crazy concept for laying out housing estates. (3)
- In San Francisco, I live here. (Try the zoom feature.) (1)
- Spider-Man reviews crayons. [Via] (3)
- Some beautiful images from photographer Greg Downing. (2)
- Lots of links, from the Link Bunnies. (1)
- Nice “when I was a child” sort of post from Stuart. (1)
- How much does SafariSorter cost? (4)
- Some handy maintenance tips for Mac owners running Panther. (2)
- Alex King launches Use Tasks: a hosted service for Tasks and Tasks Pro™. (2)
- Min Jung, Anil Dash, and I get interviewed for HBO’s Real Sex. (10)
Blog-roll
A selection of blogs I read on a regular basis.
- Hmm, the blog-roll seems to be a little bit broken right now (it may be that the blo.gs service is having problems). I’ve sent myself an email about this problem, and will try to fix it ASAP.