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

Dec 26, 2010 / By Gwen Shapira

Tags: , ,

Welcome to Log Buffer, the weekly news update of happenings in the database world.

Its the holiday season and many DBAs would rather cuddle at home with their family rather than do exciting work and blog about it. Can you imagine? Many thanks to Fahd Mizra who helped me by collecting DB2 news. Grab your snuggie and cuddle up with Log Buffer #210.

MySQL:

Giuseppe Maxia, the Data Charmer looked for a way to add comments into the binary log and created an interesting discussion on the topic.

You’d think that having some idle connections wouldn’t really impact your database performance. At least thats what I thought. Good thing that Yves Trudeau at MySQL Performance blog bothered to check and report. Also on MySQL Performance blog, Peter Zaitsev has a short and sweet capacity planning tip.

SQL Server (kind of):
Ed Wilson, the Scripting Guy has a guest post on how to use windows PowerShell to manage your holiday wish list. Personally, I wouldn’t touch windows and XML even if it means giving up my start-wars hoodie, but maybe some of our readers will be interested in this for the next holiday. He also published a very funky Powershell carol story, so check out his other posts too.

Oracle:
Arup Nanda posted an excellent article “100 things you probably didn’t know about Oracle Database”. It sounds like a checklist, but it isn’t – its a fascinating review of how Oracle really works. Things we should all know, but frequently forget.

Alex Fatkulin, at the Quadro Blog, discovered that the easy setup of Golden Gate comes with a price. How big is your trail file? How big is it if you have really long table names?

Oracle Wait Interface is a wonderful thing. I can’t imagine doing my job without it. But it has its limits and Craig Shallahamer, the performance firefighter, demonstrates an issue with IO read wait occurrence count.

Dominic Brooks from Orastory has a four part series about the simple and not-so-simple benefits of deterministic functions. He is also stoked about pre-built developer VMs and so am I.

Jonathan Lewis was surprised by a join. If he was surprised, I’m sure everyone else will be too. Did you know that the order of join predicates can have an order of magnitude impact on query performance?

Mohamed Azar shows how to easily recover dropped users with flashback database without losing any data. This is mostly useful for small users because it involves an export, but its still a great demonstration of the power of flashback database.

Kerry Osborne shares a funny trick one of his developers tried. Without looking at the comments, can you figure out why he did this?

Kevin Closson published a multi-part series on how to use DNFS to quickly clone a dev/test copy of your database even without hardware support.

Gleb Otochkin discovered how to upgrade ASMLib the easy way. Gleb is my team mate and I just noticed that his previous post about Golden Gate has 130 (!) comments. Wow. You see why I keep blogging about working with the best people ever?

Gavin Soorma posted an in-depth blog about 11g tablespace compression.

For holiday entertainment, Iggy Fernandez links to an excellent short film about Larry Ellison. Featuring Bruce Scott, unfortunately without his cat, Tiger.

DB2:

Leons Petrazickis writes short, but when he writes, it stays written. Here he shares how to find out your SLES version and service pack level from command line.

A very special blog post by Craig S. Mullins discussing misunderstandings about the role of database administrators. He backups his ideas by solid arguments.

Vincent McBurney talks about Informatica taking lead over IBM when it comes to Data Integration Tools, according to Gartner Magic Quadrant.

The evolution of DB2’s SQL Procedure Langiage (SQL PL) is going on and on. Serge Reilau lists down this evolution process by version, preparing for a later discussion on how to use it properly.

Willie Favero, like many DB2 fans, was waiting to get his hands on DB2 10 Redbook. The wait is over and its available.

Hope you enjoyed this episode of Log Buffer.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>