Log Buffer #130: A Carnival of the Vanities for DBAs
Jan 9, 2009 / By David Edwards
Welcome to the 130th edition of Log Buffer, the weekly review of database blogs.
On the Oracle DBA and Apps DBA blog, Sabdar Syed also has a question: how important is having Unix/Linux OS Knowledge for Oracle DBAs?
Tom Kyte is watching another question: what is the worse design decision that you have made? Tom’s was the EAV, or “funky data” model, and there are other confessions in the comments.
In her post Save a DB – Practice Restore Today, Chen Shapira makes note of Tom’s New Year Resolutions, particularly, “Practice restore every month”. She has on offer seven tips for the aspiring restore practicer.
SQL Server Blogs
That’s excellent advice, Chen, but where was it when JournalSpace needed it? Simon Sabin says, “Its shocking how many people don’t even do the basics of ensuring your data is protected.”
Denis Gobo also treats of this problem in his post Will we need many DBAs or no DBAs at all in the future? Denis writes, “On one hand there is the â€˜cloudâ€™ which will take our precious boxes away from us and we wonâ€™t be needed to manage it anymore. On the other hand is an avalanche of technologies bundled with every release of SQL Server.”
Schlomi Noach asks, Do we need sql_mode?, beginning, “sql_mode must be one of the most [elusive] issues in setting up a MySQL database. It is also responsible for difficulties in migration, upgrading and securing of databases.” Among the comments, Brian Aker says, “sql_mode was one of the first things tossed in Drizzle. It was a horrible idea to begin with and it just kept making everything worse.”
Here’s Kaj Arno looking back at his travels in 2008, with some assistance from a database-backed application, Dopplr. Mike Kruckenberg writes about his upcoming trip to Ireland, using a database-backed application, Google Maps, for vacation planning. Oh, and here’s an item from Newsweek’s Budget Travel’s Blog on the US’s Homeland Security’s files on travelers, which you may be sure, are stored in databases. This is the business we’re in. It’s worth thinking about this stuff from time to time.
On tending the garden, Selena Deckelmann issues the following exhortation: What are you waiting for? Get your PgCon talks in now! Hey, it’s right here in Ottawa—you could drop by Pythian HQ while you’re here. Selena writes, “Ottawa was beautiful last year, and I canâ€™t wait to go back this May!”
That’s all. Sorry, everyone, for being so late this week. Please leave your favourite blogs from this week in the comments, or send me an email if you’d like to publish an edition of Log Buffer yourself. Till next time!