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

Welcome to the 201st edition of Log Buffer, the weekly review of database blogs. This is my third time writing one of these carnivals and I’ve enjoyed it every time. Writing a blog carnival (like Log Buffer) will open you up to a world of bloggers – - as well as an awful lot of new and useful information. I don’t always have the luxury of reading all of these blogs every week, but after putting together a Log Buffer I always think that I should take more time to keep up with these blogs… or at least read all of the blogs covered in each weekly Log Buffer… well, anyway, let’s get to this week’s blogs!

DB2

We begin this week in the realm of DB2.

Trevor Eddolls, in his Mainframe World blog, opines about the speed of DB2 in his latest blog entry, DB2 – faster than a speeding bullet? His missive covers IBM’s latest benchmarks results in which IBM claims to have achieved the industry’s highest ever TPC-C benchmark using a Power Systems configuration with DB2 to provide performance in excess 10 Million Transactions Per Minute.

Willie Favero, in his Getting the Most out of DB2 for z/OS and System z blog reminds us to update to the latest version of the DB2 documentation (Have You Downloaded the Newest DB2 9 Documentation?).  Willie was busy this week, because he also blogged to remind everyone to Sign-up for IBM’s Terry Purcell webcast about DB2 10 Optimization.

Troy Coleman in his DB2utor blog explains the difference between Object Creator, Schema, Qualifier and Owner. If this has ever confused you, Troy’s blog posting will clear thing right up for you.

Vikram’s DB2 DBA Diary blog offers up some good information on PRIQTY and SECQTY Calculation for a Tablespace.

Over at my DB2portal blog you can read about an upcoming series of educational DB2 webinars in the appropriately titled post Free DB2 Education Webinar Series.

And the DB2usa: Blog about DB2 for z/OS alerts us that IBM just published a draft version of a new Redbook, DB2 9 for z/OS and Storage Management.

Finally, at least for DB2, Susan Visser’s Build your Skill on DB2 blog compiles all of her DB2 certification-related posts for our enjoyment.

Oracle

Next up is Oracle.

And we see that certification seems to be a “top of mind” issue this week. We start off our coverage of Oracle with Duke Ganote’s Data Ruminations blog, in which he talks about his experience messing up his weekend Taking the Oracle SQL Expert exam (Exam 1Z0 047). He passed, so I guess we now have another grumpy Oracle expert in our midst.

And remember all you Oracle-ites that Oracle OpenWorld is just around the corner. With that in mind, Aaron Lazenby, editor-in-chief of Profit magazine, offers up his Oracle OpenWorld 2010 Session Recommendations.

And the good folks at Pythian announce the Bloggers Meetup @ Oracle OpenWorld 2010. This opportunity offers folks who only “see” each other online a chance to interact face-to-dace. Nice…

Anthony Shorten on The Shorten Spot blog keeps us abreast of the latest Oracle fix packs in his post this week titled Single Fix Lists in Service Packs.

James Morle’s Blog contains an interesting post titled Serial to Serial – When One Bottleneck Isn’t Enough. It documents the process of tracking down and resolving a storage-related performance problem on a Linux-based Oracle implementation using Fibre Channel attached to an EMC DMX storage array.

Kevin Clossen follows up on his previous post regarding a Do-It-Yourself Exadata-Level Performance! This week he informs us that his quest to speak on the topic at Oracle Open World was in vain.

If you are interested in writing a book about Oracle be sure to check out Syed Jaffar Hussain’s Oracle Blog posting titled Interested in writing? Here is your chance. Packt Publishing is planning to expand its catalog of Oracle books and is currently inviting Oracle Fusion Middleware experts interested in becoming published authors to get in touch.

And Kerry Osborne’s Oracle Blog provides some details on his attempt at Running Oracle Exadata V2 on Dell Hardware.

SQL Server

We also have some interesting and informative blog posts in the world of Microsoft SQL Server this week.

Let’s begin our coverage with the SQL Aloha blog, by the estimable Brad McGehee. He discusses SQLSaturday and the useful Information on SQL Server Storage Systems he learned by attending it.

Simon Sabin over at Simons SQL Blog is promoting the SQLBits event, noting that there will be 20 MVPs and 4 former MVPs at SQLBits.

Paul Randal, in his In Recovery blog, announces a 5 day BI Immersion Event in Bellevue, WA in October! The course will be taught by well-known BI expert, Stacia Misner.

And Aaron Bertrand writes about his experiences with  SQL Server 2008 R2 Best Practices Analyzer in the SQLblog.com.

MySQL

Over in the land of MySQL, Xaprb muses on bugs reports and asks readers What are your favorite MySQL bug reports?

The MySQL Performance Blog investigates an interesting customer crash report regarding InnoDB memory allocation, ulimit, and OpenSUSE.

Andrew Morgan’s MySQL Cluster Database Blog points out that the MySQL Cluster 7.1.5 binaries have been released, so grab ‘em if you want ‘em.

Additional Data-Related Blogs

And because I am a firm believer that DBAs need to understand not only the technical aspects of the database systems they manage, but also must be business and content savvy, here are a few intriguing data-related blog posts.

The Obsessive-Compulsive Data Quality blog (or OCDQ for short), which focuses appropriately enough on data quality issues, reminds us this week that The Real Data Value is Business Insight. The author of the OCDQ blog, Jim Harris, talks about the importance of meaningful metrics and beginning any data analysis with business decisions in mind, instead of focusing solely on the data.

And I have to plug one of my blogs, Data and Technology Today (which just so happens to be the blog you are reading this Log Buffer on). This week I posted Web Resources for Data Management Professionals outlining a wealth of useful sources for DBMS information on the web; and also a post on the current technical books I’ve been reading titled My Current Reading List.

And finally, we get an analysis of “Big Data” from Fern Halper’s data makes the world go ’round. This interesting post talks about the growing trend of analyzing huge amounts of data (terabytes and even petabytes) using technologies like MapReduce and Hadoop.

In Summary

Thanks for taking the time to read this week’s Log Buffer. I learned a lot putting this week’s edition together. Hopefully you learned a thing or two, as well.

And be sure to come back to Log Buffer each and every week to keep up-to-date with what is going on in the DBA blogosphere.

About these ads

About datatechnologytoday

I'm a strategist, researcher, and consultant with nearly three decades of experience in all facets of database systems development.
This entry was posted in DBA. Bookmark the permalink.

4 Responses to Log Buffer #201, A Carnival of The Vanities for DBAs

  1. Pingback: Log Buffer #201, A Carnival of the Vanities for DBAs | The Pythian Blog

  2. kevinclosson says:

    Thanks for picking up my post. I need to direct your readers to the latest inforamation on the topic though:

    http://kevinclosson.wordpress.com/2010/08/26/whats-really-happening-at-openworld-2010/

  3. I always inspired by you, your opinion and attitude, again, appreciate for this nice post.

    - Norman

  4. crazy software says:

    Great blog, not later than fellow that wrote so often. The power factor that writes to-date information :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s