Here’s something to help you kill another 53 seconds of your Friday. David Leterman gives Microsoft’s Bill Gates a fitting tribute:

Not quite as funny as Bill Gates having Windows crash on him durring a major presentation, but still damned funny.

Thanks to Don Burleson for sending this along to me.

funny, funny video, bill gates, microsoft

Tabs in Google PortalAt long last Google has added tabs to their portal layout! This is awesome for guys like me who have more RSS feeds than screen realestate.

Check it out at Google. It looks like you might have to customize the initial page before you get the option for tabs.


google, portal, rss

Satya commented on my post about finding the first or second Monday in a month asking how to find the last Saturday of a year using SQL. This is a good question as I think it is typical of the battles people fight with dates in Oracle.

So here we go… For this example we’ll use sysdate but you can use a date column or a to_date instead.

SQL> select sysdate from dual;

SYSDATE
---------
13-SEP-06

Now we’ll jump forward a year and start working backwards:

SQL> select sysdate+numtoyminterval(1, 'YEAR') from dual;

SYSDATE+N
---------
13-SEP-07

Now that we’re safely into next year we’ll reel it back to January 1st of next year using the trunc function to truncate the date down to the year.

SQL> select trunc(sysdate+numtoyminterval(1, 'YEAR'), 'YEAR') from dual;

TRUNC(SYS
---------
01-JAN-07

To work with the last week of the year we’ll go back 8 days. We need to go back 8 instead of 7 because we’re going to use the next_day function later which only looks after the date it is passed.

SQL> select trunc(sysdate+numtoyminterval(1, 'YEAR'), 'YEAR') - 8 from dual;

TRUNC(SYS
---------
24-DEC-06

Now we use the next_day function to look for the next Saturday after the date we’ve got.

SQL> select next_day(trunc(sysdate+numtoyminterval(1, 'YEAR'), 'YEAR') - 8, 'SATURDAY') from dual;

NEXT_DAY(
---------
30-DEC-06

So we figured out the last Saturday of this year by taking today’s date, adding one year, going back to January 1 of that year, stepping back 8 days from then and looking for the next Saturday.

Hope this helps Satya! Thanks for the great question.

oracle, dates, database, sql, dba, dbms, database development, database programming

Apple's Xserve RAIDIt looks like Oracle has decideded to adopt Apple’s XServe RAID as a low-cost storage solution

Based on our own experience with Apple technology, Xserve RAID is a great match for applications running Oracle.

With the appetite of one to two petabytes annually Oracle is of course looking to control costs and the SATA-based Xserve RAID combines value, capacity, performance and availability. The current top configuration offers 7000GB on dual RAID controllers with redundant power and cooling for a mere $12999. Sure that’s the price of a small car, but it works out to only $1.86/GB for some serous industry-level storage.

Thanks to Zach for sending this on to me.

apple, oracle, xserve, raid, xserve raid, storage, disk, hard drive

Happy Birthday LAC!As someone who’s birthday happens to be September 11, nobody has hit it on the head quite like America’s Finest News Source The Onion in their article from the first aniversary of the World Trade Center attacks.

“My birthday’s gonna suck for the rest of my life,” Bachman said on the eve of his 29th birthday. “Every year, I’m going to want to go out and have fun, but it’s always going to be inappropriate in light of the meaning of this most tragic of days.”

“It’s probably going to be at least 10 years before I can get back to celebrating like a normal person.” Bachman said. “Then again, that 10th anniversary of the attacks should be a pretty big deal, too. Fuck.”

Personally I’ve never made a big deal out of birthdays, but for everyone else out there with a 9/11 birthday please accept my unreserved “Happy Birthday!”


9/11, september 11, the onion, world trade center, birthday

« Previous PageNext Page »