Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #85: Advanced Application Design Techniques

June 15, 2012, 3:47 pm
Posted by Scott in DB2 LUW
Sanjay Kumar

Special Guest: Sanjay Kumar, Author

DB2 LUW Advance Application Design Techniques
Replays available in WMV and MP4 formats!

100% of our audience learned something! Our special guest, Sanjay Kumar, shared with our audience information from his book IBM DB2 9.7 Advanced Application Developer Cookbook. Sanjay covered Stored Procedures, OLAP Functions, DB2 Optimization Profiles, and many tips for writing good performing SQL! Watch and learn...

Show Host Scott Hayes Commentary

100% of our studio audience learned something! I think that pretty much says it all! We've now had two shows in a row where 100% learned something! I thought Sanjay's tips on writing SQL were particularly interesting and helpful.

Sanjay spent more than six months writing his book. There are over 400 pages of helpful materials. If you like, please read my book review.


During this show, Sanjay selected two random numbers: "8" and "16". We are pleased to announce the winners of copies of Sanjay's book:
  1. Gail Mueller, Aetna, Hartford, CT
  2. Roger Stinson, HP, Marysville, OH

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

The Corporate Sponsor of The DB2Night Show:
DBI Software

During today's quick DBI commercial, we talked about chargebacks and demonstrated DBI capabilities for implementing chargebacks. If you want to make database users more responsible and accountable for their queries, consider implementing a chargeback system. DBI makes it easy.

DBI is offering a free Webinar "How to Improve Performance in Minutes!" on 29 June 2012 at 2pm CDT. Visit DBI Events for details and the registration link.

On 23 May 2012, DBI Announced new competitive performance tool pricing incentives. If you have IBM OPM or other performance tools, DBI invites you to trade-in, trade-up, and swap-out those tools while enjoying special license savings. Inquire with your DBI representative for qualifications and details.

DBI is Your Trusted Partner
for Breakthrough DB2 Performance Solutions
that Deliver Invaluable Results
for Organizations having the most Demanding Requirements
and Discriminating Preferences

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Get the Download Replays

WMV Format

To download a recorded replay of Episode #85 in WMV format, right click on the link below and choose "Save As..."
Episode #85, 15 June 2012, DB2 LUW Advanced Application Design Techniques

MP4 Format

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

Did you learn something from this show?

See that "Mail This" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS!

Share a great show with your friends and followers:

Printer friendly