Log Buffer #210, A Carnival of the Vanities for DBAs
Dec 26, 2010 / By Gwen Shapira
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.
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.
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.
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.
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.
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?
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.
Hope you enjoyed this episode of Log Buffer.