I work with a lot of SQL at Jobster, and often times it is not formatted in a human-readable way. For example, if a query causes an exception, the offending SQL is listed without line breaks. A SQL formatter is especially helpful in these cases, and I use a free web-based formatter [...]
Monthly Archives: February 2006
Feb 27
What’s in a Name?
My Google Alerts subscription for the keyword “Jolma” seldom yields interesting results. This morning was different. Read All the Rev on Jolma.
Feb 25
Jobster Modelling
How do I define myself? Am I a Jobster developer or a fashion model? My employment contract prevents me from sharing code samples, but I can provide some of my modelling work.
Jobster recently ran an ad campaign and needed some beautiful faces to fill out a crowd scene. Laurel, Joe and I [...]
Feb 24
Occidental Park Renovations
I have a love hate relationship with Pioneer Square and Occidental Park, upon which our offices look. Pioneer Square has the potential to be an amazing neighborhood. It is historically rich, boasts beautiful architecture and is located in the heart of the city. It feels like “Old Seattle.”
Unfortunately, Pioneer Square is [...]
Feb 22
Approaching Kevin
My life-long dream of meeting Kevin Bacon approaches fruition. KBac and I are no longer six degrees away, claims this Economist article, but 4.6. With time and more meet-and-greets I will some day be best pals with the star of Enormous Changes at the Last Minute.
Feb 21
Comment on Presidents Cannot Ruin My Morning by: joe
I did the same thing! I also waited at my bus stop for 20 minutes before realizing that I should have been reading the Sunday schedule.
Feb 21
Presidents Cannot Ruin My Morning
I have a deep respect for United States presidents, both living and passed away. But I do not like the unrepentant mayhem they inflicted upon my morning routing.
I woke up at the crack of dawn (7:00) very proud of my discipline. After starting up my brain with a hot shower I proceeded to [...]
Feb 18
Annoying SQL error
We are seeing an intermittent SQL exception on our production database when performing a simple query:
select body
from foo
where id = :id
The helpful error message:
ORA-17110 execution completed with warning
foo.id is a CLOB. This doesn’t repro in SQL*Plus but does when using our JDBC driver. And we’ve been using the same driver and similar queries [...]
Feb 12
Football Withdrawl
The NFL football season is my favorite time of year, and this season was especially enjoyable for me. Not only did I utilize my plasma tv to the fullest every weekend, but I had the pleasure of watching the Seahawks pull together an excellent year. I expected another season of underachieving but was [...]