NEODBUG
Education Event 10/23/2025
Education Event 10/23/2025
bpatalita
September 30, 2025
11:45 am
This virtual education event will be held via webex and the cost will be $100 per person. As such we are not limiting our audience to current user group members. Invite a friend or coworker who may not have had the chance to attend in person in the past and let them experience what NEODBUG is all about! Please register just as you would for an inperson seminar by using the link at the bottom of the page with the name of your organization and any attendees. We will send you a link to the event as it gets closer

NEODBUG AGENDA
THURSDAY October 23rd, 2025
This virtual education event will be held via Teams and the cost will be $100 per person.
As such we are not limiting our audience to current user group
members. Invite a friend or coworker who may not have had the
chance to attend in person in the past and let them experience what
NEODBUG is all about! Please register just as you would for an
in-person seminar by using the link at the bottom of the page with the
name of your organization and any attendees. We will send you a link
to the event as it gets closer

The cost for this education event will be $100.

The Teams link will be sent prior to the meeting.

REGISTER NOW!



Presentation abstract:

 

          Writing Advanced SQL: Why, When and Performance Implications

 

This class will explain “advanced” SQL, how and why to use it, keeping the focus on performance. We will start easy and go into our daily constructs like “group by” and “having” but we will see what performance changes your coding choices can bring. We will talk about subqueries, nested table expression, common table expressions, when best to use them and what to look out for. Of course, we will talk about joins and how to tune them, DGTT’s, recursive SQL, OLAP function and SQL stored procedures. We end the day explaining how to think like the optimizer and understand why performance might not be what was expected.






    Presented by Kurt Struyf, Lone Star Consulting:

     

    Kurt Struyf is an independent consultant/contractor and president of Lone Star consulting. He has over 25 years experience as a (system) DBA and has been installing, migrating, troubleshooting and tuning DB2 systems throughout Europe. Besides his consultancy missions he has been teaching a broad spectrum of DB2 classes, both in Europe and the USA. These classes range from basic courses like DB2 fundamentals and SQL workshops, over database administration and system administration classes, to system and application recovery and tuning workshops He has been a speaker at several large European and North America conferences. Kurt is an IBM information Champion and IBM gold consultant.


    Category : Meetings
    Tags : 10/23/2025 Education Event Meeting