Gareth Z Jones

Speaker Details

Bio

Gareth has worked in IT since 1985, when he worked in the UK for an IBM customer. His first real contact with DB2 when, as an IMS Systems Programmer and DBA, he was handed the job of migrating DB2 from V1.3 to V2.1, and he hasn't looked back since. He spent eight years as a contractor, gaining experience in France, the Netherlands and the UK, before joining IBM as a permanent employee in 2000. Gareth worked for several years in IBM's Strategic Outsourcing division, and in BetaWorks, before joining the DB2 for z/OS SWAT Team, under the leadership of John Campbell, taking advantage of the opportunity to work with many customers around the world.

Past presentation
09 December 2014
12:45 - 14:15
SQLAdria Seminar – Opatija 2014 Dynamic SQL best practices, and analysing query performance

Dynamic SQL best practices, and analysing query performance  This presentation looks at some dynamic SQL best practices, and also looks at how you can code for and analyse query performance. 


09 December 2014
11:00 - 12:30
SQLAdria Seminar – Opatija 2014 Java error handling for JDBC and SQLJ applications

Java error handling for JDBC and SQLJ applications: This presentation provides some guidance on handling SQL errors and SQL warnings in your Java applications, in the case of JDBC and SQLJ 


09 December 2014
09:00 - 10:30
SQLAdria Seminar – Opatija 2014 INSERT optimisation and Batch processing

INSERT optimisation and Batch processing: This presentation looks at how you can optimise your applications and your database design for INSERT-intensive workloads, and for other batch operations/ 


08 December 2014
16:00 - 17:00
SQLAdria Seminar – Opatija 2014 Interpreting the Explain tables, using optimiser hints and establishing query stability

Interpreting the Explain tables, using optimiser hints and establishing query stability: There presentation delves into the information available in the EXPLAIN tables which can be used to understand what access path is chosen by DB2 and why. It also looks at how this same infrastructure can be used to provide hints to the optimiser to influence access path selection, and ultimately to ensure that preferred access paths are used for critical queries. 


08 December 2014
14:30 - 16:00
SQLAdria Seminar – Opatija 2014 SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques

SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques: This presentation looks at a variety of SQL features introduced over several DB2 releases, and how they can be used to provide improved functionality, performance, and to provide alternative coding techniques for your applications.


08 December 2014
11:45 - 13:15
SQLAdria Seminar – Opatija 2014 Archive Transparency and TIMESTAMP with TIMEZONE

Archive Transparency and TIMESTAMP with TIMEZONE:This presentations explores the DB2 11 feature which allows applications to transparently access data in an archive table, and optionally to move non-active data into an archive table. It also looks at the use of time zone information with TIMESTAMP columns. 


08 December 2014
10:30 - 11:30
SQLAdria Seminar – Opatija 2014 Triggers, Instead of Triggers and Multi-row operations

Triggers, Instead of Triggers and Multi-row operations: This presentation examines the use of triggers and instead of triggers, and looks at the benefits and coding techniques for exploiting multi-row operations.


 

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