Oracle Prefers Solaris 10

It looks like Oracle is re-aligning themselves with Sun Solaris as their preferred 64-bit platform. In the March issue of Oracle Magazine they have a short announcement on the topic:

Oracle has chosen the Solaris 10, Sun Microsystems’ multiplatform, open source operating system, as its preferred development and deployment platform for most 64-bit architectures. Solaris 10 will be used throughout Oracle’s development organization, and Oracle will release and ship 64-bit versions of all Oracle products on Solaris prior to, or simultaneously with, release on other operating systems.

Check out the whole article here or sign up to get your free copy of Oracle Magazine.

Thanks to Jon G. for sending this on to me.

oracle, database, database administration, dba, systems administration, sysadmin, solaris, sun, sun microsystems, UNIX, open source, 64-bit

Two Great Web/Graphics Design Tools

JR Screen Ruler and PixieI’m no web designer but I’ve done quite a bit of modification for this site and these two little free tools help a lot.

The first one is JR Screen Ruler. It’s a small app which does just what you see. You can place a ruler, measured in pixels, anywhere on your screen. You can have it vertically or horizontally and you can adjust the length.

This image actually shows one ruler vertical and one horizontal. It will stay on top of all open windows. There are other screen rulers out there but this one has all the features I’m looking for.

The second app is Pixie. Pixie shows you a swatch of the pixel your mouse is currently over. It also gives you the hex, HTML, RGB, CMYK, and HSV values of the color making it easy to capture the color for reproduction in your favorite app. You can even hit control-alt-c to copy the HTML value for the color you’re looking at straight to the clipboard.

Thanks again to Zach (who is a web designer) for introducing me to these tools.

development, web development, graphic design, graphics, html

EditPlus for SQL Editing and More

EditPlus in actionWhile there are many text editors out there offering a broad set of features my favorite right now is EditPlus.

EditPlus is a Windows shareware application designed for text, HTML, Java, PHP, etc. It’s very thin requiring little (nearly no) load time and has many great features such as:

  • Syntax hilighting for many languages
  • EditPlus on Windows right-click
  • FTP and SFTP integration
  • Templates
  • Line Numbering
  • Column Selection
  • Optional Spell Checker

The list of features is long and every revision brings more. Check out the Features page for more.

I’ve been using the Oracle 9iR2 syntax file from the user files section of and it seems to pick up all the SQL and PL/SQL syntax I use, although many other syntax files exist and you could always make your own.

As mentioned above, EditPlus is shareware. A single user license is only $30, and with discounts for buying in bulk there is no reason not to pay, but for now, download it, try it, and see why you can’t live without it.

Thanks to Zach for showing this to me a couple years ago.

text, text editing, editing, editor, edit, sql, plsql, pl/sql, sftp, ftp, notepad, wordpad, oracle, unix, php, perl, programming, database programming, dba, database administration, systems administration, c, c++, java, javascript, css, html

Resumable Transactions in Oracle

OracleOracleAndy, a relative newcommer to the Oracle blogging community, has a fantastic article on resumable transactions.

Here’s what Andy has to say about them:

For those of you who have not come across this feature of Oracle, it was introduced in 9iR2. It allows you to set up your session so that if a transaction hits a storage problem e.g. out of temp, tablespace is not big enough,or a table reaches max extents, the transaction is suspended. All you have to do is fix the space problem and and transaction will resume. This saves you all the time of waiting for the rollback, adding some space and starting again hoping you’ve got it right this time.

He goes on to explain in great deal how to setup for and use resumable transactions. I didn’t even know you could do this (damn lack of training budget.) Great article Andy!

database, database administration, dba, database development, oracle, sql, plsql, pl/sql

How to Figure Yearly Income from Hourly Rate

When talking with Scott, a student who is doing some database work with me this semester, the topic of hourly pay versus salary pay came up. I mentioned a simple way to estimate yearly income from hourly rate on the fly.

Let’s say you are offered a job for $11/hour. If you assume you work 40 hours a week for 50 weeks a year you can simply double the hourly rate and that will be the yearly income in thousands, so $11/hour = $22,000/year.

I figured out this method years ago when I was job hunting in college so I could easily compare hourly and salary positions. Of course you’ll want to figure benefits and possible overtime into the final decision, but this gives you a quick idea.

This method works because 40 hours per week multiplied by 50 weeks makes for 2,000 working hours in a year (assuming two weeks of unpaid vacation). Multiplying by 2,000 is the same as multiplying by 2 then by 1,000 so that’s exactly what we do.