Baltimore/Washington Db2 Users Group Annual Education Event – Wednesday, March 14th

Posted by Kim May on March 2, 2018 under Baltimore Washington DB2 Users Group, DB2 for z/OS, IBM Champion, SQL Tuning.

I am looking forward to the Baltimore/Washington Db2 Users Group March education meeting – in our new meeting location, the BWI Hilton!!  After months of discussion the board decided this location offers our members convenience, better traffic routes and an improved lunch facility (the Flight Deck; even sounds fun!)

The meeting is scheduled for Wednesday, March 14th, from 9:00am – 4:00pm.  The cost is $250 in advance and $350 at the door.  Register HERE.

March is of course the group’s annual education session.  This year the group has invited Tony Andrews of Themis to present.  Tony’s full-day session consists of topics selected specifically to assist developers with Db2 SQL programming performance and best practices.

Attendees will gain knowledge of SQL programming, performance and tuning, and the SQL-PL native Stored Procedure language.

The material provided to each attendee will include:
– SQL Standards and Guidelines
– SQL coding best practices
– SQL-PL coding best practices
– Many great SQL examples on rewrites
– SQL and program tuning tips
– SQL and program tuning step by step processes

Session Topics:
? Learn the top reasons for poor performance
? Learn our top SQL rewrites every developer should know
? Learn our top SQL Tuning Tips for developers
? Learn our top reasons why you have to watch out for null columns
? Learn the top reasons why developers need to know their data
? Learn what filter factors are and why they are so important
? Learn our top 10 steps to tuning a query or program
? Learn our top SQL-PL stored procedures best practices

Presenter Tony Andrews, Themis Inc., Consultant and Trainer
Tony Andrews has more than 25 years’ experience in the development of relational database applications. For most of this time he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs and has also served as a database analyst. For the last 10 years Tony has been splitting his time between performance and tuning consulting engagements and training.  His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming — always with a special emphasis on improving performance.  He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA.  He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.

Leave a Comment