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

Posted in: Technical Track

The just gone-by recession (or is it still here?) taught companies to stop investing in new technology hastily and first look inwards to extract some more juice from the existing humming machines. Administrators across the database technologies find themselves at the center stage of that and they are sharing tips and tricks regarding that in their blogs. This Log Buffer Edition touches that and much more in Log Buffer #246.

Oracle:

Alexander Anokhin talks about the dynamic tracing of Oracle logical I/O.

Timur Akhmadeev wonders about 16K CR gets for UQ index scan?

Charles Hooper blogs about matching the expected output – Analytic RANK, ROW_NUMBER, DENSE_RANK, or Something Different?

Tim Hall shares a post about configuring VNC Server on Fedora 16.

Randolf Geist gives a nice example of what can happen if you attempt to use star transformation but your model obviously doesn’t really correspond to what Oracle expects.

SQL Server:

Mark Broadbent has released the compatibility Matric 1.2 because he thinks that the one provided by MSDN is really very poorly designed and difficult for the average Joe to understand.

SQL Server 2012 RC0 (Release Candidate 0), formerly known as SQL Server Denali, is now available for download.  SQL Server 2012 RC0 is the first release which is feature complete. James Serra announces.

John Pertell shares the step by step about using a variable to create and populate an Excel spreadsheet.

Jorge Segarra is talking about saving the bucks for the organizations through virtualization and how are the database administrators find themselves in the middle of that.

Denny Cherry‘s class is here to get you up to speed on Enterprise Class Storage and Virtualization so that you can get the best possible performance from your existing infrastructure.

MySQL:

Johannes Schlüter says that one of the great things about the HTTP protocol, besides status code 418, is that it’s stateless.

How do you know when to shard your database? Liran Zelkha tells.

Robert Hodges wonders as why so many proprietary rewrites of MySQL and InnoDB?

Ulf Wendel discloses that the catchy theme/motto of the PECL/mysqlnd_ms 1.2 release will be Global Transaction ID support, and also shares two features hidden behind the buzzword.

Pavan Venkatesh claims that SchoonerSQL is there to make the life of DBAs and Developers easy.

email

Interested in working with Fahd? Schedule a tech call.

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.

1 Comment. Leave new

Log Buffer #246, A Carnival of the Vanities for DBAs « Fast Ninja Blog by Freelanceful – Web Design | Coding | Freelancing
November 18, 2011 11:06 am

[…] The just gone-by recession (or is it still here?) taught companies to stop investing in new technology hastily and first look inwards to extract some more juice from the existing humming machines. Administrators across the database technologies find themselves at the center stage of that and they are sharing tips and tricks regarding that in […]PlanetMySQL Voting: Vote UP / Vote DOWN Original Source: Planet MySQL […]

Reply

Leave a Reply

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