COMMON POWERUp 2026: Full Schedule

Unlock the Power of IBM i at POWERUp 2026!

Join us in New Orleans, Louisiana for POWERUp 2026, 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!

11:15am CDT

VS Code for i - Database Extension

Monday April 27, 2026 11:15am - 12:15pm CDT

Galerie 3

Evaluation Survey

This session is a review of the newest and most awesome features added to the VS Code4i Database Extension. This is designed to be an interactive, with questions and comments from the attendees, so be ready to interact, cheer, jeer, or inspire us with your good ideas.

Learning Objectives:

1) Understand what's possible today with the VS Code4i Database Extension. 2) Understand when to use VS Code4i vs other tools 3) Interact with the VS Code4i Database Extension technology leaders

Speakers

Scott Forstie

Senior Technical Staff Member, 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 →

Sanjula Ganepola

Software Developer - IBM i App Dev & AI Toolchain, IBM

Sanjula Ganepola is a Software Developer at IBM working on IBM i application development tools. As an open-source advocate, he is an active contributor and maintainer of several Visual Studio Code extensions including IBM i Project Explorer, Code for IBM i, IBM i Testing, Source Orbit... Read More →

Monday April 27, 2026 11:15am - 12:15pm CDT
Galerie 3

Database, Database, Programmer Tools

Track Student

9:15am CDT

Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions

Tuesday April 28, 2026 9:15am - 10:15am CDT

Studio 3-4

Evaluation Survey

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).

Learning Objectives:

1. Learn how and when to use the Lateral keyword (along with correlation and cross joins). 2. Learn all the available Window Functions and how/when to use them. 3. Learn what pivoting is and how to setup an SQL procedure to do it dynamically.

Speakers

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 →

Tuesday April 28, 2026 9:15am - 10:15am CDT
Studio 3-4

Database, Programmer Tools

COMMON POWERUp 2026

11:15am CDT

Scott Forstie

Sanjula Ganepola

9:15am CDT

Mike Zaringhalam

Get help with the event