World’s Ugliest Dog Contest – Celebrity Counterparts

After the death of Sam, the long time world’s ugliest Dog, Zach reports that the search is on again for a new world’s ugliest dog.

Zach has the full scoop on this year’s competition, put on by the Sonoma-Martin Fair, but we had a different idea in the office today.

With the help of the crew at the office I have put together celebrity counterparts for all of this year’s competitors for world’s ugliest dog. Feel free to comment with more suggestions!


archie.jpg
Archie
grandpa.jpg
Grandpa Munster
ellie.jpg
Miss Ellie
meg.ryan.jpg
Meg Ryan
lucille.jpg
Lucille Bald
john_travolta.jpg
John Travolta
munchkin.jpg
Munchkin
ron_jeremy.jpg
Ron Jeremy
oscar.jpg
Oscar
marty_feldman.jpg
Marty Feldman
pewee.jpg
Pee Wee
Anne
Anne Ramsey
(Momma from Throw Momma From The Train
rascal.jpg
Rascal
joan_rivers.jpg
Joan Riverssting.jpg
Sting (runner up)
tator.jpg
Tator Tot
yoda.jpg
Yoda
victoria.jpg
Victoria
munch_scream.jpg
Munch’s Scream

For all those who asked me, here’s the link to vote for your favorite, or perhaps least favorite ugly dog, and for more info on the contest.

There you have it. Thanks to Zach, Dee, Cliff, Erich, Ken, Matt and everyone else at the office for your help on this.

Oracle SQL Developer – A New GUI For Database Development

raptor_image.jpgAt long last Oracle has come up with a modern product to replace SQL*Plus.

Oracle SQL Developer (formerly Project Raptor) was released last month with little fanfare; however its release represents a quantum leap in functionality and ease of use over previous Oracle provided SQL development tools.

SQL Developer is Oracle’s new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer,you can:

  • Browse database objects
  • Run SQL statements and SQL scripts
  • Edit and debug PL/SQL statements
  • Run provided reports
  • Create and save custom reports

Now all these features exist in Quest Software’s product Toad for Oracle so why switch? Well, here’s the hook… SQL Developer is free. Yup, free. It also has another strategic advantage over Toad… SQL Developer is cross platform! I am currently running it side-by-side on Mac OS X and Windows XP, and there is also a Linux version available. The Mac and Windows versions are both extraordinarily easy to install, configure, and use. I can only assume the Linux version follows this trend.

So what’s the down side? Well, I’m personally disappointed that they changed the name from “Raptor” to “SQL Developer”, but that aside, you can’t use it on databases earlier than 9.2.0.1.

A small problem for Toad users will be adjusting to the date format in SQL Developer. Toad defaults to showing the time when displaying date data types while SQL Developer will only show the date. The solution to that is to add a TO_CHAR around the date column in the query (for more information on the TO_CHAR function, check out the Displaying Dates section of my article Oracle, SQL, Dates and Timestamps). Toad users may also miss being able to click on the header of a column to change the sort order of the output, but this can also be overcome by adding an ORDER BY clause to the query.

Setup was quick, taking less than a minute to download, unzip and connect (yes, one minute, you’ve probably spent more time reading this than it takes to install). As you’re setting up SQL Developer you’ll notice that it does not require a TNS Names or other descriptor file to find databases. When you set up a connection you are prompted for the hostname and SID of the database. This assures maximum flexibility but does run the risk of confusing end users, since they can nickname the connections anything they want to.

Below are some screenshots of SQL Developer, but if you’re interested, just go out and get it. It’s free after all, what do you have to loose.

SQL WindowPackage Editing


Table BrowsingReports

Click on the thumbnail for a larger image.

oracle, sql, sql developer, database development, database administration, dba

ER Diagramming Tools

While investigating tools for generating ER Diagrams for the data warehouse I’m working on I came across this good article on databasejournal.com which compares three of the top CASE (computer aided software engineering) tools for Oracle.

In the article Steve Callan quickly highlights the differences between Microsoft Visio 2003, Oracle Designer and AllFusion ERwin Data Modeler.

What can we take home from this article? Well, Microsoft Visio is (relatively) cheap at $499 and has good reverse engineering abilities, but won’t write database creation code for you.

Oracle Designer is clumsy, but since it’s bundled with Internet Developer Suite you might already own it; otherwise you’re probably not likely to justify the $5,000 cost of entry.

ERwin really seems like the Cadillac solution for database modeling. The $3,995 price tag will put off most, but like they say in the auto industry, if you’re worried about gas mileage you’re not ready for a Cadillac.

Check out the full article for details. Also check out the Oracle section at DatabseJournal.com for some nice series on Oracle related topics.

oracle, database, rdbms, dbms, oracle database, database management, database design, dba, database administration, er diagramming, case, software engineering

Chocolate Cake Shots

This elaborate recipe came to me through Kirsten’s friend Erin a few years ago.

Prepare in a shot glass:

  • 1/2 shot vodka
  • 1/2 shot Frangelico hazelnut liqueur

Slice and have ready:

  • One slice of lemon per shot

Place on a small plate:

  • Two tablespoons of sugar per shot

To take the shot take one slice of lemon, dip both sides of it in the sugar. Now lick the sugar off the lemon (don’t swallow it yet), take the shot, swallow, and bite the lemon slice.

Some people taste the chocolate when they take the shot, others when they bite the lemon, but everyone tastes chocolate cake when they try this. Just make sure you keep the order straight.

alcohol, beverage, drink, drinking, shots

The New Monkey In Town

After writing about Alan Baker’s Bar Monkey a couple weeks ago, Jack contacted me with a couple questions about a drink machine he is building.

Jack calls his device a Drinkputer and it looks like it’s going to be cool. It’s quite a bit different from what Alan and I built. Jack is using pumps instead of a pressure/valve system and his unit is intended to be small and portable.

Check out the pics of Jack’s device. He’s posted a ton of information on the parts and such. A great idea for tailgating!

bar monkey, drinks, drinking, alcohol