I had to miss the show on March 30th, but hopefully you were able to attend the show live. I’m listening to the replay and here’s a summary of what took place.
The theme for this show was for the contestants to showcase their best success story with DB2.
Today was the third show of the finals for the DB2’s Got Talent 2012 Competition. I wasn’t able to participate, so IBM Champion, Julian Stuhler filled in for me. Thanks Jules!
If you didn’t participate live, I strongly encourage you to watch the replay. We had the 7 remaining contestants from Round 2 present 6-minute technical presentations to us. Once again, we ended up with very high quality presentations from very experienced users of DB2 products.
Here’s a summary of what happened:
Contestant 1 – Kohli
App Design Change Results in Significant Performance Gain
Kohli was in the top 3 of the votes from Round 2. Kohli showed how he used Explains to analyze the performance his company was experiencing with their queries. They looked at the design of the app to understand why the query was so costly. They made the appropriate changes and re-ran explain to find that the performance was significantly improved. Conclusion: It is very important to work with application developers to ensure that performance is the best it can be. This is a classic example with figures to back up the conclusion. Very well presented.
Contestant 2 – Brian
Jack Bauer – DB2 DBA
Brian was also in the top 3 of the votes from Round 2. Brain did a parody of Jack Bauer from TV show “24”. (An Aside.. Did you know that Keifer Sutherland who played Jack Bauer in the series is Canadian?) Very creative with lots of suspense. Brian made the job of a DBA look sexy and heroic. Brian tweets at https://twitter.com/#!/fairchild_db2 and blogs at http://bit.ly/yGpae2 .
Contestant 3 – Douglas
DB2 LUW & DB2 z/OS – Problems with Timestamps
Douglas was in the bottom 4 of the votes from Round 2. His presentation was about issues he’s experienced with timestamps: can’t use mass inserts or updates and nested triggers won’t work. Douglas clearly stated the problem and showed a solution that works for for both LUW and z/OS. Conclusion: They ended up saving 36 hours of processing time for a warehouse application. Very well done.
Contestant 4 – Jean
How the Sysplex Distributor got our Web Apps out of a Pickle
Jean was in the bottom 4 of the votes from Round 2. Jean did a fabulous job of explaining the problem and her trial and error approach to finding an appropriate solution. Great call out to IBMer & Redbook author Jim Pickel. Excellent presentation with material that will be very helpful for many people.
Contestant 5 – Ember
Four Missing Indexes That Almost Ate The Year’s Revenue
Ember was in the bottom 4 after votes from Round 2. Quite a surprise to me! This presentation centered around problems that can occur during Black Friday and Cyber Monday for e-commerce sites. Real life and critical to solve. Index read efficiency was over 10,000… why? Ember found problems in the top two queries. She gives a detailed description to her analysis of the queries. New indexes were implemented and huge improvements were seen and the client was able to see an increase in 637% in revenue!! Way to go! Very well presented with huge impacts to business objectives. Ember tweets ember_crooks & blogs http://db2commerce.com/.
Contestant 6 – Rodolpho
Migration of DB2 for z/OS running SAP from Version 8 to 9. How I succeed on it.
Rodolpho was in the bottom 4. Rodolpho’s presentation took us through the considerations of migrating a database that is running SAP. They had to consider whether to migrate to DB2 9 or 10 and chose 9. Very good descriptions of what to do with SAP. Lesson learned: plan, plan, plan. Great to see a presentation on this topic. You can follow Rodolfo on twitter: https://twitter.com/#!/_rodc
Contestant 7 – Elder
Reclaim Space – Easy in Db2 v9.7 and Show Off!
Elder was in the top 3, but there were major technical problems that required Scott to make emergency contingency plans. Elder recorded his presentation and posted it on Youtube. You can find the link on the DBI's website: Episode #75: DB2's GOT TALENT Finals Round #3
The judges, Martin Hubel, Klaas Brant, and Julian were asked to save one of the bottom 4 presenters based on the voting from the past two weeks. It was a tough decision, but the judges decided to save Jean! Congratulations Jean! I’m sure the decision was difficult to make as all the contestants are truly talented presenters and have much success ahead of them.
100% of the listening audience said they learned something new today. How about you, listening to the replay? Did you learn something new?
Now the control is with you the listeners. After you watch the replay, VOTE! I’m glad I don’t get to choose… there is such great talent appearing on this show that it will be very difficult to choose.
The control is now in the hands of you, the audience. You must vote for Our Top 4 Finalists to determine who wins the Grand Prize! Here’s what you need to do. If you were in the audience, vote in the survey provided for who you thought was the best. If you weren’t able to make it to the show, watch the replay, and then VOTE. Don’t watch just to vote, watch to learn great DB2 tips as well as examples of excellent presentation skills.
Thanks to host Scott Hayes for this opportunity for me as a judge and for the contestants for helping them build technical presentation skills that are so valuable.
For details on the prizes for this competition… and a summary of last year’s event… see my blog entry: http://ibm.co/AnZxb4
See also: DB2’s Got Talent Finals – Round 1
See also: DB2’s Got Talent Finals – Round 2