PUG Challenge

2019 Sunday Workshops and Workshop Registration

This year all workshops are being held at the Doubletree Hotel in Manchester NH.

Because of the classroom setting there is limited seating available and we need to be able to accurately predict head-count. So you must purchase a ticket and register below to attend the Sunday workshops.

For workshops you will need to bring a laptop. Workshops use a "remote desktop" to access a "cloud" image that has all necessary Progress software and licenses pre-installed. Every workshop attendee gets a distinct login that they can use. We will keep the images running for a few days after the conference so that you can copy any code that you worked on back to your work environment.

Remote desktop clients are standard on Windows and easily available for Macs or Linux. Detailed instructions are provided the week prior to the conference.

Please make sure that your laptop is fully charged at the start of the workshop. There is a limit to the number of extension cords that we can run and there may not be enough for everyone.

Please make sure that your laptop's firewall and security software is not blocking access to the cloud! If you have a "corporate laptop" make sure that you know how to get access to cloud resources in a public classroom setting outside of your usual corporate connections.

Sunday, October 6th
Time Room Workshop
8:00 Foyer Morning Workshop Check-in
8:00 Room 1 488: Workshop: Introduction to Docker Containers
Thomas Hansen; nodeable limited

Morning Outline:
Introduction to Docker
Getting setup up with server access and Docker (hands on)
Docker basics
- Images, volumes, networking, containers
- Hands on exercises
Introduction to Docker Compose
Using Docker Compose recipes for fast container stacks

8:00 Room 2 507: Workshop: Getting Started With OpenEdge, DBA Basics
Tom Bascom; White Star Software LLC

People often ask what tasks a newly minted OpenEdge DBA should be performing? What should my daily, weekly, monthly etc checklist have on it? What's good? What's BAD? Where do I even look to find out? What do I need to pay attention to? What can I ignore? What should I lose sleep over? When should I update my resume? Who can help me? In this hands-on workshop we will show you the way through the challenges that lie in front of you and help bring peace to your weekends and evenings!

8:00 Room 3 523: Workshop: Tips & Tricks for Success with Progress Application Server for OpenEdge, Including 12.0!
Roy Ellis, Peter Judge; Progress

Progress Application Server for OpenEdge is an enterprise-class application server that connects your application business logic to a variety of client technologies in a highly-efficient and scalable way. In this workshop, we will introduce tips and tricks, with hands-on examples using the latest features in OpenEdge 12.0 to help you be successful with PASOE.

8:00 Room 4 501: Workshop: OOABL Patterns and Practises for OpenEdge
Mike Fechner, Peter Judge; Consultingwerk

12:00 Afternoon Workshop Check-in and Lunch
13:00 Room 1 489: Workshop: Docker Containers for OpenEdge
Thomas Hansen; nodeable

Introduction to OpenEdge and Docker
Databases and PASOE in containers getting started (hands on)
Introduction to Kubernetes
OpenEdge on Kubernetes anyone? (hands on)
Wrapping up and next steps
- Use cases
- Tools
- DevOps & CI/CD with Docker and OpenEdge
- Docker and OpenEdge in the Cloud

13:00 Room 2 213: Workshop: Implementing and Securing OpenEdge REST Service Interfaces
David Atkins, Dan Mitchell; Progress

This hands-on workshop provides step-by-step guidance on how to create:
- Low-code/no-code Data Object Services
Exposing JSON catalogs files, exposing database data directly, and delegating to existing ABL logic for validation and data access
- Flexible JSON-defined DataObjectHandler Service Interfaces
Providing a high degree of control over the exposed REST API without deep ABL expertise needed
- Maximum control ABL WebHandler Service Interfaces showing how to write ABL code to read/write the body, headers and parameters of inbound REST requests to map that data to/from ABL data types and to invoke appropriate existing ABL data access logic
-Property-based Spring Security
Configuring for authentication and authorization of users to access these REST APIs

13:00 Room 3
13:00 Room 4 379: Workshop: Index Maintenance Utilities Tips and Tricks
Paul Koufalis; White Star Software

Do your indexes need a little love and attention? If your answer is "Uhh...maybe?" then this hands-on DBA workshop is for you.

We will explore the various index utilities (idxbuild, idxcompact, idxfix, idxactivate, etc...) and discuss when and how to use each utility to improve query performance or troubleshoot and correct index-related issues. We will also benchmark the various startup parameters to determine which optimal values should be used under various operating conditions.

Overall, expect to walk out of this workshop knowing more than you ever thought possible about indexes and their maintenance.

13:00 Room 5
17:00 Break -- Welcome Reception Starts at 6pm

Registration will take you to the external "impactflow" website: