COMMON POWERUp 2023 has ended

Create Your Own Event

COMMON POWERUp 2023

The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.

10:15am MDT

161: RCAC – Row and Column Access Control – Secure your Data! Governors Square 10Birgitta Hauser

11:30am MDT

170: SQL 101 Governors Square 15Ryan Moeller

2:45pm MDT

199: SQL and IFS - Reading/Writing IFS Files with SQL Governors Square 15Birgitta Hauser

4:00pm MDT

406: Accelerate your SQL queries with SMP Governors Square 10Ryan Moeller

5:15pm MDT

210: Learn how to use OR REPLACE with SQL DDL Governors Square 14Scott Forstie

5:50pm MDT

227: Authority Collection made easy with SQL Governors Square 14Scott Forstie

8:00am MDT

156: Creating an Item Master File Data Layer with SQL PL Stored Procedures Governors Square 12Rex Smith 321: SQL: Select the language Governors Square 15Sven Jansson 374: Quick Start to Using MariaDB and PostgreSQL on IBM ii Plaza Court 2Richard Schoen

9:15am MDT

160: Speed Dating with a Date Dimension Table Plaza Court 5Doug Mack 219: Shallow Dive into Database Modernization Governors Square 11Patrick Behr 388: Analyzing geospatial data using Db2 for i Plaza Court 4Scott Forstie

10:30am MDT

216: SQL Coding Tips and Techniques Governors Square 10Kent Milligan

2:45pm MDT

101: Create or Replace … DDS Files with DDL Objects Governors Square 15Birgitta Hauser

4:00pm MDT

142: Group By, Having and multi-dimensional Grouping Governors Square 15Birgitta Hauser 290: Tips, Tricks, and Tools to Supercharge your SQL Skill Set Governors Square 12Ryan Moeller

5:15pm MDT

251: What is SYSTOOLS and how can you leverage it? Governors Square 14Scott Forstie 320: Data Sciency stuff for Dummies Plaza Court 5Doug Mack 352: Top 10 Reasons to Build Your Own SQL Indexes Governors Square 11Tom Davidson

5:50pm MDT

356: Performance Tuning, QAQQINI what you care about and how to use it Governors Square 11Tom Davidson 390: Geospatial Analytics - What About Performance? Plaza Court 7Kent Milligan

8:00am MDT

150: OLAP (Online Analytical Processing) Functions – much more than running numbers! Governors Square 15Birgitta Hauser 278: Tricks with Spool Files using SQL Governors Square 14Simon Hutchinson

9:15am MDT

147: Using SQL to Overcome Challenges when Consuming XML (Case Study) Plaza Court 2Vern Hamberg

10:30am MDT

381: SQL Plan Cache Uncovered Governors Square 10Kent Milligan

1:30pm MDT

382: Exploring the IBM OmniFind Text Search Server Plaza Court 6Kent Milligan 443: Partitioned Table Functionality Governors Square 17Sven Jansson

2:45pm MDT

258: Modernization Case Study – Creating a Database Abstraction Layer Plaza Court 4Ray Everhart 273: ACS & Db2 for i – Explained Governors Square 11Tim Rowe • Ryan Moeller 300: Visualizing Data With SQL and Web Query Governors Square 10John Westcott

8:00am MDT

201: Revving up SQL Performance with Indexes Governors Square 14Kent Milligan 301: Dimensional Modeling: The Star of the Show? Governors Square 10John Westcott 319: Run Away ODBC or Query/400 Queries Got you Down? Plaza Court 4Doug Mack 322: Select with functions Governors Square 15Sven Jansson 355: Performance Tuning, separation of work and memory sizing Governors Square 12Tom Davidson

9:15am MDT

157: Get Running with the IBM Db2 for i .NET Provider Plaza Court 4Rex Smith 323: The join and sub select union Governors Square 15Sven Jansson

10:30am MDT

109: What's New in Db2 for i Governors Square 12Scott Forstie 135: Expand Your Options using Query Management Plaza Court 5Vern Hamberg 200: Data-Centric Thinking: Moving Business Logic into the Database Governors Square 15Birgitta Hauser 274: Sharing Data Between Partitions with the SQL Three-Part Name Governors Square 14Simon Hutchinson 367: ODBC speed and security Plaza Court 4Jack Woehr

1:30pm MDT

165: ODBC: A Better Way to Connect to Db2 Governors Square 15Mark Irish 228: String Manipulation and Regular Expressions with SQL Governors Square 16Birgitta Hauser 275: Temporal Tables – Looking Back Into Your Data’s Past Governors Square 14Simon Hutchinson 389: Simple Steps to Improving Data Security on IBM i Plaza Court 2Kent Milligan • John Westcott

2:45pm MDT

215: SQL & Temp Tables - Good or Bad Combination? Governors Square 14Kent Milligan 299: Streaming/Replicating Db2i Data into "The Cloud" Governors Square 10John Westcott

4:00pm MDT

324: Create table, insert, update, delete Governors Square 15Sven Jansson 354: Performance Tuning, Tips and Techniques Governors Square 17Tom Davidson