Mike Bracey

Speaker Details

Bio

Mike Bracey is part of the IBM Software Business in Europe providing technical support for DB2 for z/OS and related topics. He has extensive practical DB2 experience, gained over 18 years, of DB2 application design, data modelling, and performance monitoring and tuning. His recent roles have included technical support for IBM Data Management Tools and for the DB2 for z/OS beta programs in Europe.

Past presentation
25 studeni 2011
11:15 - 12:00
SQLAdria Seminar – Opatija 2011 Improve Development Productivity ‐ continued

25 studeni 2011
09:45 - 11:00
SQLAdria Seminar – Opatija 2011 Improve Development Productivity

25 studeni 2011
09:00 - 09:45
SQLAdria Seminar – Opatija 2011 Improve Development Productivity

24 studeni 2011
17:00 - 18:00
SQLAdria Seminar – Opatija 2011 Hand on Lab continuation ‐ optional

24 studeni 2011
15:00 - 17:00
SQLAdria Seminar – Opatija 2011 Improved Performance and Reduced CPU

24 studeni 2011
14:00 - 14:45
SQLAdria Seminar – Opatija 2011 Improved Performance and Reduced CPU

24 studeni 2011
13:30 - 14:00
SQLAdria Seminar – Opatija 2011 New Core Features and Enhancements ‐ continued

24 studeni 2011
11:15 - 12:30
SQLAdria Seminar – Opatija 2011 New Core Features and Enhancements

24 studeni 2011
10:15 - 11:00
SQLAdria Seminar – Opatija 2011 New Core Features and Enhancements

24 studeni 2011
10:00 - 10:15
SQLAdria Seminar – Opatija 2011 Introduction

26 studeni 2010
09:30 - 10:15
SQLAdria Seminar – Opatija 2010 P6: Optimizing, managing and securing data access of Java applications

26 studeni 2010
09:00 - 09:30
SQLAdria Seminar – Opatija 2010 P5: IBM Optim Query Tuning Offerings - Optimize Performance and Cut Costs

25 studeni 2010
17:00 - 18:00
SQLAdria Seminar – Opatija 2010 L2: Continue with L2 if required

25 studeni 2010
16:30 - 17:00
SQLAdria Seminar – Opatija 2010 P4: DB2 Dynamic Statement Caching and interaction with Websphere

25 studeni 2010
15:30 - 16:30
SQLAdria Seminar – Opatija 2010 P3: How to Set up Websphere Application Server to Access DB2 z/OS with High Availability

25 studeni 2010
13:30 - 15:15
SQLAdria Seminar – Opatija 2010 L2: Optimizing an existing Java application using pureQuery client optimization

25 studeni 2010
10:45 - 11:15
SQLAdria Seminar – Opatija 2010 L1: Introduction to Optim Development Studio

25 studeni 2010
10:10 - 10:45
SQLAdria Seminar – Opatija 2010 P1: IBM Integrated Data Management

21 studeni 2008
11:15 - 12:00
SQLAdria Seminar – Opatija 2008 P5: XML Indexing and Performance Considerations

21 studeni 2008
11:00 - 11:15
SQLAdria Seminar – Opatija 2008 Lab 7: XML Schema creation, Validation and Decomposition

21 studeni 2008
10:00 - 10:45
SQLAdria Seminar – Opatija 2008 Lab 6: SQL/XML Tuning using XML indexes Lab 7: XML Schema creation, Validation and Decomposition

21 studeni 2008
09:00 - 10:00
SQLAdria Seminar – Opatija 2008 P4: Querying XML with XPath and SQL/XML

20 studeni 2008
16:00 - 17:00
SQLAdria Seminar – Opatija 2008 Lab 4: Querying XML Data Lab 5: Updating and Deleting XML Data

20 studeni 2008
15:30 - 16:00
SQLAdria Seminar – Opatija 2008 P7: pureXML on DB2 9 for z/OS continued

20 studeni 2008
14:45 - 15:15
SQLAdria Seminar – Opatija 2008 P7: pureXML on DB2 9 for z/OS

20 studeni 2008
14:15 - 14:45
SQLAdria Seminar – Opatija 2008 P3: DB2 pureXML: Features and Externals

20 studeni 2008
13:45 - 14:15
SQLAdria Seminar – Opatija 2008 Lab 2: Creating XML data Lab 3: Creating, Altering and Loading XML Objects

20 studeni 2008
12:15 - 12:45
SQLAdria Seminar – Opatija 2008 Lab 1: XML Publishing; Create an XML Column

20 studeni 2008
12:00 - 12:15
SQLAdria Seminar – Opatija 2008 Lab 0: Introduction to Lab exercises

20 studeni 2008
11:30 - 12:00
SQLAdria Seminar – Opatija 2008 P2: XML Fundamentals continued

20 studeni 2008
10:30 - 11:15
SQLAdria Seminar – Opatija 2008 P2: XML Fundamentals

20 studeni 2008
10:10 - 10:30
SQLAdria Seminar – Opatija 2008 P1: The value of XML in SOA and Information Management

24 lipanj 2008
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2008 Optimisation Service Centre and Optimisation Expert

Objectives:
Learn the basics of using DB2 Optimization Service Centre and Optimization Expert for z/OS and how they can solve common SQL Tuning problems.

Outline:
Introduction to Optimization Service Center (OSC) and Optimization Expert (OE)
Tuning workloads
Individual query analysis and tuning
Access plan graph
Query Annotation
The advisors – statistics, query and index
Visual Plan Hints

Full Abstract:
DB2 Optimization Service Centre and Optimization Expert for z/OS are SQL tuning tools with tightly integrated tuning advisors and advanced tuning tools to address both individual SQL statements and SQL workloads. Tuning advisors provide statistics, indexing, and query-rewrite recommendations, while advanced tuning tools like query annotation, access plan graph, query report, and visual plan hint facilitate deep SQL performance analyses when needed.


19 lipanj 2007
14:15 - 15:15
SQLAdria Seminar – Dubrovnik 2007 DB2 9 new SQL functions for application developers

Presentation will cover Intersect & Except, Instead of Triggers, Merge, Select from Merge, Update and Delete, Truncate, Order by and Fetch first in subselect; the new data types. Same presentation will be conducted at the DB2 Technical conference in Dusseldorf.
 


18 lipanj 2007
14:00 - 15:30
SQLAdria Seminar – Dubrovnik 2007 Native XML support in DB2 9 for z/OS

Presentation will be based on the material presented by Guogen Zhang at the Anaheim IOD and it will include some worked examples.  Simple demonstration wil be included in presentation accordingly to the network access.  Primary goal would be to show that XML in V9 is a straightforward extension of existing relational technology, is simple to use and it works well.
 
 


30 ožujak 2007
10:20 - 11:15
SQLAdria Seminar – Ljubljana 2007 DB2 for z/OS and SOA

17 studeni 2006
11:30 - 12:15
SQLAdria Seminar – Opatija 2006 DB2 V9 Overview

17 studeni 2006
11:00 - 11:30
SQLAdria Seminar – Opatija 2006 Multi-Level security

17 studeni 2006
10:00 - 10:45
SQLAdria Seminar – Opatija 2006 Stored Procedure enhancements

17 studeni 2006
09:00 - 10:00
SQLAdria Seminar – Opatija 2006 Unicode - what is it and how does it affect a DB2 V8 user

16 studeni 2006
16:30
SQLAdria Seminar – Opatija 2006 XML

16 studeni 2006
15:45 - 16:30
SQLAdria Seminar – Opatija 2006 New Java Driver and hints and tips

16 studeni 2006
14:00 - 14:45
SQLAdria Seminar – Opatija 2006 Identity Columns and Sequences

16 studeni 2006
12:15 - 12:45
SQLAdria Seminar – Opatija 2006 Common Table Expressions (CTE) and Recursive SQL

16 studeni 2006
11:30 - 12:15
SQLAdria Seminar – Opatija 2006 Scrollable cursors and GET DIAGNOSTICS

16 studeni 2006
10:15 - 11:15
SQLAdria Seminar – Opatija 2006 Multi row operations - SELECT and INSERT

 

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 2020

VIRTUAL EVENT - 25th - 27th November 2020