Loading…
Unlock the Power of IBM i at POWERUp 2025!

Join us in Disneyland, California, for POWERUp 2025, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!

Type: Database clear filter
arrow_back View All Dates
Wednesday, May 21
 

9:15am PDT

Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions
Wednesday May 21, 2025 9:15am - 10:15am PDT

Take your SQL skills to the next level with this session on Lateral joins, Window functions, and Pivoting. Discover how LATERAL joins simplify complex queries, learn new insights with Window Functions, and master the art of pivoting data for dynamic reporting. Whether you're an SQL pro or beginner, join us to unlock the full potential of these powerful tools and techniques (and get free code).
Speakers
avatar for Mike Zaringhalam

Mike Zaringhalam

Developer, PC Richard & Son
Have you ever wanted to meet someone who started Hawaiian Shirt Fridays at their work place? If the answer is 'Yes!', then feel free to reach out with any questions you have regarding Hawaiian shirts... Or IBM i related topics. My main focuses are RDi, DB2, Modernization, and D... Read More →
Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 7 1150 Magic Way, Anaheim, CA 92802

9:15am PDT

Run Away Queries Got You Down
Wednesday May 21, 2025 9:15am - 10:15am PDT
Having negative performance impacts from query tools like Query/400, QMF, Showcase, Tableau and others because of the "query from heck" eating up system resources? Is your system open to security exposures from wide-open ODBC type connections? This session will cover options including using the new-ish Db2 Query Supervisor to control and/or audit long-running queries.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →
Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

10:45am PDT

API Enable Your Database
Wednesday May 21, 2025 10:45am - 11:45am PDT
How important is delivering business data to your users and customers? I’d bet it’s among the top concerns of any development effort. How do you deliver data in the modern world? Rest API are one of the most common methods. We’ll explore, though live demos, how to expose data in a safe and secure manner using Integrated Web Services (IWS). Our focus will be on directly leveraging the DATBASE with SQL, not using RPG or Service program.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →
Wednesday May 21, 2025 10:45am - 11:45am PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

10:45am PDT

Inject more security into Db2 for i
Wednesday May 21, 2025 10:45am - 11:45am PDT
In this new session, Scott will explore the many ways that “bad actors” can attempt to subvert the security on IBM i. Whether the topic is protecting against SQL Injection, closing doors to acquiring elevated privileges, or attempting to discover unprotected objects, this session will include techniques for evaluation and protection of your IBM i. Attend this session to take a big step towards discovering and eliminating attack vectors within Db2 for i!
 
Speakers
avatar for Scott Forstie

Scott Forstie

STSM, Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
Wednesday May 21, 2025 10:45am - 11:45am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

3:45pm PDT

Stepping through SQL Performance
Wednesday May 21, 2025 3:45pm - 4:45pm PDT
Every SQL statement has a predefined steps that it must go through before it can complete you data base requests.  Each step taken can positively or negatively impact SQL performance - especially on transactional applications that are running the same set of SQL statements over and over again. This session will explain each step needed to run an SQL statement and the structures that Db2 creates that can impact performance. In addition, this session will review application design and settings that can impact the performance of the required steps.
Speakers
avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →
Wednesday May 21, 2025 3:45pm - 4:45pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -