Log Buffer #77: A Carnival of the Vanities for DBAs

Posted in: Technical Track

Welcome to the 77th edition of Log Buffer, the weekly review of database blogs.

This is the last Log Buffer of 2007. . . a time for looking back at the year, looking ahead to the next, and generally focusing on time.

It may not be the Oscars, but Firebird News is thrilled that Firebird is Sourceforge’s Project of the Month for December 2007.

It’s time for magazine updates. The International Informix User Group has put out the 2nd edition of Developer’s Desktop, the free monthly HTML newsletter for IDS Developers. PostgreSQL DB News is excited to find the inaugural issue of the Postgres Online Magazine, available in HTML and PDF formats.

Even though there’s a lot of end-of-year musings, there are plenty of informational articles, and this week many are DBMS independent! Jeff Davis starts a discussion about Database Formalities. Daniel Krook shows us how to save time with Instant XML feeds via the JSTL SQL tags, which I believe is DBMS independent. Adam Machanic talks about saving time by coding with a different algorithm in Tumbling Data. Jeff S. saves precious calculation time by Simplify[ing] SQL with Variables and Derived Tables. If your data warehouse has been running for a long time, Jag Singh can show you how to make better use of tables in Range Partitioning Large Database Tables.

There are, of course, DBMS-specific article as well. As Father Time closes another year, MySQLers seem to be focused on, well, time.

How I patched InnoDB to show locks held is how Baron Schwartz sees locks….which can, of course, lead to queries waiting for locks. The MySQL Performance Blog explains the longest part of the InnoDB Recovery Process. Brian Aker has been able to make better use of time with the improved libmemcached, Callbacks faster.

Alexander Kornbrust answers the question Are Oracle Rootkits Easy to Find? Tanel Poder shows how to handle Reading the name of currently executing script in Oracle. Postgres OnLine Journal teaches how to perform CrossTab Queries in PostgreSQL using tablefunc contrib. Another Postgres recipe is Hubert Lubaczewski’s How many 1sts of any month were Sundays – since 1901-01-01? Your end-of-the-year challenge is to leave a comment with your best guesses on the fewest changes necessary to the recipe to determine how many Friday the 13th’s there have been since 1901-01-01 (I promise to leave a comment here in a week’s time with my answer).

As for end-of-year roundups, DB2 Magazine’s Kim Moutsos posts the Most Read 2007 Articles: DB2 and Informix. OTN Techblog has a similar post about the Most Popular Technical Articles of 2007, though only 2 of the 10 were posts made or updated in 2007. Vincent McBurney’s Tooling Around on the IBM Information Server brings the The 2007 data integration flashback to the table. Nicholas Goodman geekily proves with figures and graphs that 2007 was a desert of Blogging for him.

Looking to the future, Frank Buytendijk uses some creativity to predict The Future of IT: Search. Kaj Arno announces that the 2008 MySQL User Conference Registration Opened. And if you Want to use MySQL 5.1? A Bug List Made For You… by Jay Pipes. If you are still stuck in the past, you can read about Keith Murphy’s experience Upgrading from 4.1 to 5.0. Or, if you’re already living in the future, you may want to read Rajender Singh‘s article on How to find a trace file Oracle 11g. Curt Monash does not think the future of DBMS is Amazon SimpleDB.

451 Chaos Theory not only touts the value in source code, whether you want it or not but proves one of their points — that the value in open source is that it can go on even when the originators of the code change — when writing MySQL in the firing line again as IBM snaps up SolidDB.

Starting with the official announcement IBM to Acquire Solid Information Technology to Broaden Information on Demand Portfolio, there were a flurry of posts about the acquisition. Curt Monash‘s suggestion that IBM acquires SolidDB to compete with Oracle TimesTen. Matt Asay pointed out the MySQL trivia: IBM acquires a piece of Marten Mickos’ past, and also that the panicking is not warranted in MySQL under siege and the likely need to “roll your own” open source.

MySQL is certainly no stranger to coding, and Johannes Taxacher notes in MySQL workbench developer central that the MySQL Workbench 5.0.11 Beta out.

This Log Buffer will end with another series conclusion, as well as the first New Year’s Resolution for 2008. Oracle Doug reminds us that telling the truth is “one of the most powerful weapons you can wield in the IT Systems arena”, in the Conclusion to his 5-part series on The Reality Gap (part 1, Software Maintenance, part 2, Disaster Recovery, part 3, A Single Instance Per Server, part 4, It’s Never the SAN).


Interested in working with Sheeri? Schedule a tech call.

3 Comments. Leave new

Denis The SQL Menace
December 28, 2007 12:44 pm

I am not one to bash but the Postgres OnLine Journal has to be one of the ugliest sites I have ever seen. My eyes literally hurt after clicking on the HTML version (http://www.postgresonline.com/periodical.php?i_id=1)


hmmm, don’t know postgressql, but here is my attempt in oracle, runs pretty fast me thinks. If i supress termout it ran in about 380370 microseconds on my 10203 db.

select systimestamp from dual
set termout off
with x as (select TO_DATE(‘19010101′,’YYYYMMDD’) s from dual)
select x.s + y.l, to_char(x.s + y.l, ‘Day mm/dd/yyyy’)
from x, (select level-1 l from dual connect by level < (trunc(sysdate) – TO_DATE(‘19010101′,’YYYYMMDD’))+2) y
where to_char(x.s + y.l,’DYDD’) = ‘FRI13’
set termout on
select systimestamp from dual

HTH and have a great year.


As promised, the answer:

The number of Friday the 13ths is exactly the same as the number of months where Sunday is the 1st of the month. Therefore, there are no changes needed to the script at all!


Leave a Reply

Your email address will not be published. Required fields are marked *