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

There are plethora of thrilling business software trends on the horizon as the summer of 2011 starts. Many of these will significantly impact IT organizations seeking to align IT operations with business objectives. Awareness of such trends can help you to keep ahead of the competition. What better way to get abreast of these trends in a nutshell than the Log Buffer? Log Buffer #219 is in your hands to enjoy.



Oracle:

When Arup writes it, it stays written. In a very refreshing post, he is sure to convince anybody why he or she needs Tanel Poder’s class.

Kevin Closson is going to EMC World 2011 and he believes that it won’t be a waste of time.

You have got to read the blog post to see its beauty and the hard work that goes behind its production. Charles Hooper, one of my favorite bloggers does it again.

Gwen Shapira, so kindly shares an excellent post by Gary Myers discussing math, contention, queues, de-normalization and eventual consistency.

Alberto Dellera informs us that the top Oracle celebrity Tom Kyte is visiting the beautiful Italia. Wow starts in Italy now.

SQL Server:

Technical documentation is thought of as a necessary evil by most IT folks. SQL Chick tells us how to make it more fun and proper.

SQL Server Management Studio 2008 introduces a new feature, Multiple Server Query Execution. This feature enables you to execute a query against multiple servers. Vishal blogs about it in an exquisite manner.

Klaus Aschenbrenner reminds the readers that the RCSI/SI doesn’t work with rows larger than 8046 bytes.

In his blog post, Colin shows that as to how developers can show their DBAs some love as I think of them.

Jorge Segarra in his latest blog post, continue exploring that data load package and take a look at another critical piece of SSIS that you should know about: precedence constraints.

MySQL:

Kaj Arnö decided to tap into the database expert resources present at Sardegna Ricerche by discussing a non-database issue, where one can expert database experts to have insights beyond those of end users, and he blogs about it.

Justin Swanhart blogs about Shard-Query. Shard-Query is an open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores.

Now XtraBackup Manager has the capabilities of Email Alerts and More Nexenta/ZFS Testing as blogged by Lachlan Mulcahy.

Martin Farach-Colton gave a talk called “Elephants on a Trapeze: Keeping Big Data Agile”. The talk is an introduction to performance issues related to big data without getting too technical. He details it in his blog.

Andrew Hutchings blogs about viewing the MySQL dump import progress as it happens and then talks about the bar utility.

Happy Cool Blogging!!!

email

Authors Fahd Mirza

Interested in working with Fahd? Schedule a tech call.