Log Buffer #232, A Carnival of the Vanities for DBAs
Aug 5, 2011 / By Fahd Mirza
These days products based on the database technologies are getting hatched with the speed of light. From the giants like Oracle and Microsoft to the start-ups, there is an army of products which is growing by the week. It’s become hard to remain abreast of all these technologies, but thanks to blogs, we get the latest and greatest news. This week’s Log Buffer in its Log Buffer #232 has lumped some interesting posts together.
World’s premier Oracle Expert Jonathan Lewis blogs about not-so-easy question; How do you trouble-shoot a problem?
If you haven’t heard – another world’s greatest Oracle expert Tom Kyte is participating in a series of seminars entitled “Real World Performance”.
Glenn Fawcett shares that Linux has taken a page from Solaris and pmap is available now on Linux.
Randolf Geist gives a short heads-up note to those dealing with HCC-enabled tables.
Tim Hall gives a spoiler alert. He blogs about Ghost Story is the latest book in The Dresden Files series by Jim Butcher.
Do you know when your users are using the production login accounts from their workstations? Are you aware of changes being made to the development servers that may impact future deployments? Has the new Junior DBA start giving out access like candy? Andy Lohn talks about a presentation.
If you are a SQL expert who only works on the same database for the rest of your life who will never type the wrong field name in a query then yes you are the fastest query writer your company could ever have. Pinal Dave has more.
Vishal shares an easiest way to compare two tables is by using UNION, EXCEPT and INTERSECT operators.
Klaus Aschenbrenner is presenting 2 sessions at the SQLbits conference in Liverpool (http://www.sqlbits.com) from September 30 – October 1, and shares the abstracts of his presentations.
SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous versions of SQL Server support reading metadata from system catalog but it is possible only for fixed objects. jakub.dvorak blogs.
An important part of benchmarking is to draw graphs. A graph can reveal results you wouldn’t have spotted just by looking at raw numbers. Henrik Ingo shares a One-liner for condensing sysbench output into a csv file.
Cloud Elasticity and databases are the hot topics. Mike Hogan discusses the primary reasons people are moving to the public cloud.
Using MySQL 5.6? Tell the MySQL Community Team about the new features.
Shinguz discuss how big is the performance impact of MySQL TRIGGERs compared to application side logging (with INSERT) into a MySQL table.
In life there are really two major types of data analytics. Firstly, we don’t know what we want to know and secondly, we already know what we want to know. Tony Bain has more in regard of Realtime Data Piplines.