Jim's Journal

03/12/2008 15:59 #43639

SQL
Category: work

My ability to write SQL is severly atrophied, and I hate it.

jim - 03/13/08 09:09
Wrong account? LOL

megan - 03/12/08 23:45
UPDATE users, outtatheloop SET users.intheknow = 1 WHERE users.uid = outtatheloop.uid AND users.tony = 'awesome';

My SQL's OK. My Ruby... not so good.

Sometimes I like to Megahurts my RAM in public, but i'm going to end up LOLing my ROXORZ if I keep it up... Yeah.

And SQL actually stands for Shugga Quit Lieing, and I'm telling the troof.

PS. just remember to fully qualify your columns with the table name in order to avoid selector ambiguity so that the DBMS doesn't scream at you. Cause that's the last thing you need happening. Crazy DBMS's.... shesh.

jim - 03/12/08 22:00
Structured Query Language, it's relational calculus - math for interrelated data sets.

So you could select all entries that have a username of felly:

SELECT * FROM users WHERE username='felly'

But it gets more complicated then that when you need to retrieve/update results from across multiple tables of data.

fellyconnelly - 03/12/08 21:51
Super Queer Lesbians?
Simply Quiet Lasers?
Sandy Quests Lust?
Sadley Quaint Losers?

i could go on....

jim - 03/12/08 17:39
It went really well, 15 people I think. I ended up finding my new job via the last Ruby meetup, so I'm really happy to be involved in it. I present at all of them - playing at teacher ;)

carolinian - 03/12/08 17:36
Oh sh*t, I missed the Ruby meeting. How did it go?

carolinian - 03/12/08 17:32
So no going nuts and doing stored procedures and custom aggregates anytime soon?

jim - 03/12/08 17:31
SQL is fine, I'm just not used to writing complex queries anymore.

paul - 03/12/08 17:02
You hate SQL or your atrophied ability?

03/11/2008 21:41 #43624

1 job down, 2 jobs to go.
Category: work

OK, my one contracting job seems like it's done. Now I've just got my new full time job (going super well so far, 2nd week in) and some part time at-home contracting stuff to Roswell to work out tomorrow. And a ton of email to catch up on. Oh and I'm out of town for a week in a week. Hmmm... forgot about that. Programming conference in SLC and then visiting family for a few days. Still busy then. Oh well.

But basically, things are sweet! Light at the end up the tunnel? Can't wait for spring: take more photos, get out of the house more... yuck, cabin fever. Plus, it's my birthday at the start of April so ... 29. Seems like it'll be a good year. Get a house I hope.

Gotta go, have a good night everyone.

fellyconnelly - 03/12/08 09:15
spring makes me a happy happy fellyy

drew - 03/12/08 00:05
I'm with you in the spring hope. Glad things are going well.

03/04/2008 23:25 #43557

New Job
Category: work

I love my new job so much.

That's all. OK gotta sign off. Peace :)

mrmike - 03/05/08 10:19
Very cool. Safe enough to bring in desk toys yet?

fellyconnelly - 03/05/08 09:54
awesome! did you dress up your cubicle yt?

paul - 03/05/08 09:08
awesome

ladycroft - 03/05/08 02:00
Hurray!

03/02/2008 11:36 #43528

Flight of the Conchords

Now an HBO series

The Humans are Dead

Hiphopopotamus vs. Rhymenoceros

Bowie in Space

fellyconnelly - 03/02/08 17:41
uhhhhhh.... wow...
thats ah.. motherflippin... somethin...

my jaw was dropped for a bit there..

i like the second one the best tho!

03/01/2008 12:11 #43520

Too Awesomely Something...
Category: lawl

This book is available on Amazon: Cube Chic

fellyconnelly - 03/02/08 08:35
i wonder how productive the fur desk would be? but really i am serious about building myself a cubicle just so i can dress it up!

lilho - 03/01/08 15:38
thats amazing. but how would your boss feel?

paul - 03/01/08 12:24
Wow, I never thought of dressing it up really.