The time has come once more to find out what bloggers in the wider worldof Information management are up to as I host Log
How do you survive when you are new to a DBA job? Keep a journal of aquired
knowledge is an example of Julien Lamarche's sage advice in
href="http://www.pythian.com/blogs/345/tips-for-the-new-dba">Tips for the New DBA. Couldn't agree more, and
lately it has become easier, I might rephrase this as "dump any useful information you learn into a Wiki".
Expect those MySQL guys to be glowing with fitness next time you see them.. Kaj Arnö has a report on the
href="http://www.planetmysql.org/kaj/?p=94">MySQL Global Sports Day, also documented complete with movie by Ronald in Technical Notes and Articles of Interest.
Is enabling autocommit the same as disabling transactions? No, explains Roland Bouman in
and Autocommit with some clear guidelines of when you would, and would not want to use autocommit.
Does MySQL have a community release? Peter in the MySQL
Performance Blog sees the recent MySQL 5.0.37 as the first
real Community Release because it contains community contributed features, unlike previous versions which came from the Enterprise MySQL source tree.
Be aware of some MySQL auto incrememt gotchas warns Eric Bergen in
auto increment ids outside of mysql - a well written explanation of the feature and potential problems. I like
his blog tagline: You will probably want some waders, a pick axe, and one of those hats with a light on it
before you go in here.
Today's web technologies like LAMP, AJAX and Ruby will become tomorrow's enterprise
infrastructure says Steve Curry, the director of corporate communications at MySQL quoted in an
interesting Reg developer article asking
href="http://www.regdeveloper.co.uk/2007/03/18/mysql_enterprise_fit/">is this database fit for the enterprise?
The Informix Zone announces the next Cheetah Open Beta Drop
is available with some cool new features like Label Based Access Control. The Zone also has its usual
thorough review of therecent Integrated Data Solutions for IBM IDS Cheetah Chat with theLabs.
The new Informix team blog IDS Experts begins
a two part article on
href="http://www.ibm.com/developerworks/blogs/page/idsteam?entry=tracing_sql_in_cheetah_part&ca=drs-bl">Tracing SQL in Cheetah, and also informs us that
href="http://www.ibm.com/developerworks/blogs/page/idsteam?entry=support_for_truncate_table_in">TRUNCATE TABLE is
now supported in Enterprise Replication.
In IBM's other database.. Willie's Getting the Most
out of DB2 for z/OS and System z blog reminds us that
href="http://blogs.ittoolbox.com/database/db2zos/archives/db2-9-for-zos-went-ga-today-15146">DB2 9 for z/OS has
The DB2UDB.com compiles a useful list of DB2 SQL Cookbook Downloads Page with brief reviews.
How do you get directly into shared memory on DB2? With db2pd of course. Read Chris Eaton's
description of how touse db2pd to
In the world of Oracle, Alex Gorbachev has a nice write up complete with pictures of his
href="http://www.pythian.com/blogs/406/review-of-hotsos-symposium-2007">visit to the Hotsos Symposium 2007
ealier this month in Dallas - that's an Oracle performance conference in case you were wondering. Oracle
performance gets some analysis in Gaurav Verma's post: A Performance Case Study: Taming the
Workflow Purge which looks at in depth at I/O performance.
So how much Oracle do you think you know?
href="http://blogs.ittoolbox.com/database/solutions/archives/test-your-dba-smarts-15219">Take the quiz
suggests James F Koopman in An Expert's Guide to
Don't you hate it when you accidently delete $38 Billion worth of data and your restore fails? Several
bloggers picked up this story, including the Eye on Oracle blog which reminds us
href="http://eyeonoracle.blogs.techtarget.com/2007/03/20/this-is-why-to-test-your-backups/">This is why to test
your backups! Another sorry tale of bad and expensive things is recounted in
Dizwell's blog, a first person account entitled
href="http://www.dizwell.com/prod/node/628">The only issue.
That is all for this week's Log Buffer. Normal service will be resumed next week.
Log Buffer #37
gbowerman 100000B5T0 1,900 Visits