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 Top 25+ SQL Tuning Tips - Part 2

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
14:15 - 15:15
SQLAdria Seminar – Zagreb 2018 Top 25+ SQL Tuning Tips - Part 1

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 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - 18th September 2018
Opatija - 29th & 30th November 2018