It's that time of year again, I'll soon be waving goodbye to my DB2 Geek colleagues and heading home for mountains of turkey, mince pies and the odd glass of mulled wine. However, before I leave you I thought it would be good to share my personal DB2 Geek highlights of 2011. So, here we go...
We cleared our post-celebration heads by getting together with our fellow DB2 Geeks across the pond and announcing to the world our new partnership. What a great way to start the new year!
The partnership with DBI allows us to use their industry leading monitoring and reporting software as part of our Remote DBA service. Also, DBI are taking Remote DBA to a worldwide audience so we're really excited about it.
A cautionary tale
Fellow DB2 Geek, Iqbal Goralwalla shared one of the best techie tips which we had all year (in my humble opinion). During a recent DB2-LDAP configuration at a client site, he stumbled upon a bizarre security exposure......all the details are here.
Command Line Vs GUI - one of my favourite topics! I always say that database admin is best performed from the command line with scripts. This means that admin is repeatable and the actions are recorded which in turn can improve DBA productivity. In February I decided to write a short piece for your delectation on this much loved topic of mine - and here it is.
DB2 10 for z/OS was launched last year but it was in 2011 when things really began to hot up with organisations starting to plan their next version migration. IBM ran an excellent event back in March; DB2 for z/OS Technical Forum. Julian Stuhler presented on DB2 10, it's new features and migration planning. You can download his presentation here.
In April we had our first DB2 Geek article contribution from Sathyaram Sannasi on SECADM. This piece proved to be hugely popular. I'm reliably informed by our Marketing people that this has been consistently one of the most popular articles all year! Well done Sathy! If you haven't already seen it then you can have a read here.
DB2's Got Talent - a winner is crowned!
Our partners DBI software brought a little "reality tv" to the world of DB2 with their "DB2's Got Talent" competition which saw DB2 Geeks from around the world showcase their DB2 talent (and geekiness) in a series of special DB2Night Shows.
April saw Nortbero Filho crowned as winner! You can read his blog on IBM DeveloperWorks.
A Knock-out blow in the big fight live!
In May we were invited to the DB2Night Show for the big fight where we presented the findings our of Oracle 11g Vs DB2 9.7 complexity analysis. You can read all the blogs here and download the full report here.
A holiday for the DB2 Geek!
Whilst I was away a Senior DBA called Philip Carrington from the aptly named Holiday Extras stepped in and shared with us an article on DB2 reorganisation. We were delighted to have one of our customers share some of their DB2 experience, you can read this excellent article here.
DB2 Geek goes viral! Yes, June saw my first ever action movie launched to the world. If you missed it you can catch it here.
The video seemed to inspire a marmite reaction from the DB2 community. Some loved it, others hated it! I'd love to know what you think.
Diagnostics for Dinosaurs
In June I shared a tip for all the DB2 z/OS people about a new APAR - II11945. Take a look.
Marti McFly has northing on DB2!
As a "Back to the Future" uber fan I was pleased to be able to report that IBM had introduced it's own form of time travel into DB2 10. Temporal data is one of the most exciting features in DB2 10 and you can find out more in my article.
DB2 Explain Doesn't do it for Developers
This was one of my favourite stories of the year! In this article, fellow DB2 Geek, Paul Stoker, tells the story of how Dave The Developer uses DB2 Explain - definitely worth a read!
Remote DBA in Action
In September our Remote DBA team decided to record some videos to show how we use tools from DBI Software to proactively manage and monitor our customers DB2 databases. You can take a look at the videos on YouTube http://www.youtube.com/tritonconsulting
DB2 DART - Iqbal steals the (DB2Night) Show!
Our head of DB2 Midrange (did I mention he is an IBM Data Champion too?) presented on the ever popular DB2Night Show in October. This proved to be one of their most successful shows with 100% of attendees saying that they learned something. You can listen to the replay here or download the presentation here.
Look out for an article on this topic coming to Confessions of a DB2 Geek early in the new year.
A BIG month for DB2 Geeks!
November was really exciting for us. The highlight was IDUG EMEA in Prague, what a great event! We had so much fun meeting up with all our European DB2 colleagues. You can see all the updates and pictures from IDUG EMEA in the blog. Next year there will be some DB2 Geek competitions running for you to win DB2 geek t-shirts so look out for those!
The other big topic for us in November was Migration Month. In conjunction with our colleagues at IBM we ran a series of webcasts on DB2 10 and migration planning. If you missed any you can find links on our blog.
So here we are, in December. It's been a busy year! My personal highlights from December (aside from the mince pies) are:
Wishing you all a great Christmas and New Year! We'll be back in 2012 with lots more news, tips and techie articles.