Thursday, June 30, 2016

Kscope16 (drive home from Chicago)

Shane and I drove home (Hibbing, MN) from Chicago via I90 and pay LOTS of tolls.  We stopped in Madison and drove up to the Wisconsin state capitol building which is neat.

Kscope16 day 4 (06/30/2016)

Deep Dive Session
We did not attend this session, instead spending time with Markus and Cristian from FOEX.

Wednesday, June 29, 2016

Kscope16 day 3 (06/29/2016)

Session 13 (8:30am-9:30am) A quick guide of Free Oracle Tuning Tools - Bjoern Rost
Chris:
PLSQLPLUS
SQLCL
WEB-ASH
MOATS
SNAPPER
ORASASH
SQLT
EDB360
SQLD360
TUNAS360

Shane:
?

Session 14 (10:15-11:15) Affordable workflow options for our APEX app - Niels de Bruijn
Chris:
PL/Flow - http://plflow.sourceforge.net old, last updated 2004, easy to install.
Flow Control - https://github/j-sieben/FCT very new, released 06/2016
Camunda - Camunda community edition (java app can run in Tomcat), supports BPMN 2.0 standards

Shane:
?

Session 15 (12:45-13:45) Release the brakes: Why is my APEX app slow - Peter Raganitsch
Chris & Shane:



Session 16 (14:00-15:00) APEX security: exposing your application to the internet - Nathan Catlow
Chris:
-He did a google search and found about 3000 APEX applications.
-Keep your infrastructure up to date (APEX version, Apache Tomcat version, Apache HTTPD version, ORDS version).
-Remove builder and SQL workshop (runtime only)
-Use the ORDS validation function
-Make sys and system passwords different than ORDS users.



Shane:
?


Session 17 (15:15-16:15) Instrumentation for Oracle DB development - Alex Nuijten
Chris:
LOGGER, newer versions support recording parameters.

Shane:
?

Session 18 (16:30-17:30) Writing SQL that sucks less - Bjoern Rost
Chris & Shane:

Monday, June 27, 2016

Kscope16 day 1 (06/27/2016)

Session 1 (8:30am-9:30am) 5 Ways of building Oracle Applications - Sten Vesterli
Chris:
Sten gave this presentation back in 1998, and there were 5, with Forms being the only common technology.
http://oratoolwatch.com
1) Forms - Data driven UI, Chrome already will not accept browser plugins, although Forms has a solution to launch java without a browser, so Forms is running via the web without a browser.  Sounds like client/server....
2) APEX - Data driven UI, Oracle has over 70,000 APEX applications.
3) ADF - MVC process driven UI.
4) JET - UI only, a toolkit, not a framework, needs LOTS of javascript code.
5) MAF - "Mobile first is stupid, Mobile only is worse!".  Only if the interaction is less than 2 minutes does anyone want it to be "Mobile".

Shane:

Session 2 (10:15am-11:15am) ORDS tips and tricks - Kris Rice
Chris:
Example of the Oracle Chicago cloud data center: 5 HTTPD servers over 2 Weblogic servers running ORDS which connect to 100s of DBs.
Size your connection pools according to your concurrent users.
select * from pool_config;
Shane:


Session 3 (11:30-12:30) APEX 5 plugins - Alan Arentson
Chris:
An APEX plugin is a collection of HTML, CSS, JS, and PLSQL.
Plugins are WAY easier in APEX 5.
Chris will be creating a Topaz signature pad plugin.

Shane:


Hands on Training (14:00-16:15) Build something IoT - Anton Nielsen
Chris:
this was AWESOME!  Built a thermostat that also logs the current temperature and current heat/AC status in an APEX.ORACLE.COM application built by my own hands.


Session 4 (14:00-15:00) ?
Session 4  06/27/2016 14:00-15:00
Shane:

Session 5 (15:15-16:15) ?
Session 5 06/27/2016 15:15-16:15
Shane:



Session 6 (16:30-17:30) The Ultimate APEX dashboard for your JIRA environment - Oliver Lemm
Chris:
Interesting application of APEX and interesting dashboard.


Shane:

Sunday, June 26, 2016

Kscope16 APEX Symposium

APEX 5.1 - Shakeeb
-Cards
-Live Template
-Font APEX
-Universal theme - look at example apps for examples.
APEX 5.1 page designer - Marc Sewtz
-lots of productivity enhancements
APEX 5.1 Jet Charts - Marc Sewtz
APEX 5.1 Interactive grids - Patrick Wolf
APEX 5.1 Other New Features - Patrick Wolf
Update from development - Joel Kallman
-The Azimuth of APEX, which is a HPRAD (High Performance Rapid Application Development) tool.
-"Nothing is given, everything is earned".

We are really excited for the release for APEX 5.1, as it will improve our development productivity.

Saturday, June 25, 2016

Kscope16 travel day (drive to Chicago)

Shane and I drove from Hibbing, MN to Chicago, IL via Milwaukee.  Nice trip.  Seeing the Milwaukee port and bridge was neat.  It seemed that there were less tolls coming into Chicago from the North.