Annual General Meeting 2018

    December 06, 2018 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Thursday, December 06, 6:00 - 8:00pm
    BC Liquor Distribution Branch
    3200 East Broadway
    Vancouver, BC

    Dear Members,

    You are cordially invited to attend the society's Annual General Meeting (AGM) for 2018. Registration is required for security purposes.

    The Victoria Oracle Users Group Society is the IOUG sponsored incorporated entity that oversees the operation of the BC Oracle User Group. This is the required legal body that is able to accept donations, pay expenses, and conduct business. The AGM is a legal requirement, during which financial statements are presented and the board of directors are elected.

    Agenda

    • AGM call to order
    • Review and approval of last year's (2017) AGM minutes
    • Report of the activities in 2018
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2018
    • Nomination and election of the board of directors
    • Activities and events for 2019
    • Any other business

    Please note that this is a business meeting only. There are no presentations, but a light dinner and refreshments will be provided.

    For members unable to attend the event in person, you may be able to join us via conference call. Please indicate in your registration that you wish to attend the meeting remotely and details will be provided to you.

    Real Life SQL Tuning and Logger

    October 10, 2018 06:00 PM - 09:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event on October 10, 2018.

     

    Session 1

    Topic: Real Life SQL Tuning: From 4 Minutes to 8 Seconds in an Hour

    Speaker: Liron Amitzi, DBAces

    Abstract

    In 20 years of SQL tuning, I have learned many things. The number of elements that affect query tuning is huge: tables' structure, indexes, optimizer behavior and the SQL text itself are only some of them. In this session we will dive into an example of SQL tuning, based on real life experience. Together we will identify the problem, analyze it (from understanding the schema and the application logic to looking at the object structure and SQL text) and fix it, while learning the techniques and gaining some best practices of performance tuning. As a side note, we will also see why the relationship between the DBA and the developer is so important.

     

    Session 2

    Topic: Logger: Everyone's Using It, Why Aren't You?

    Speaker: Martin D'Souza, Insum Solutions

    Abstract

    Code Instrumentation (i.e. logging) can be a huge time saver in your code. Most organizations don't instrument their code, do a hack job (using dbms_output and then removing it before release), create their own logging platform, or use Logger (github.com/oraopensource/logger).

    For those not using Logger, this talk is for you. It'll cover the basics of Logger, an open source PL/SQL logging tool. If you're already using Logger, this talk will cover new features and future plans.

    This talk is suitable for both managers and developers as proper code instrumentation can significantly reduce development/debugging time and aid in production issues.

     

    About the Speakers

    Liron Amitzi - DBAces

    Liron is an Oracle ACE and a senior Oracle DBA consultant, with 20 years of experience. During these years Liron worked as a senior consultant with a large number of companies in various fields and managed an Oracle Professional Services Team. He mainly specializes in high availability solutions, performance, backup and recovery, and other infrastructure and application database areas. Liron is the president of BCOUG (British Columbia Oracle User Group), the US Events Chair and IOUG Liaison of Oracle RAC SIG, and he is also a well-known instructor and lectures in Oracle courses, events and forums.

     

    Martin D'Souza - Insum Solutions

    Martin D'Souza is the director of innovation at Insum. He is also the founder of OraOpenSource. Throughout his career, Martin has held a range of positions within award-winning companies. His experience in the technology industry has been focused on developing database-centric web applications using the Oracle technology stack. Martin is the author of the popular blog talkapex.com and a designated Oracle ACE director. He has co-authored and authored various APEX books and is an active participant in a number of open-source projects, such as Logger. Martin has also presented at numerous international conferences such as APEX Connect, Oracle OpenWorld, and ODTUG Kscope.

     

    Post-Tech Day Blues?

    June 20, 2018 06:00 PM - 09:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event on June 20, 2018.

     

    Session 1

    Topic: SQL Plan Baseline Methods and Use Cases

    Speaker: Frank Liu, Save on Foods

    Abstract

    Have you seen a query that is hanging suddenly, when it normally run in seconds?

    Have you seen a query that runs significantly slow after upgrade?

    They are all related to plan regression, and it could impact user experience, or causing application outage in worst case.To address this issue, we need to understand plan regression, and use SQL plan management to stabilize execution plans.

    This presentation discusses different methods to create a SQL baseline. These methods can be applied to different use cases, such as query with bind variables, query without bind variables, plan migration between databases, plan stabilization in upgrades, etc.

     

    Session 2

    Topic: APEX 18.1 New APIs

    Speaker: Martin D'Souza, Insum Solutions

    Abstract

    APEX comes with a set of APIs that help simplify both your APEX and PL/SQL development. Most developers aren't aware of the many features in the set of APIs. This presentation will introduce the APEX APIs while highlighting some of the best APIs released as part of APEX 18.1.

     

    About the Speakers

    Frank Liu - Save on Foods

    Frank is an Oracle certified professional. He has over 20 years development and database administration experience, currently working as database administrator.

    He has worked on oracle upgrade, performance tuning, Oracle Internet Directory, Oracle Enterprise Security, and Exadata administration.

     

    Martin D'Souza - Insum Solutions

    Martin D'Souza is the director of innovation at Insum. He is also the founder of OraOpenSource. Throughout his career, Martin has held a range of positions within award-winning companies. His experience in the technology industry has been focused on developing database-centric web applications using the Oracle technology stack. Martin is the author of the popular blog talkapex.com and a designated Oracle ACE director. He has co-authored and authored various APEX books and is an active participant in a number of open-source projects, such as Logger. Martin has also presented at numerous international conferences such as APEX Connect, Oracle OpenWorld, and ODTUG Kscope.

     

    BCOUG Tech Day 2018

    April 27, 2018 08:30 AM - 06:00 PM

    The British Columbia Oracle Users Group (BCOUG) is proud to present its inaugural Tech Day. This is a full-day event with multiple parallel sessions to get up to speed on the latest developments in Oracle Database and developer technologies.

     

    UPDATE: Attendees registered before April 13, 2018, 11 pm, will receive a $15 Starbucks card!

     

    Keynote Sessions

    IT Wars - DBA Versus Developer
    For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald takes on the role of lead developer on a project to deploy a RESTful web-based application, while Maria takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trend without exposing the business to painful availability or security vulnerabilities. Can developers and DBAs peacefully coexist? Join us in this session and find out!
     

    Maria Colgan profile photo

    Maria Colgan
    Master Product Manager
    Oracle Corporation

     

    Gerald Venzl profile photo

    Gerald Venzl
    Senior Principal Product Manager
    Oracle Corporation

     

    Agenda

    Please go to our Event Website for the full list and schedules of great sessions that we have lined up for the event.

    Upgrade to Oracle 12.2 and 18c

    February 26, 2018 08:30 AM - 04:00 PM

    Mike Dietrich, the guru of Oracle Database upgrades, will be back in Vancouver on February 26, 2018. The British Columbia Oracle User Group is proud to welcome him to our beautiful city, for yet another day of learning and hands-on exercises.

    Seats are limited! With the impending release of 18c this year, you won't want to miss this FREE one-day event!

     

    Agenda

    8:30am - Registration
    9:00am - The new Release and Patching Model for Oracle Databases
    9:45am - Upgrade to Oracle Database 12.2 and 18c
    10:30am - Break
    10:45am - Real World Customer Examples
    11:15am - Hands-On Lab Exercise 1 - Upgrade
    12:00pm - Lunch provided (sponsored by Oracle Vancouver)
    1:00pm - Oracle Multitenant - More than a bunch of New Features
    2:15pm - Hands-On Lab Exercise 2/3 - Multitenant
    2:45pm - Break
    3:00pm - Ensure Performance Stability with Oracle 12.2/18c
    3:45pm - Debrief and End

     

    To participate in the workshop:

    Please bring a laptop with preinstalled Oracle VirtualBox 5.x and - VERY IMPORTANT - the Oracle VirtualBox Extensions.

    Download and install Oracle VirtualBox and the Extension Pack from: https://www.virtualbox.org/wiki/Downloads

    Furthermore it's important that your laptop meets to following criteria:

    • At least 4GB RAM - 8GB or more highly recommended
    • At least 62GB of free disk space 
    • External disk drives with USB 3.0-SSDs or Thunderbolt may work but slow down the lab usually. The lab does not run on USB thumb drives

     

    About Mike

    Based in Bavaria, Germany. >25 years IT experience. Database Upgrade and Migration specialist, currently in the role of a Master Product Manager working for Oracle for over 20 years. Interlink between customers/partners and the Oracle Upgrade Development. Holding technical workshops between Arctic and Antarctica. Assisting customers in their reference projects onsite and remotely worldwide. Troubleshooting upgrade and migration issues. Eager to learn something new every day. Experienced conference speaker. Music lover. LP/vinyl enthusiast. Mountain hiker. Runner.

    You are cordially invited to join the BCOUG at our next Vancouver event on January 24, 2018.

     

    Session 1

    Topic: Securing Your DBA Monitoring & Backup Scripts (SEPS & The Oracle Wallet)

    Speaker: Simon Pane, Pythian

    Abstract

    All DBAs have OS and DB based scripts for performing tasks such as monitoring, backups, or application logic. However, are these scripts implemented as securely as possible without using some home-grown solution for DB credential management? Or are they a weak point or possible exposure in your organization's security implementation?

    This presentation discusses how to use Oracle's "Secure External Password Store" (SEPS) and Oracle Wallet files to maximize the security of DBA scripts. Both SQL and RMAN based scripts are reviewed including those scheduled via OS tools such as cron and those scheduled from within the database using the new Oracle Database 12c Scheduler job types.

    Issues and exposures with commonly used techniques and practices are identified. Then secure alternatives using SEPS and other security best practices are reviewed in detail with examples.

     

    Session 2

    Topic: Analyze Storage and Performance using Data Visualization Desktop 12c (DVD) - Like a BOSS !!

    Speaker: Fahd Saeed, Red Pill Analytics

    Abstract

    Database administrators and storage architects have a lot on their plate. With a bevy of SQL queries in their back pocket, being responsible for a multitude of databases, why wouldn’t they want to create custom data visuals that tie all this information together, to either report on issues, performances, or perhaps brag about the uptime, space and capabilities?

    Oracle’s newest data visualization tool, Data Visualization Desktop 12c (DVD), allows you to quickly connect to a number of datasets within minutes and produce sweet, succulent graphical charts (like a BOSS). In this presentation, we will take a look at quickly installing DVD, connecting DVD to SQL queries and CSV files to create visualization that you’ll be proud to show off within your organization.

     

    About the Speakers

    Simon Pane - Pythian

    Simon Pane is an Oracle Certified Professional, Oracle Certified Expert, and Oracle ACE. Working with the Oracle database since version 6, his focus has been on High Availability, Monitoring, Backup & Recovery, Migration & Consolidation, and Security, and he has experience with literally thousands of database environments at hundreds of client sites.

    Simon enjoys sharing technical knowledge and has presented at many user groups and at almost every major conference in Canada and the United States including Oracle OpenWorld and is a UKOUG speaker award winner.

     

    Fahd Saeed - Red Pill Analytics

    Fahd is a BI Consultant at Red Pill Analytics, based out of Salem Oregon. Plays with data integration tools and SQL for a living. Avoids getting seriously injured long boarding and skiing for fun. 

    Annual General Meeting 2017

    December 06, 2017 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Wednesday, December 06, 6:00 - 8:00pm
    BC Liquor Distribution Branch
    3200 East Broadway
    Vancouver, BC

    Dear Members,

    You are cordially invited to attend the society's Annual General Meeting (AGM) for 2017. Registration is required for security purposes.

    The Victoria Oracle Users Group Society is the IOUG sponsored incorporated entity that oversees the operation of the BC Oracle User Group. This is the required legal body that is able to accept donations, pay expenses, and conduct business. The AGM is a legal requirement, during which financial statements are presented and the board of directors are elected.

    Agenda

    • AGM call to order
    • Review and approval of last year's (2016) AGM minutes
    • Report of the activities in 2017
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2017
    • Nomination and election of the board of directors
    • Other matters:
      • Activities and events for 2018

    Please note that this is a business meeting only and there are no presentations.

    For members unable to attend the event in person, you may be able to join us via conference call. Please indicate in your registration that you wish to attend the meeting remotely and details will be provided to you.

    You are cordially invited to join the BCOUG at our next Vancouver event on October 25, 2017.

    Session 1

    Topic: Key Technical Features of Oracle RAC 12c & Beyond

    Speaker: Ian Cookson, Oracle

    Abstract

    Review the evolution of RAC 12c in terms of key technical and architectural features and functions.  Then consider where this will be leading us, to the Cloud and to on premise deployments.

     

    Session 2

    Topic: Data Storage Optimization

    Speaker: Chas. Dye, Pure Storage

    Abstract

    The topic of the presentation will be focused on data storage optimization in database / multiple database environments along with disaster-recovery strategies in those environments.

     

    About the Speakers

    Ian Cookson, Oracle

    Based now at Oracle HQ in California, Ian is the Product Manager for Oracle Clusterware, and the Oracle Liaison to the RAC SIG.  His background is varied, after spending over 20 years in Consulting, plus many years with the RAC Pack.

     

    Chas. Dye, Pure Storage

    Chas. Dye has been an Oracle DBA and Database Architect for over 20 years.

    He authored "Oracle Distributed Systems" and co-authored "Oracle Built-in Packages", both published by O'Reilly and Associates. He was personally responsible for the databases serving content to for web sites like eXcite.com and nike.com. In addition he served as a database architect at Yahoo! where he helped to design, test, and oversee the database disaster recovery infrastructure for Yahoo! properties around the globe.

    Chas. is the Database Architect who is responsible for ensuring the success of customer database deployments including Oracle, Microsoft SQL Server, PostgresSQL, or any other database environments.

     

    Registration

    Registration is free and required for security access. Registration and refreshments will begin at 5.30 pm and the first session at 6.30 pm. Please note that the building's elevators will be locked in the evening. You are advised to come before the first presentation begins, so that an Oracle staff or BCOUG volunteer can escort you up to the meeting venue.

     

    Acknowledgements

    We would like to thank Oracle Vancouver and Open Storage Solutions for generously providing us the venue and light dinner for the evening. 

    You are cordially invited to join the BCOUG at our next Vancouver event on May 25, 2017.

    Session 1

    Topic: Advanced Database Diagnostics with the Trace File Analyzer (TFA) Suite

    Speaker: Sean Scott, Bodybuilding.com

    Abstract

    Most database administrators know that Trace File Analyzer (TFA) is the preferred tool for collecting and preparing files for troubleshooting an issue with Oracle Support, but remain unaware that it is actually a robust suite of tools capable of capturing OS metrics, system changes, insights into alert and log files and automatically collecting diagnostic information to expedite troubleshooting of performance events and deadlocks. It's lightweight, cluster aware and suitable for standalone and RAC databases as well as engineered systems.

    This session will go beyond the basic diagcollect command to cover more advanced capabilities of TFA, including system and database log analysis, user management, redaction and repository maintenance. The use of Automatic Diagnostic Repository (ADR) and the SQL Test Case Builder for investigating database and performance issues will also be demonstrated.

     

    Session 2

    Topic: ADOP Patching gotchas!

    Speaker: Oti Ometie, Independant Consultant

    Abstract

    AD Online Patching(ADOP) as a utility eases the burden of constantly taking an outage to apply an E-Business Suite patch, however with that ease comes a complexity that can only be overcome with experience, creativity and an understanding of the documentation. This session aims to get you across pitfalls you may experience while using the utility. Walk you through scenarios you are likely to face when applying patches to multiple nodes and explain concepts like fs_clone and cleanup_mode = full. The session will be interspersed with interesting anecdotes and challenges I have encountered and resolved.

     

    About the Speakers

    Sean Scott - Bodybuilding.com

    Sean is a database administrator with over 20 years experience managing Oracle. For 15 years he managed a database consultancy specializing in RDBMS management, backup and recovery, disaster recovery, performance tuning and database design. He's developed high performance solutions to meet the extreme demands of online gaming and e-commerce and designed and implemented high availability solutions for clients including Intuit, the University of Phoenix and the military. He has presented at IOUG/Collaborate, Oracle Open World, OAUG and regional user groups across the US and his work featured in magazines. He currently works for Bodybuilding.com, the world's largest online sports nutrition retailer, overseeing the company's e-commerce database environment.

     

    Oti Ometie - Independent Consultant

    Oti is an Oracle Certified Expert (OCE) currently working as an Oracle E-Business Applications DBA. He has worked on 3 continents and has over 14 years’ experience in database design, administration and performance tuning. He has a M.Sc. in Information Systems, and an MBA.

     

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.

    From Database Recovery to Complete Data Protection

    February 09, 2017 06:00 PM - 09:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event on February 9, 2017.

    Session 1

    Topic: From Database Recovery to Complete Data Protection

    Speaker: Chris Veenstra, Oracle

    Abstract

    • Oracle’s Database Protection Strategy: From Database to Engineered Systems to Cloud 
    • Engineered Data Protection: Introducing Oracle’s Zero Data Loss Recovery Appliance 
    • Data Protection Advantages First Hand 
    • Real-World Customer Experience
    • General Discussion / Q&A

     

    Session 2

    Title: The Optimizer complexity is great, but...

    Speaker: Liron Amitzi, DBAces

    Abstract

    The Optimizer is one of the most complex components in Oracle. In this session we will talk about the optimizer from a slightly different perspective, its deterministic (and non-deterministic) behavior. We will explore the stability of plans and examine new features that ruin your system performance, just when we get it tuned just right.

     

    About the Speakers

    Chris Veenstra - Oracle

    Chris is a Sales Engineer with the Oracle North America Cloud and Infrastructure Solutions (NACIS) Sales Engineering Organization. With a strong end user background as an Oracle DBA he brings a wealth of knowledge and expertise to DB Protection initiatives including Oracle DB Backup, Recovery as well as Archive.

    He often speaks on matters involving Oracle DB, DB Protection and architecting Oracle Solutions for a wide array of customers both in the Public Sector as well as in the Private Sector and help them to achieve faster, more efficient mission success with Oracle's technologies, solutions and capabilities.

    While he works with customers all across Canada and the US, Chris calls the New England area home.

     

    Liron Amitzi - DBAces

    Liron is an Oracle ACE and a senior Oracle DBA, with over 18 years of experience. During these years Liron worked as a senior consultant with a large number of companies in various fields and managed an Oracle Professional Services Team. He is currently in Vancouver, BC, founding the Canadian branch of his Israeli Company, DBAces. Liron is also the president of BCOUG (British Columbia Oracle User Group) and US Events Chair and IOUG Liaison of Oracle RAC SIG.

    He mainly specializes in high availability solutions, performance, backup and recovery, and other infrastructure and application database areas. He is also a well-known senior instructor and lectures in Oracle courses, events and forums

     

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.

    Annual General Meeting 2016

    December 15, 2016 06:00 PM - 08:00 PM

    Victoria Oracle Users Group Society
    NOTICE OF ANNUAL GENERAL MEETING

    Wednesday, December 15, 6:00 - 8:00pm
    BC Liquor Distribution Branch
    3200 East Broadway
    Vancouver, BC

    Dear Members,

    You are cordially invited to attend the society's Annual General Meeting (AGM) for 2016. Registration is required for security purposes.

    The Victoria Oracle Users Group Society is the IOUG sponsored incorporated entity that oversees the operation of the BC Oracle User Group. This is the required legal body that is able to accept donations, pay expenses, and conduct business. The AGM is a legal requirement, during which financial statements are presented and the board of directors are elected.

    Agenda

    • AGM call to order
    • Review and approval of last year's (2015) AGM minutes
    • Report of the activities in 2015
    • Review and approval of the society's financial report for the current year, as of Oct 31st, 2016
    • Nomination and election of the board of directors
    • Other matters:
      • BCOUG website, maintenance and community space on https://community.oracle.com/community/usergroups
      • Change of payment provider
      • Reorganization of email groups/aliases
      • Activities and events for 2017
      • Registration with TechSoup Canada as a non-profit organization

    Please note that this is a business meeting only and there are no presentations.

    For members unable to attend the event in person, you may be able to join us via conference call. Please indicate in your registration that you wish to attend the meeting remotely and details will be provided to you.

    EBS co-existence with Oracle SaaS and other systems

    November 08, 2016 06:00 PM - 08:00 PM

    You are cordially invited to join the BCOUG at our next Vancouver event.

    It is our pleasure to have Stewart St. Dennis, Consulting Director at Sierra Systems, present on the following topic:

    EBS co-existence with Oracle SaaS and other systems

    EBS Systems need to INTEGRATE! Traditionally, EBS systems use tightly coupled, point-to-point integrations. As a result, many organizations experience issues when related systems are shut down for maintenance or system upgrades. Also, upgrades and enhancements in one system can cause problems with other systems they are connected with.

    How can organizations unravel their integration spaghetti plate? How do they isolate the operations of one system from their network of systems? How can an organization prepare for hybrid, on premise/cloud solutions? Let me show you how to solve the interoperability issues for your organization in a better way.

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.

    You are cordially invited to join the BCOUG at our next Vancouver event, presented and sponsored by NetApp™!

     

    Session 1

    Speaker: Steve Schuettinger, Oracle Solution Architect, NetApp
    Topic: Oracle Application Integration

    Abstract: Please join Steve Schuettinger, Oracle Solution Architect, in a discussion that focuses on what’s important to you when deploying Oracle databases. Suggested topics include performance, scalability, availability, manageability, root cause analysis and backup/recovery. These are suggested because we’d like to encourage you to bring your top-of-mind questions to the session. Nothing is off limits. The objective is to help you understand how NetApp solutions can help you meet your service level objectives without increasing risk.

    NetApp has thousands of customers who have chosen to deploy their Oracle databases on NetApp. The value discussion points will be underscored with real world examples. You’ll also learn what NetApp and Oracle are engineering together with focus on you, the Oracle DBA.

    Session 2

    Speaker: Tony Lee, System Engineer Manager, NetApp
    Topic: Technical Demonstration – Oracle on AFF

    90% of all database performance issues can be traced to the storage tier. Reduce latency during peak loads, and boost Oracle Database performance where you need it most, by using NetApp All Flash FAS or EF-Series all-flash storage systems.

    • Decrease latency by up to 20x
    • Increase throughput by up to 4x
    • Increase your ROI and time to value by up to 50%

    Watch a technical demonstration of Oracle running on NetApp All Flash FAS storage arrays.
     

    About the Speakers

    Steven Schuettinger – Oracle Solution Architect, NetApp

    Steven began his career working as an application developer for a US defense contractor using Oracle version 5. He soon became a DBA where he focused on performance and manageability. Steve was the first Oracle DBA at Sun Microsystems, in Silicon Valley, in 1992 and worked as their technical alliance manager with Oracle. He has been consulting with customers for many years while managing the technical aspects of the relationship between NetApp, where he has worked since 2005, and Oracle. During his career he has developed an interactive style of working with DBAs where he talks about the challenges they face and the unique solutions NetApp provides. All of these discussions are delivered in the language of the DBA, rather than the storage administrator.

    Tony Lee, System Engineer Manager Canada West, NetApp

    Tony is a creative problem solver; and with 25 years of experience in the IT industry, he’s had ample opportunity to hone his skill. Tony started his career in the early days of the Internet and worked for several large outsourcers, including EDS and IBM Global Services, building and operating their network services (DNS, Email, Web, Firewall, etc.). In 2001, he joined Sun Microsystems and moved from an operational role to an architectural one. As a Sun Systems Engineer, Tony architected solutions to address some of Sun’s most challenging customer environments. For the last 8 years, Tony has been a Senior Storage Architect at NetApp where he’s continues to leverage his problem solving skills focusing on the ever-increasing challenges associated with data management.

    Tony has a BSc in Computer Science from Simon Fraser University.

    Registration

    Registration is free and required for security access. Please also note that light refreshments will be provided at the event.

    ORCLAPEX-YVR Meetup #3

    February 04, 2016 05:30 PM - 08:30 PM

    Abstracts

    SQL Developer Integration with APEX

    Those of you already familiar with Oracle SQL Developer, the free graphical IDE for the Oracle Database, have experienced first hand how this feature rich tool can boost productivity. Many DBAs, developers, data modelers, and application architects alike have discovered how SQL Developer can help them do their jobs in less time with fewer clicks. However, did you know that SQL Developer is also a indispensable tool for working with APEX?

    Join us as former ODTUG President, Monty Latiolais, gives us an overview of SQL Developer, and then shows how SQL Developer can be used to administer, maintain and debug APEX applications. You are guaranteed to pick up a few SQL Developer tips and tricks that will help you go faster.

    APEX and the Future of Enterprise Development

    Development teams can easily get tied down with slow moving development cycles. Slow processes make it very difficult to keep up to date with rapidly evolving technology which can significantly affect a business’ ability to grow. Thankfully for organizations that use Oracle, they can leverage APEX: a web based rapid application development (RAD) tool. By using APEX, organizations can move into the the “IT fast lane” and quickly develop applications for their business needs.

    This presentation will highlight how APEX can be used to rapidly develop enterprise applications and leverage different web based technologies to help reduce development time and improve user experience.

    Agenda

    5.30 - 6.00 pm - Registration and light meal
    6.00 - 6.45 pm - SQL Developer Integration with APEX
    6.45 - 7.00 pm - Break
    7.00 - 7.45 pm - APEX and the Future of Enterprise Development
    7.45 - 8.30 pm - Q&A followed by networking

    About the Speakers

    Monty Latiolais

    Monty is a Senior Consultant with Insum Solutions - the largest APEX consultancy in North America. He has 30 years experience working in IT with more than 15 with Oracle technology. In 2014 he was designated as an Oracle ACE and served as President of ODTUG from 2012-2015.

    Prior to joining Insum Solutions, Monty spent time solving problems in the Oil and Gas, Legal and Healthcare industries. He spends his days working with Application Express, Oracle Forms, and Oracle Reports; writing complex analytics; and counting the days until the next KScope conference.

    He blogs regularly at montylatiolais.blogspot.com. Follow him on Twitter at: monty_latiolais

    Martin D'Souza

    Martin D'Souza is a senior consultant at Insum Solutions. He is also the vice president for ODTUG and founder of OraOpenSource. Martin’s career has spanned a range of positions within award-winning companies. His experience in the technology industry has been focused on developing database-centric web applications using the Oracle technology stack. Martin is the author of the popular blog www.talkapex.com and a designated Oracle ACE Director. He has co-authored and authored various APEX books and is an active participant in various open-source projects, such as Logger. Martin has presented at numerous international conferences, such as APEXposed, APEX World, Oracle OpenWorld, and ODTUG Kscope.

    Introduction to Kafka for Oracle DBAs and Business Analysts

    November 04, 2015 05:30 PM - 07:30 PM

    Abstract

    As DBAs and data architects there are some things we care a lot about: e.g. providing consistent performance on our OLTP databases, and making sure the ETL processes will land data correctlyand on-time into the data warehouse.

    Business analysts care a lot about other things -- like gettingthe newest data to their dashboards and being able to run crazy queries quickly without anyone killing the queries for silly reasons like "performance". They also want to get all the data they require without having to integrate with a gazillion data stores.

    Apache Kafka, a distributed queue developed at LinkedIn to solve the problem of integrating databases at large scale, offers a surprising solution to all these problems. Which probably explains why it is gaining popularity at an explosive rate.

    In this session we will explain what Apache Kafka is and why it is rapidly becoming the secret weapon in the fight to keep databases (and DBAs?) sane.

    About the Speaker

    Gwen is a system architect at Confluent helping customers achieve success with their Apache Kafka implementation. She has 15 years of experience working with code and customers to build scalable data architectures, integrating relational and big data technologies. She currently specializes in building real-time reliable data processing pipelines using Apache Kafka. Gwen is an Oracle Ace Director, an author of “Hadoop Application Architectures”, and a frequent presenter at industry conferences. Gwen is also a committer on the Apache Kafka and Apache Sqoop projects. When Gwen isn’t coding or building data pipelines, you can find her pedaling* on her bike exploring the roads and trails of California, and beyond.