OpenWorld 2017–grab ALL of the content

Some people use the session catalog to grab just the presentations that they either attended, or could not attend.

Other people want a download of every available presentation so they can peruse the entire catalog offline at a later date.

I am one of the latter people. Smile

So using some node, javascript, awk, sed, grep I managed to data-mine the catalog page to come up with a list of uploaded presentations in the form:


wget --no-check-certificate -O "SessionTitle".extension "https://static.rainfocus.com/full_path_to_presentation.extension"

which of course can then be run as a batch file to grab them all. Woo hoo !!!

You can download the batch file which contains the 932 download commands here

I can’t make any guarantees the list is complete, or that the script will work without error, but it should be a good starting point, and it will be a lot faster than clicking on each presentation !

If it does not work for you, my apologies.  If it does work for you and saves you a lot of time, just don’t forget that I like beer or gin&tonic next time you see me. Smile

Enjoy !

Oracle Developer Community Appreciation Day

OK, time for some controversy Smile

My ODC appreciation post is about support.oracle.com

Now I’m sure there will people in the community just itching to lose their proverbial about how they lost years of their lives waiting on the support response or similar complaint, and since I work for Oracle, they will be just as keen to jump on the bandwagon and claim that I’m just shilling for the company I work for.

But I’m not denying that our support resource could be better.  Any company’s support resources can be better. 

This post is about the value I get from support.oracle.com when answering questions on asktom.oracle.com.  Yes, there is some out-dated or incorrect content on there, but there is also some awesome content on there.  Many times I find myself quoting MOS notes when providing background information for a question on AskTOM.

So this is my thank you to the people who contribute support notes to MOS.

Because I’m pretty sure it’s a thankless task.

image

OpenWorld 2017–where is the tech content ?

I can’t actually remember how many OpenWorld conferences I have attended. At a guess it would be around 7 or 8. Every year there is a criticism that there is “not enough technical content”.

Well I’m calling “fake news” on that. I can’t remember a time that I’ve struggled to find sessions that I’m interested in. Don’t get me wrong – I would love it if there was double the technical content especially in the core database area, but there’s a pretty simple reason for that. I’m a technically-oriented database-oriented kinda guy Smile. I’m sure that as I type this post, there is probably an Oracle Apps Functional Analyst preparing a blog post about how database content has gone overboard and there should be more Apps content. It’s a fact of life that you can’t please everyone.

“But I looked at the agenda, and a lot of it says ‘in the cloud'” I hear you exclaim. “It will all just be advertising!”.

Yeah, I’m calling “fake news” on that claim as well. Think about that for a second. If I’m submitting a talk for a conference that has a heavy emphasis on cloud architectures, then “Duh!”, of course I’m going to have “cloud” in the title or the synopsis. Because one of the prerequisites for giving a talk at the conference is getting the damn thing accepted ! I suspect some of the cynics that claim the agenda has not enough technical content perhaps have not taken the effort to actually study it.

But you need not worry… Some kind person has done that for you Smile. Having enough technical content is the least of your problems if you’re attending OpenWorld 2017. I’ve been through the session catalog and scraped out those sessions that I have an interest in, and even from my narrow database-centric perspective, I still have a massively tough task of deciding between multiple clashing sessions for almost every single timeslot. And as an Oracle employee, it will be even harder, because I have to wait until all of the conference attendees have entered the session, and only then do I get in if there are a few seats still vacant!

So here’s my list of sessions I’d love to attend at OpenWorld. Click on the code for each to get more details, or (if you are an attendee) to add them to your session builder … you lucky devils! Smile

Sunday 9:45

  • Franck Pachot Multitenant: Trust It by Understanding Beyond What Is Documented SUN1051 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 09:45 01-OCT-2017 09:45
  • Gary Gordhamer Oracle and NLS SUN5637 Moscone South – Room 155 01-OCT-2017 09:45 01-OCT-2017 09:45
  • Jason Arneil Cloud Networking for Beginners SUN1230 Marriott Marquis (Yerba Buena Level) – Nob Hill A/B 01-OCT-2017 09:45 01-OCT-2017 09:45

Sunday 10:45

  • Adeesh Fulay Docker 101 for Oracle DBAs SUN5617 Moscone South – Room 151 01-OCT-2017 10:45 01-OCT-2017 10:45
  • Francis Mignault Cloudy with a Chance of Oracle Application Express SUN6246 Marriott Marquis (Yerba Buena Level) – Salon 4-6 01-OCT-2017 10:45 01-OCT-2017 10:45
  • Debra Lilley,Ralf Koelling,Jan-Peter Timmermann EOUC Database ACES Share Their Favorite Database Things SUN2413 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 10:45 01-OCT-2017 10:45
  • Peter Koletzke Leveraging Oracle Database SQL and PL/SQL to Simplify User Interface App Dev SUN6252 Marriott Marquis (Yerba Buena Level) – Salon 10/11 01-OCT-2017 10:45 01-OCT-2017 10:45
  • Sai Janakiram Penumuru A 360-Degree View of Oracle Database Cloud Service SUN5296 Moscone South – Room 160 01-OCT-2017 10:45 01-OCT-2017 10:45
  • Stephen Kost The Thrifty DBA Does Database Security SUN5690 Moscone South – Room 159 01-OCT-2017 10:45 01-OCT-2017 10:45
  • Wayne Martin,Arun Sar Ingesting Data from Oracle Database 12cR2 in a Hadoop System SUN5615 Moscone South – Room 157 01-OCT-2017 10:45 01-OCT-2017 10:45

Sunday 11:45

  • Alex Zaballa Let’s Get Started with Oracle Database Cloud SUN1871 Moscone South – Room 314 01-OCT-2017 11:45 01-OCT-2017 11:45
  • Debra Lilley,Ralf Koelling,Jan-Peter Timmermann EOUC Developer Champions Show the Cool Tech They Use SUN2415 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 11:45 01-OCT-2017 11:45
  • Harris Baskaran SSL Securing Oracle Database: Goodbye Passwords SUN5642 Moscone South – Room 159 01-OCT-2017 11:45 01-OCT-2017 11:45
  • James Czuprynski Oracle Database In-Memory: Adventures with SwingBench TPC-DS SUN5644 Moscone South – Room 153 01-OCT-2017 11:45 01-OCT-2017 11:45
  • Yalim Gerger Version Control for PL/SQL SUN5700 Moscone South – Room 157 01-OCT-2017 11:45 01-OCT-2017 11:45

Sunday 12:45

  • Ludovico Caldara Get the Most Out of Oracle Data Guard SUN1399 Marriott Marquis (Yerba Buena Level) – Nob Hill A/B 01-OCT-2017 12:45 01-OCT-2017 12:45
  • Janis Griffin Need for Speed: Top Five Oracle Performance Tuning Tips SUN5647 Moscone South – Room 153 01-OCT-2017 12:45 01-OCT-2017 12:45
  • Oren Nakdimon Write Less (Code) with More: Oracle Database 12c New Features SUN2990 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 12:45 01-OCT-2017 12:45
  • Riyaj Shamsudeen Oracle Automatic Storage Management and Internals SUN5682 Moscone South – Room 155 01-OCT-2017 12:45 01-OCT-2017 12:45

Sunday 13:45

  • Brendan Tierney SQL: One Language to Rule All Your Data SUN1238 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Jonathan Dixon Alexa, How Do You Work with Oracle REST Data Services? SUN6251 Marriott Marquis (Yerba Buena Level) – Salon 4-6 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Julian Dontcheff DBA Types SUN1111 Marriott Marquis (Yerba Buena Level) – Nob Hill A/B 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Pini Dibask Database Consolidation Using Oracle’s Multitenant Architecture SUN5677 Moscone South – Room 153 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Simon Pane,Ivica Arsov Securing Your DBA Monitoring and Backup Scripts SUN5687 Moscone South – Room 159 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Stewart Bryson Kafka, Data Streaming, and Analytics Microservices SUN5693 Moscone South – Room 157 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Tariq Farooq,francisco munoz alvarez Under a Cloudy Sky: The Different Types of Skies SUN4396 Moscone South – Room 313 01-OCT-2017 13:45 01-OCT-2017 13:45
  • Tim Gorman Linux/UNIX Tools for Oracle DBAs SUN5694 Moscone South – Room 151 01-OCT-2017 13:45 01-OCT-2017 13:45

Sunday 14:45

  • Alex Nuijten Life After Oracle Forms: The Move to Oracle Application Express SUN6274 Marriott Marquis (Yerba Buena Level) – Salon 4-6 01-OCT-2017 14:45 01-OCT-2017 14:45
  • Ami Aharonovich Exploring Oracle Database Partitioning New Features and Best Practices SUN5065 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 14:45 01-OCT-2017 14:45
  • Markus Flechtner Application Containers: Multitenancy for Database Applications SUN3110 Marriott Marquis (Yerba Buena Level) – Nob Hill A/B 01-OCT-2017 14:45 01-OCT-2017 14:45
  • Nelson Calero Redefining Tables Online Without Surprises SUN3541 Moscone South – Room 314 01-OCT-2017 14:45 01-OCT-2017 14:45

Sunday 15:45

  • Heli Helskyaho,Elise Valin-Raki,Tuomas Pystynen Oracle Private Cloud Built with Engineered Systems in Fennia Insurance Company SUN4487 Marriott Marquis (Golden Gate Level) – Golden Gate A 01-OCT-2017 15:45 01-OCT-2017 15:45
  • John King Oracle Database 12c New Features for Developers and DBAs SUN5654 Moscone South – Room 157 01-OCT-2017 15:45 01-OCT-2017 15:45
  • Martin D’Souza Explore Oracle Application Express APIs SUN6244 Marriott Marquis (Yerba Buena Level) – Salon 4-6 01-OCT-2017 15:45 01-OCT-2017 15:45
  • Mauro Pagano Adaptive Plans on Oracle Database 12c SUN5664 Moscone South – Room 155 01-OCT-2017 15:45 01-OCT-2017 15:45
  • Rita Nunez Managing Oracle Database in Oracle Database Exadata Express Cloud Service SUN3575 Moscone South – Room 314 01-OCT-2017 15:45 01-OCT-2017 15:45

Monday 11:00

  • Burt Clouse,Michael Sukhenko,Sreedhar Bobbadi Database Management with Gold Images: Easily Provision, Patch, and Upgrade CON6706 Moscone West – Room 3004 02-OCT-2017 11:00 02-OCT-2017 11:00
  • Geertjan Wielenga,Lucas Jellema,John Brock,Andrejus Baranovskis,Filip Huysmans,Luc Bors Getting Started with Oracle JavaScript Extension Toolkit CON3935 Moscone West – Room 3001 02-OCT-2017 11:00 02-OCT-2017 11:00
  • Mohamed Taman Effective Design of RESTful APIs CON1206 Moscone West – Room 2005 02-OCT-2017 11:00 02-OCT-2017 11:00
  • Perry Harrington,Mirko Ortensi MySQL DBA Primer HOL7298 Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 7 02-OCT-2017 11:00 02-OCT-2017 11:00
  • Sergiusz Wolicki New Paradigm for Case-Sensitivity and Collation on Oracle Database 12c Release 2 CON6551 Moscone West – Room 3008 02-OCT-2017 11:00 02-OCT-2017 11:00

Monday 11:30

  • I’ll be in the theatre area in the Demo Grounds doing a lightning talk on Multi-tenant and In-Memory in 12c Release 2

Monday 12:15

  • Geertjan Wielenga,Lucas Jellema,John Brock,Andrejus Baranovskis,Filip Huysmans,Luc Bors Java Versus JavaScript for the Enterprise? CON6063 Moscone West – Room 2007 02-OCT-2017 12:15 02-OCT-2017 12:15
  • John Heimann How Safe Am I? Choosing the Right Security Tool for the Job CON6303 Moscone South – Room 313 02-OCT-2017 12:15 02-OCT-2017 12:15
  • Shay Shmeltzer,Patrik Frankovic Introduction to Oracle’s Visual Low-Code Development Platform CON6510 Moscone West – Room 3001 02-OCT-2017 12:15 02-OCT-2017 12:15

Monday 13:15

  • Avi Miller,Marshall Weymouth,Brian Grad Tips for Securing Your Docker Containers CON6462 Marriott Marquis (Yerba Buena Level) – Salon 13 02-OCT-2017 13:15 02-OCT-2017 13:15
  • Bruce Lowenthal,Juan Perez-Etchegoyen To Patch or Not to Patch: Answering the CPU Question CON6302 Moscone South – Room 313 02-OCT-2017 13:15 02-OCT-2017 13:15
  • Eleanor Meritt New Release Model for Oracle Database CON6550 Moscone West – Room 3014 02-OCT-2017 13:15 02-OCT-2017 13:15
  • Jeff Smith What’s New in Oracle REST Data Services and Oracle SQL Developer CON6669 Moscone West – Room 3012 02-OCT-2017 13:15 02-OCT-2017 13:15

Monday 14:15

  • George Lumpkin What’s New in Oracle Database 12c for Data Warehousing CON6643 Moscone West – Room 3010 02-OCT-2017 14:15 02-OCT-2017 14:15
  • Heli Helskyaho,Elise Valin-Raki,Tuomas Pystynen Design Your Databases Straight to the Cloud CON1846 Moscone West – Room 3007 02-OCT-2017 14:15 02-OCT-2017 14:15
  • Juan Loaiza Oracle Exadata: Disruptive New Memory and Cloud Technologies CON6661 Moscone West – Room 3014 02-OCT-2017 14:15 02-OCT-2017 14:15
  • Roel Hartman Docker for Dummies CON1049 Moscone West – Room 3005 02-OCT-2017 14:15 02-OCT-2017 14:15

Monday 15:15

  • Alan Williams,Keith Wilcox NEW FEATURE! Centralized Database User Management Using Active Directory CON6574 Moscone West – Room 3011 02-OCT-2017 15:15 02-OCT-2017 15:15
  • Jeff Smith Oracle SQL Developer: GUI, CLI, or Browser? CON6670 Moscone West – Room 3012 02-OCT-2017 15:15 02-OCT-2017 15:15


Monday 15:30

  • I’ll be in the theatre area in the Demo Grounds doing a lightning talk on hierarchy SQL and the WITH clause

Monday 16:45

  • Guido Schmutz Apache Kafka: Scalable Message Processing and More CON6156 Moscone West – Room 2004 02-OCT-2017 16:30 02-OCT-2017 16:30
  • Chaitanya Koratamaddi Oracle Application Express 5.2 New Features CON6739 Moscone West – Room 3002 02-OCT-2017 16:45 02-OCT-2017 16:45
  • Chaitanya Pydimukkala,Sai Devabhaktuni,Bobby Curtis Oracle Data Integration Platform Empowers Enterprise-Grade Big Data Solutions CON6893 Marriott Marquis (Golden Gate Level) – Golden Gate B 02-OCT-2017 16:45 02-OCT-2017 16:45
  • George Lumpkin Data Warehousing for Everybody: Oracle Data Warehouse Cloud Service CON6647 Moscone West – Room 3004 02-OCT-2017 16:45 02-OCT-2017 16:45
  • Julian Dontcheff Oracle RAC 12c Release 2: Operational Best Practices CON6684 Moscone West – Room 3014 02-OCT-2017 16:45 02-OCT-2017 16:45
  • Lisa Considine Five Inexpensive Tricks to Accelerate Oracle Database Using x86 CON7580 Marriott Marquis (Yerba Buena Level) – Nob Hill A/B 02-OCT-2017 16:45 02-OCT-2017 16:45
  • Nancy Ikeda,Christopher Jones,Anthony Tuininga Oracle Net Services 12c: Best Practices for Database Performance and Scalability CON6718 Moscone West – Room 3011 02-OCT-2017 16:45 02-OCT-2017 16:45
  • Santanu Datta,Christian Shay Oracle and .NET: Intro and What’s New CON6722 Moscone West – Room 3012 02-OCT-2017 16:45 02-OCT-2017 16:45

Monday 17:45

  • Lawrence Mcintosh,Ken Kutzer Best Practices for implementing Database Security CON6434 Marriott Marquis (Yerba Buena Level) – Nob Hill A/B 02-OCT-2017 17:45 02-OCT-2017 17:45
  • Michael Hichwa Low-Code Rapid Application Development CON6685 Moscone West – Room 3002 02-OCT-2017 17:45 02-OCT-2017 17:45
  • Pedro Lopes NEW! Database Security Assessment Tool Discovers Top Security Risks CON6575 Moscone West – Room 3011 02-OCT-2017 17:45 02-OCT-2017 17:45

Tuesday 11:00

  • Chris Richardson ACID Is So Yesterday: Maintaining Data Consistency with Sagas CON2832 Moscone West – Room 2005 03-OCT-2017 11:00 03-OCT-2017 11:00
  • Hermann Baer,Yasin Baskan What Everybody Should Know About Oracle Partitioning CON6638 Moscone West – Room 3008 03-OCT-2017 11 03-OCT-2017 11:00
  • Julian Dontcheff,Anil Nair,Markus Michalewicz Oracle RAC 12c Release 2 and Cluster Architecture Internals CON6690 Moscone West – Room 3004 03-OCT-2017 11 03-OCT-2017 11:00

Tuesday 11:30

  • Dominic Giles, Maria Colgan Oracle Database and the Internet of Things CON7121 Moscone West – Room 3011 03-OCT-2017 11:30 03-OCT-2017 11:30
  • Colm Divilly Oracle REST Data Services/Oracle Database REST API CON6662 Moscone West – Room 3012 03-OCT-2017 11:30 03-OCT-2017 11:30
  • Gp Gongloor,Sriram Vrinda,Konstantin Kerekovski SQL Tuning for Expert DBAs CON7091 Moscone West – Room 3018 03-OCT-2017 11:30 03-OCT-2017 11:30
  • Tirthankar Lahiri,Ananth Raghavan,Doug Hood Oracle Database In-Memory Deep Dive: Past, Present, and Future CON6584 Moscone West – Room 3014 03-OCT-2017 11:30 03-OCT-2017 11:30

Tuesday 12:45

  • Bryn Llewellyn Ten Rules for Doing a PL/SQL Performance Experiment CON7639 Moscone West – Room 3011 03-OCT-2017 12:45 03-OCT-2017 12:45
  • Colm Divilly Securing Your RESTful Services CON6667 Moscone West – Room 3012 03-OCT-2017 12:45 03-OCT-2017 12:45

Tuesday 13:15

  • Connor Mcdonald Leaner, Faster Code with Advanced SQL Techniques CON3557 Moscone West – Room 2002 03-OCT-2017 13:15 03-OCT-2017 13:15 RubberStamp-Must-See

Tuesday 15:00

  • Dan Mcghan Creating RESTful Web Services the Easy Way with Node.js CON1242 Moscone West – Room 2002 03-OCT-2017 15:00 03-OCT-2017 15:00

Tuesday 15:45

  • Dan Mcghan,Chris Saxon 12 Things Developers Will Love About Oracle Database 12c Release 2 CON6734 Moscone West – Room 3014 03-OCT-2017 15:45 03-OCT-2017 15:45
  • Martin Gubar Oracle Big Data SQL: Roadmap to High-Performance Data Virtualization CON6644 Moscone West – Room 3010 03-OCT-2017 15:45 03-OCT-2017 15:45

Tuesday 16:45

  • Stephan Haisley,Sai Krishnamurthy Maximizing Availability for Oracle GoldenGate Microservices CON6570 Moscone West – Room 3014 03-OCT-2017 16:45 03-OCT-2017 16:45

Tuesday 17:45

  • Connor Mcdonald Using Advanced SQL Techniques for Faster Applications CON6735 Moscone West – Room 3014 03-OCT-2017 17:45 03-OCT-2017 17:45 RubberStamp-Must-See

Wednesday 09:45

  • Nancy Ikeda,Christopher Jones,Anthony Tuininga Python and Oracle Database 12c: Scripting for the Future HOL7605 Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 6 04-OCT-2017 09:45 04-OCT-2017 09:45

Wednesday 11:00

  • Greg Drobish Oracle Database 12c Storage Features that Cut Database Tuning Time by 67 Percent CON4671 Marriott Marquis (Yerba Buena Level) – Nob Hill C/D 04-OCT-2017 11:00 04-OCT-2017 11:00
  • Juergen Mueller,Andrew Holdsworth Why the Fastest IO Is Still the One You Don’t Do CON6560 Moscone West – Room 3012 04-OCT-2017 11:00 04-OCT-2017 11:00
  • Mark Drake NoSQL Development and JSON Support in the Next Generation of Oracle Database CON6636 Moscone West – Room 3011 04-OCT-2017 11:00 04-OCT-2017 11:00
  • Mark Fallon Inside the Head of a Database Hacker CON6572 Moscone West – Room 3014 04-OCT-2017 11:00 04-OCT-2017 11:00
  • Thomas Baby Oracle Multitenant: Ask the Architects CON6731 Moscone West – Room 3010 04-OCT-2017 11:00 04-OCT-2017 11:00
  • Tim Goh,Michael Schulman NoSQL Data Modeling for RDBMS Users CON6545 Moscone West – Room 3008 04-OCT-2017 11:00 04-OCT-2017 11:00

Wednesday 12:00

  • Gregg Christman Get the Best Out of Oracle Compression CON6577 Moscone West – Room 3006 04-OCT-2017 12:00 04-OCT-2017 12:00
  • Pravin Jha Oracle Database 12.2: Lockdown Profiles CON6424 Moscone West – Room 3016 04-OCT-2017 12:00 04-OCT-2017 12:00
  • Gerald Venzl, Maria Colgan Oracle Database Features Every Developer Should Know About CON6558 Moscone West – Room 3020 04-OCT-2017 12:00 04-OCT-2017 12:00

Wednesday 13:00

  • Connor Mcdonald War of the Worlds: DBAs Versus Developers CON6737 Moscone West – Room 3014 04-OCT-2017 13:00 04-OCT-2017 13:00 RubberStamp-Must-See

Wednesday 14:00

  • Mike Dietrich,Jay Barnhart Migrate a 100 TB Database Cross-Platform in Less Than a Day CON6467 Moscone West – Room 3004 04-OCT-2017 14:00 04-OCT-2017 14:00
  • Dominic Giles, Maria Colgan Five Things You Might Not Know About Oracle Database CON6631 Moscone West – Room 3020 04-OCT-2017 14:00 04-OCT-2017 14:00

Wednesday 14:45

  • Dan Mcghan Building Real-time Data in Web Applications with Node.js CON1240 Moscone West – Room 2003 04-OCT-2017 14:45 04-OCT-2017 14:45

Wednesday 15:30

  • Bryn Llewellyn Guarding Your Data Behind a Hard Shell PL/SQL API CON6633 Moscone West – Room 3014 04-OCT-2017 15:30 04-OCT-2017 15:30

Wednesday 16:30

  • Scott Rotondo Top Five Tips for Building Secure Database Applications CON6578 Moscone West – Room 3011 04-OCT-2017 16:30 04-OCT-2017 16:30
  • Ashish Agrawal SQL Analytics: Using Automatic Workload Repository and Active Session History CON7065 Moscone West – Room 3018 04-OCT-2017 17 04-OCT-2017 17:00
  • Tim Hall Make the RDBMS Relevant Again with RESTful Web Services and JSON CON7358 Moscone West – Room 2002 04-OCT-2017 16:30 04-OCT-2017 16:30

Wednesday 17:30

  • John King Blockchain? What Is Blockchain? Why Do I Care? CON2276 Moscone West – Room 2010 04-OCT-2017 17:30 04-OCT-2017 17:30
  • Lucas Jellema,Jurgen Leijer JavaScript to SQL: Diagnose Application Issues Across a Hybrid Infrastructure CON6914 Moscone West – Room 2024 04-OCT-2017 17:30 04-OCT-2017 17:30
  • Stewart Bryson Practical Advice from a Developer Using a Cloud-Based DevOps Environment CON7377 Moscone West – Room 2002 04-OCT-2017 17:30 04-OCT-2017 17:30

Thursday 10:45

  • Beda Hammerschmidt,Vikas Arora,Maxim Orgiyan The Top 10 Dos and Don’ts of JSON Processing in a Database CON4647 Marriott Marquis (Golden Gate Level) – Golden Gate C1/C2 05-OCT-2017 10:45 05-OCT-2017 10:45

Thursday 13:45

  • Brendan Tierney Is SQL the Best Language for Statistics and Machine Learning? CON7350 Marriott Marquis (Golden Gate Level) – Golden Gate C3 05-OCT-2017 13:45 05-OCT-2017 13:45


Thursday 14:45

  • Heli Helskyaho,Elise Valin-Raki,Tuomas Pystynen The Basics of Machine Learning CON7354 Marriott Marquis (Golden Gate Level) – Golden Gate C1/C2 05-OCT-2017 14:45 05-OCT-2017 14:45
  • Lucas Jellema,Jurgen Leijer How End User Monitoring and Selenium Can Help Troubleshoot Customer issues CON6912 Marriott Marquis (Golden Gate Level) – Golden Gate C3 05-OCT-2017 14:45 05-OCT-2017 14:45

 

And as I mentioned before…the whole AskTOM team will be at OpenWorld for the week

The AskTOM team at OpenWorld 2017

The AskTOM team will be out and about at OpenWorld in October, so if you are at the conference as a full attendee, or just with a Discovery pass, please come up and say Hi!  As well as our session talks, we’ll be doing impromptu discussions and mini-sessions during the week either in the Developer Lounge area or the Exhibition Hall, so keep your eyes open on the OpenWorld twitter feeds during the week.  You can see our session times below. 

Obviously OpenWorld is a big event, and since sports TV stations go totally over the top with promotion when big events are coming up, I thought to myself: “Why should they have all the fun ?”.  So crank up the volume to maximum, and get down with our pumping AskTOM promo video for OpenWorld ! Smile

Our Sessions

Connor McDonald

War of the Worlds: DBAs Versus Developers

Wednesday, Oct 04, 1:00 p.m. – 1:45 p.m. | Moscone West – Room 3014
Don’t let the name deceive you – this is a technical session covering a myriad of 12c Release 2 features for both DBAs and Developers. For decades, developers and DBAs have battled over who controls the world. As cloud databases now free DBAs from the mundane the battle flares again, as developers need greater flexibility, less structure, and faster turnaround to deploy. DBAs use a more methodical approach, worried about the wreckage that may result from playing so fast and loose. But does that just make the DBA an inhibitor to your productivity? Who is right? Perhaps both? Can developers and DBAs peacefully coexist? Maybe they just need the right technology. In this session see how to integrate the demands of the modern-day developer with the Oracle Database (and the modern-day administrators). 

Click here to register.

Leaner, Faster Code with Advanced SQL Techniques

Tuesday, Oct 03, 1:15 p.m. – 2:00 p.m. | Moscone West – Room 2002
Most SQL is so simple to write that we can hand off the job to an ORM tool or a similar mechanism. But by delving a little deeper into more-advanced SQL facilities, we can get performance benefits and write a lot less middle-tier code. This session highlights some SQL techniques for solving problems that would otherwise require a lot of complex coding. Learn how to become a more productive developer by expanding your knowledge of the SQL language.

Click here to register
 
Using Advanced SQL Techniques for Faster Applications

Tuesday, Oct 03, 5:45 p.m. – 6:30 p.m. | Moscone West – Room 3014
Most SQL is so simple to write that you can hand off the job to an object-relational mapping tool or similar mechanism. But by delving a little deeper into more advanced SQL techniques, we can get performance benefits and write a lot less middle-tier code. This session highlights some SQL techniques to solve problems that would otherwise require a lot of complex coding. Learn how to become a more productive developer by expanding your knowledge of the SQL language.

Click here to register

 

Also, I’ll be doing some mini-lessons in The Exchange

Ask TOM’s Favorite Multitenant/In-Memory Features in Oracle Database 12c R2

Monday, Oct 02, 11:30 a.m. – 11:50 a.m. | The Exchange @ Moscone West – Showcase Theater 2

Click here to register

 

Ask TOM Hard Core SQL: Common Table Expressions and Hierarchy Processing

Monday, Oct 02, 3:30 p.m. – 3:50 p.m. | The Exchange @ Moscone West – Showcase Theater 2

Click here to register

 

Chris Saxon

12 Things Developers Will Love About Oracle Database 12c Release 2

Tuesday, Oct 03, 3:45 p.m. – 4:30 p.m. | Moscone West – Room 3014
Oracle Database 12c Release 2 is here. The headline features are sharding, multitenant, and application containers. But it’s the small changes to SQL that make a real difference in your day-to-day life work with Oracle Database. In this session get an overview of the changes to SQL and PL/SQL that will help you build faster, more robust database applications. If you’re a developer or DBA who regularly writes SQL or PL/SQL and wants to keep up to date this session is for you.
 
How to Hack into Your Oracle Database via Node.js, Using SQL Injection

Wednesday, Oct 04, 8:30 a.m. – 9:15 a.m. | Moscone West – Room 2004
Hackers are constantly searching for personal data they can use to exploit people. And they’re often successful. Each week brings new stories of large-scale data breaches. A common attack vector is SQL injection. If your application is vulnerable to this, hackers can get whatever they want from your database. This session shows you how easy it is to access private data with SQL injection and how to change your code to stop it. It ends with a discussion of further recommendations for writing secure code. This is a must-attend session for all developers who write database access code.
(co-speaker Dan Mcghan)

 

Maria Colgan

Oracle Database Features Every Developer Should Know About

Wednesday, Oct 04, 12:00 p.m. – 12:45 p.m. | Moscone West – Room 3020
Over the years, a lot of new features have been introduced in Oracle Database to save developers time and to spare them from having to reinvent the wheel. Many of these features are actively highlighted via conference sessions or blogs when a new release is launched, but over time are forgotten before they can be put to good use. In this session learn about the critical features already existing in Oracle Database that every developer should not only know about but also utilize. Using easy-to-follow examples, see when and where you should take advantage of these features to make your life easier and help you get the most out of Oracle Database, regardless of whether you are a DBA or a developer.
(co-speaker Gerald Venzl)

Five Things You Might Not Know About Oracle Database

Wednesday, Oct 04, 2:00 p.m. – 2:45 p.m. | Moscone West – Room 3020
In this session take a look at five things you might not have known about Oracle Database—or that you might have known about but never realized how it could benefit you. Get a detailed explanation of each feature’s functionality and see the benefits through real-world examples. The topics covered are for Oracle Database 11g and Oracle Database, Standard Edition 12c, with only a couple of minor exceptions. Come away with a better understanding of these features and how they can benefit you and your organization.
(co-speaker Dominic Giles)

Oracle Database and the Internet of Things

Tuesday, Oct 03, 11:30 a.m. – 12:15 p.m. | Moscone West – Room 3011
In recent years there has been a rapid surge in the adoption of smart devices. Everything, from phones and tablets to smart meters and fitness devices, connect to the Internet and share data. With all of these smart devices comes a huge increase in the frequency and volume of data being ingested into and processed by databases. But, what most folks forget is that industries like telecoms and manufacturing have been dealing with these challenges for years with the help of their Oracle Database. This session provides step-by-step instructions for deploying a high-ingest, mission critical IoT workload on Oracle Database.
(co-speaker Dominic Giles)

Sergiusz Wolicki

New Paradigm for Case-Sensitivity and Collation on Oracle Database 12c Release 2

Monday, Oct 02, 11:00 a.m. – 11:45 a.m. | Moscone West – Room 3008
Historically, the way an Oracle Database compares and sorts character data is controlled in a pretty coarse way by the parameters NLS_SORT and NLS_COMP. This session presents a new feature of Oracle Database 12c Release 2 (12.2) that introduces a declarative method of associating collation with particular data. Using the new mechanism, data-bound collation (DBC), the user can precisely control how any given character data is compared depending just on the source of the data. For example, content of given columns may be declared as case-insensitive. The new functionality is based on the ISO/IEC SQL standard, which simplifies application porting to Oracle Database from other RDBMS systems that support similar functionality