Log Buffer #207, A Carnival of the Vanities for DBAs
Nov 26, 2010 / By Fahd Mirza
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.
Discussing the common errors by the DBAs, Hemant K Chitale from Oracle Singapore advises against blindly killing sessions.
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.
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.
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.
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.