Log Buffer #194, A Carnival of The Vanities for DBAs

Posted in: Technical Track

We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

Now on to our weekly reading in Log Buffer #194:

Oracle Exadata is a topic that is getting hotter and hotter. Following Pythian’s announcement of Exadata services Oracle’s Greg Rahn stresses how important it is to “capitalize on the opportunity to re-engineer with Exadata and fully exploit the power of the Oracle Database Machine platform”. Also speaking of Exadata, Kerry Osborne talks on his blog, about the Oracle 11g Release 2 new feature, Parallel Queuing, and how it applies to data warehousing workloads on Exadata. Marc Fielding begins his grand tour of Exadata, writing to share his implementation experience.

Jamie Thomson outlines a number of reasons why a SQL server or BI developer should learn .net. And with more activity on SQLblog.com, Jonathan Kehayias writes about a bug in SQL Server 2008 and why you shouldn’t create large tables in the Model Database.

On In Recovery, Paul Randal posts on Benchmarking: Introducing SSDs (Part 2 – Sequential Inserts), following his first set of tests and analysis of the results. In Part 1 and Part 1b he covers not overloaded log file array.

Willie Favero addresses the demise of private protocol, one last time (he hopes) on his blog Getting the Most out of DB2 for z/OS and System z.

Ronald Bradford posts a quick one on installing MYSQL on Oracle Enterprise Linux and other good advice for optimizing SQL performance using the art of elimination.

Barry Leslie announces PBMS is now in the Drizzle tree.

And to sum things up, Gwen Shapira shares a few of her favorite recent archives, a little older than our weekly news, but valuable nontheless.

Not strictly a database topic, but certainly an important lesson for data architects. Brian Carper shares the difficult life of an edge case. Keep him in mind next time you develop an online shop. The same Brian Carper shares why he migrated from MySQL to NoSQL (Tokyo Cabinet) and why he moved back to SQL (Postgres this time).

Joshua Drake warns the end of life is near for Postgres 7.4, 8.0 and 8.1 and that anyone using these versions should upgrade.

Jonathan Lewis explains the difference between unrecoverable and nologging operations.

Martin Widlake gives an overview and demonstration of a little know view, DBA_TAB_MODIFICATIONS.

And, lastly to close things off on a light note, Iggy Fernandez highlights some of his favorite Dilbert-on-Databases Cartoons.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

VP Business Development
Vanessa is an experienced business development professional with over 15 years’ experience in all aspects of the business development and marketing disciplines. She brings endless energy, drive, and a results-oriented approach to creating Pythian’s strategic partnerships and business initiatives. In her spare time, Vanessa pursues her passion for great food, wine, and artisan cheeses as an accredited Cheese Sommelier and Cordon Bleu-trained chef. Her weekly Friday afternoon cheese tastings at Pythian’s Ottawa office aren’t to be missed!

No comments

Leave a Reply

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