Maria Sarikos

Speaker Details

Bio

Maria Sarikos has been working with DB2 for over 13 years. Maria worked as an Independent Consultant for a number of years specialising in DB2 Performance Tuning and Database Design before joining PLATINUM technology and subsequently Computer Associates. Her role at CA, soon expanded into a more wide-ranging International role and she is now, supporting CA’s DB2 tools business in the UK and Europe . Maria regularly presents at International and European conferences, DB2 User Groups and Symposia. Maria recently won the ‘Best Overall Speaker’ award at IDUG North America 2003.

Past presentation
14 June 2006
11:00 - 11:45
SQLAdria Seminar – Dubrovnik 2006 The New Speed Factor - V8 Multi-row processing

13 June 2006
11:00 - 12:15
SQLAdria Seminar – Dubrovnik 2006 The Trinity -DB2, DB2 Connect & WebSphere

12 June 2006
16:45 - 17:30
SQLAdria Seminar – Dubrovnik 2006 XML, Web Services and SOA - for Smarties

28 June 2005
10:45 - 12:15
SQLAdria Seminar – Dubrovnik 2005 Java and the Wild Wild Web - Crash Course No.2

This is the sequel of the award winning presentation - Java & the Wild Wild Web. In this presentation we delve into more advanced Web topics such as – The ABC’s of creating a Java pgm accessing DB2 ; Web services and their components and how they interact with DB2; Why XML is so important and how DB2 handles it; Why SQLJ is so much better for you & faster than JDBC; Plus we review some Web Performance commandments.

Presentation Bullet Point:
1. The ABC’s of creating a Java pgm accessing DB2
2. Web services and their components
3. XML - why its so important & how DB2 deals with it
4. Why SQLJ is better for your and your DB2’s health
5. Web Performance commandments


27 June 2005
10:45 - 12:15
SQLAdria Seminar – Dubrovnik 2005 The ABC’s of SQL Performance

Part1
SQL Performance is key to the success of any application, however programmers are often not given the full story and hence queries are not coded in the most optimal way. This session is here to remedy this situation. Part 1 deals with gaining solid in-depth understanding of DB2 EXPLAIN. Filter Factors and Runstats are closely examined and insight is gained into which statistics columns trigger certain optimizer decisions.

Bullet Points
Why is SQL Performance so Important?
DB2 Explain – The Hieroglyphics translated
Understanding Filter Factors
Runstats & the Statistics Tables
Summary

Part2
In this presentation we take a good look at the optimizer and how it goes about creating access paths. The different types of Joins are examined and the reasons why DB2 chooses certain joins over others. Inner and all the flavours of Outer joins are discussed and how they compare performance-wise to other SQL techniques. And most importantly SQL Coding Do's and Don'ts are examined.

Bullet Points
The Optimizer – Understanding how it thinks!
Joins – The different types, how they work
More on Joins - Inner, Outer, Left & Right Outer
Speeding up Performance – The Do’s and Don’ts
Conclusion


26 June 2005
14:30 - 15:30
SQLAdria Seminar – Dubrovnik 2005 SQL Coding Best Practises

There are two ways to get at DB2 data - either via DB2 utilities or SQL. Badly coded SQL accounts for a large percentage of DB2 performance problems. During this presentation we will examine the different ways of getting at the same data and how to save CPU cycles and I/O!! We will also delve into some little known facts pertaining to Joins and UNIONs as well as CASE Expressions.

Bullet Points
The old favourites revisited - Stage 1, Stage 2 & Sorts
Predicate sequence – it still makes a difference!
Outer Joins, Case Expressions & UNIONs
Locking and The Impact of COMMIT
Arithmetic in Predicate Evaluation


09 June 2004
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2004 JDBC vs SQLJ - Things you NEED to know

Opening up DB2 to the big wide world out there usually means you have more questions that answers! During this presentation we try to answer questions like: What are the different options to access data? What is best dynamic SQL or static? What are the pros and cons of each? There are so many JDBC driver types, which is best/appropriate for my needs? Is there is anything I can do to improve my performance?

Db2 and the WEB – types of applications accessing data
JDBC
Description
Driver Types
Pros and Cons
SQLJ
Description
Implementation
Pros and Cons
Performance Considerations for JDBC and SQLJ


08 June 2004
10:45 - 12:15
SQLAdria Seminar – Dubrovnik 2004 SQL Performance Under the Microscope Part II

Fact #1- SQL is the only way an application can get data from DB2 (outside of utilities).
Fact #2 - SQL can make DB2 fly or crawl.
Fact #3 - 70% of the performance gains can be achieved by tuning SQL

During this presentation you will get a better understanding of how DB2 dissects SQL. We delve into the mechanics of the DB2 optimiser. DB2 EXPLAIN is explained – this helps the programmer gain insight on how the SQL will perform. Accounting Records offer vital information about how efficient the SQL actually is, here we look at what to concentrate on to spot problems quickly. And finally we have a look at best practise techniques on how to write good SQL.

Part I
The Anatomy of an SQL statement
Predicate processing
Join Processing
Stage 1 vs Stage 2 – Important things you need to know
Explaining EXPLAIN

Part II
Impact of Locking on SQL Performance
Working with Optimization Hints
Accounting Records
Best Practice Techniques for writing SQL


07 June 2004
10:45 - 12:15
SQLAdria Seminar – Dubrovnik 2004 SQL Performance Under the Microscope Part I

Fact #1- SQL is the only way an application can get data from DB2 (outside of utilities).
Fact #2 - SQL can make DB2 fly or crawl.
Fact #3 - 70% of the performance gains can be achieved by tuning SQL

During this presentation you will get a better understanding of how DB2 dissects SQL. We delve into the mechanics of the DB2 optimiser. DB2 EXPLAIN is explained – this helps the programmer gain insight on how the SQL will perform. Accounting Records offer vital information about how efficient the SQL actually is, here we look at what to concentrate on to spot problems quickly. And finally we have a look at best practise techniques on how to write good SQL.

Part I
The Anatomy of an SQL statement
Predicate processing
Join Processing
Stage 1 vs Stage 2 – Important things you need to know
Explaining EXPLAIN

Part II
Impact of Locking on SQL Performance
Working with Optimization Hints
Accounting Records
Best Practice Techniques for writing SQL


06 June 2004
15:15 - 16:15
SQLAdria Seminar – Dubrovnik 2004 Understanding the mechanics of Good Index Design

Increasingly many DB2 professionals find that index tuning when done properly can dramatically improve performance. During this presentation we look at the effects of an index on performance, the different types of Index Access are explained and most importantly the key ingredients of good index design are discussed in depth.

Why are Indexes important?
Reduce I/O
Reduce Elapsed time
Reduce CPU
Stage 1 and Stage 2 predicates
Different Types of Indexes (including new Index Types in V8)
Clustering
Unique
Non-unique
Partitioning
Catalog Indexes
Sparse Index
Index on Large Objects
DPSI
NPSI
Variable Length Index Keys
Index Access Paths
Index Only
Matching Index
Non Matching Index
List Prefetch
Multiple Index Access
IN list Index Access
Formula for Designing Efficient Indexes
What makes an Index bad?
Things to keep in mind when designing indexes
Formula for designing Efficiency into your indexes
The ‘Grading System’ explained
Keep workloads in mind
How often is that badly performing SQL executed?
Which SQL statements are critical to the business?
Back to the Accounting reports to check performance


11 June 2003
11:45 - 12:30
SQLAdria Seminar – Dubrovnik 2003 Finding BAD SQL - Before it finds YOU

09 June 2003
15:30 - 16:15
SQLAdria Seminar – Dubrovnik 2003 Are you TRIGGER-happy

08 June 2003
17:50 - 18:30
SQLAdria Seminar – Dubrovnik 2003 17 Performance Tips for DB2 and the Internet!

12 June 2002
10:15 - 11:15
SQLAdria Seminar – Dubrovnik 2002 eDesign for ePerformance

11 June 2002
15:30 - 16:15
SQLAdria Seminar – Dubrovnik 2002 Java and the Wild Wild Web for mainframe DBAs - Part 2

10 June 2002
15:30 - 16:15
SQLAdria Seminar – Dubrovnik 2002 Java and the Wild Web for mainframe DBAs - Part 1

09 June 2002
17:45 - 18:30
SQLAdria Seminar – Dubrovnik 2002 Cas Performance Solutions

12 June 2001
15:30 - 16:15
SQLAdria Seminar – Dubrovnik 2001 What exactly is inside DB2 LOG?

11 June 2001
15:30 - 16:15
SQLAdria Seminar – Dubrovnik 2001 LOB's - what are they and how do they really work?

 

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 2019

Ljubljana - 9th & 10th April 2019
Belgrade - 12th April 2019
Šibenik - 26th - 30th May 2019
Zagreb - 26th September 2019
Opatija - 28th & 29th November 2019