Log Buffer #217, A Carnival of the Vanities for DBAs
Apr 24, 2011 / By Fahd Mirza
Clouds are dispersing and the sun has started shining through. On the IT horizon, the cloud of Amazon has also dispersed and that is the biggest news of the previous week. Well clouds are elastic and they congregate and become solid after dispersion, and so Amazon will be fine too. And our blogosphere is fine too and here is the latest report about them in this week’s edition Log Buffer #217.
Arup Nanda asks. You want to find out the tables with the highest number of rows in a database. Pretty simple, right?
Jonathan Lewis blogs about as how to ensure that you never give the wrong answer.
Jonathan Lewis gives another great example of how it was possible to find queries which ran faster if you manually de-coupled the index and table accesses.
Charles Hooper lists down five awesome points about as what to do when performance problem appears. He posts a nice scientific blog about it.
The 17th of may 2011 Planboard is organising the 6th version of the Planboard DBA Symposium. The symposium is a whole day event, in Amstelveen near Amsterdam, Frits Hoogland tells us.
Solving concurrency problems are a large part of troubleshooting. Michael J. Swart presents a new way to examine blocked process reports.
Melissa Coates, the sqlchick explains what are Master Data Services and also lists down some fine resources for learning MDS.
Chris Webb imagines about turning a natural user interface project into data mining in the cloud, but also notes down that its a long shot still.
When it comes to the success and very holding of a tech conference, a lot depends on finding the right location; good location = more attendee seating = more sponsor funds. Stuart Ainsworth starts discussing it with a small group.
Mike Hillwig discovers the runas command to clear a hurdle which arose from complying with Sarbanes-Oxyley 404, better known as SOX.
In a non-tech post, Marlon Ribunal talks about a great guest post by Richard Branson about Habit for Success.
Jon Haddad tries once again his hands on Python. And summarizes his journey through seven languages in seven weeks.
In the process of building a new benchmark tool for Yahoo, Partha Dutta needed a good “guinea pig.” She thinks that she has found the one by showing how much more powerful covering indexes can be with InnoDB.
One of my favorite blogger, Pythian’s Marco Tusa blogs about his afterthoughts on teams compose by multi-cultural, multi-language elements, in consulting and support.
Ronald Bradford describes basic scalability principles to avert downtime in the wake of reported outage of Amazon Web Services Elastic Compute Cloud (EC2) in just one North Virginia data center.
In his open source tech rumblings, Ovais Tariq makes few notes on InnoDB PRIMARY KEY.