Tony Andrews

Speaker Details

Designation: 
Themis Inc. Developer, Consultant and Trainer
Company: 
Themis Education
Bio

Tony Andrews has more than 25 years’ experience in the development of relational database applications. 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 during his development years, 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 along with training.  His main focus is to teach today’s developers the ways of RDBMS 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’.

Past presentation
18 September 2018
15:30 - 16:15
SQLAdria Seminar – Zagreb 2018 SQL PL DOJO

A SQL Dojo is a meeting where a bunch of developers, DBA and SYSPROGS get together to work on a number of SQL challenges. They are there to have fun and to engage in a group effort in order to improve their skills in a non-competitive, collaborative, fun environment. The goal is to have practical hands-on experience within a group of peers, learning a specific technical skill and having some fun.

The exercise is considered successful when it is completed within allocated time AND audience can repeat the exercise at home by themselves. At the end of the dojo the participants receive, a working solution by dojo leaders, which might not correspond to the solution the participants came up with, but is also working.
Teams will code a couple of SQL PL programs, deploy them, and test them to completion.


18 September 2018
14:15 - 15:15
SQLAdria Seminar – Zagreb 2018 Top 25+ SQL Tuning Tips

This covers many standards, guidelines every IT department should have for SQL programming. This covers many of the efficiencies/inefficiencies of the SQL code. This cover many of the ‘Do not code this way’, ‘Code this way’ examples. This is a great start for developers to know possible SQL issues.Great SQL examples throughout.


18 September 2018
12:00 - 13:15
SQLAdria Seminar – Zagreb 2018 Advanced Query Tuning with IBM Data Studio
This covers many examples of Db2 explains using the tool. This covers how to read and analyze visual explain output. This covers filter factors, query rewrites, transitive closure, statistics and more….

18 September 2018
10:30 - 11:45
SQLAdria Seminar – Zagreb 2018 Top Reasons for Poor Performance

This covers many SQL tuning standards/guidelines and best practices. This covers Do’s and Don’t’s of coding, stage 1 and stage 2 predicates, indexable and non-indexable predicates, statistics, design, new SQL features and more…


 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2024

VODICE -  10th - 13th June 2024