March 12th, 2018 Meeting
 


Free admission to this meeting is limited to the first 20 attendees that sign up in eventbright.
Link to Register for March 12th 2018 meeting

 
Our guest speaker is Tony Andrews of Themis. This 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

We will start at 8:30 am, break for a catered lunch at 11:30, and expect to wrap up by 3:30 pm.

Speaker Bio:

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’.

Abstract:

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

Member Fees
The membership fees for 2018 have been eliminated.

For our March meeting we need to limit the number of free attendees to the first 20 that sign up in eventbrite.

Meeting Location
A reminder that our meetings are held at Kansas University -
Edwards Campus, Regnier Building at 127th and Quivira in Overland Park.
*** Please note this is the Regnier Building at KU-E, NOT the ***
*** Regnier Building at Johnson County Community College. ***
  
Kansas University - Edwards Campus
12600 Quivira Rd
Overland Park, KS 66213-2402

Maps and directions are available here:
https://edwardscampus.drupal.ku.edu/campus-map#drivingdirections

The Regnier building is in the southeast corner of the complex, and you will find parking in front of that building off of 127th St. Our exact room will be posted on the information screen as you enter the building.


0 Response to "March 12: Heart of America DB2 User's Group Meeting"

Post a Comment

Group Tools

Random Prize Winner
Use this tool to generate random numbers for prize drawings.




Follow this twitter list of the twitter accounts for the user groups. Ask for your group to be added to this list: twitter list
Subscribe to the Kansas City User Group Newspaper at Paper.li

Blog Archive

Followers