Log Buffer #207, A Carnival of the Vanities for DBAs

Posted in: Technical Track

Everyone loves the colorful and easy lighting fire logs you can buy in the store for between $3-5, and from our feedback we are savoring the fact that everyone also adores the vibrant and flamboyant Log Buffer.

Winter has started and the holiday season is approaching fast. With the chillness of winter and festive mode induced by the holidays, bloggers across the planet are coming up with more and more exciting ideas. Let’s start with sizzling Log Buffer #207.

Oracle Jewels:

Discussing the common errors by the DBAs, Hemant K Chitale from Oracle Singapore advises against blindly killing sessions.

Cellcli, an Exadata utility which is used to manage Exadata storage, is another hot topic of the week. Kerry Osborne sheds light on it here, and Pythian Blog here.

A very lucid, reproducible example about Index Joins has been put on display by Jonathan Lewis. It’s a compact introduction about Index Joins, which are also known as Index Hash Joins.

How much disk do I need for my new Oracle database? This is the question,one of my favorite blogger Martin Wildake asked and answered in his blog post. He is also an Oakie now, and even secretly doesn’t think that he deserved it. Congrats Martin, you really deserved it.

A Crisp and cool overview of Execute Queues and Work Managers in Oracle Weblogic servers has been provided this week by the Weblogic Wonders blog.

SQL Server Pearls:

Melissa Coates, the SQL Chick, throws light on the usage of variables, expressions and the custom code in his recent blog post and how they work in harmony in the SQL Server Reporting Services.

There is still not much information available in documentation or elsewhere on Reporting Services administration via scripts, but David Levy, so graciously provides a very useful script to change SSRS Report credentials with Powershell.

Pinal Dave on his weblog shows how to do concatenation in SQL Server. Its different than in Oracle and MySQL, and those small differences are always a challenge for beginners even when the solution is very simple.

Venkatesan discusses the composite primary key in SQL Server on his blog with screen shots.

Geekblogger presents some new and very useful SQL Server functions for DBAs and the programmers here.

MySQL Gems:

Shlomi Noach shed a positive light on mysqldump in response to Morgan’s blog post. Even though he agrees with some of Morgan’s arguments.

There is a good review of MySQL High Availability book by Simon Mudds on his blog.

Anders Karlsson releases a MySQL Plugin for MySQL 5.5 that allows to monitor the most recently executed, and the most frequently executed statements using 2 INFORMATION_SCHEMA tables.

Mark Callaghan elaborates on salient points about an interesting question as how are Index-Only scans implemented in InnoDB.

If you want to know or refresh the basics about moving from MyISAM to Innodb or to XtraDB, then this blog post is a good piece to look at.

NoSQL Ornaments:

Alex Popescu discuss about the options of running NoSQL and SQL in the cloud in a very easy manner.

Dan Pritchett says it all from the Engineering Mantra: NoSQL, SQL, Is that the Question?

CAP Theorem is another getting-hotter-by-day among many bloggers and Michael Stonebraker dishes out his take.

Jonathan Ellis expounds on the business requirements for the drive to find alternate data management solution to tackle the challenge of rapidly increasing data volumes in his post.

DB2 Flowers:

Adam Gartenberg blogs about as how companies are finding value in the Analytics. He presents some interesting statistics from the surveys.

Dan Krook wrote a brief overview of an article series that Mark Nusekabel, Yan Li Mu and he wrote about their experience migrating a large PHP and MySQL.

Dave Beulke appreciates that DB2 10 Security improves Java Performance in this blog post.. Its a good discussion about ROLES-based security model.

Well, That’s all for this week. Thanks for stopping by.



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

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

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