Viscosity Upcoming Events

View Past Events

July 14, 2020

 

Steven Feuerstein at NYOUG : Virtual Session

Steven Feuerstein

Steven Feuerstein

Oracle Corporation, PL/SQL

New(er) Features of Oracle PL/SQL

12:00 PM – 1:00 PM EDT / 11:00 AM – 12:00 PM CT

Since Oracle Database 12c, a very nice and highly varied set of features have been added to the PL/SQL language. Given the pressure on developers’ time and attention, it can be hard to keep with these new features, especially given how robust PL/SQL has been for years, and how stable are the applications built with it. This presentation makes attendees aware of new possibilities for PL/SQL development, with benefits ranging from runtime performance improvements to improved coding productivity. Steven will cover the following: 18c Qualified expressions for collections and records; PL/Scope now includes SQL statements in its analysis; Whitelisting with the ACCESSIBLE_BY Clause; More PL/SQL-Only Data Types Cross PL/SQL-to-SQL Interface; Optimizing Function Execution in SQL; The UTL_CALL_STACK Package; Privileges/Access Management for Program Units; Static Expressions In Place of Literals; Marking elements for deprecation.

    July 21, 2020

    ODTUG Database Community Beach Party, 12:00 – 4:30 PM EDT

    Join ODTUG’s Database Community for a list of great sessions and speakers!  Viscosity’s CIO will take the stage at 2 PM EDT:

    2:00 – 2:50 PM EDT: Converged Database: The Path to a Long and Healthy Oracle DBA Career (and Eventual Retirement), Co-Presented by Rich Niemiec, Viscosity Chief Innovation Officer and Oracle ACE Director

    July 22, 2020

     

    Modernize Your Database to Oracle Database 19c

    Wednesday July 22, 11:00 AM – 1:00 PM CT

    Oracle 19c Hands-On Experience: Upgrading

    Viscosity Online Training

    Companies can recognize immediate ROI by upgrading to Oracle Database 19c, especially those who are still running on legacy databases that will go out of premier support this year (11.2) or next year (12.1).

    Come learn what it takes to upgrade to Oracle Database 19c from Oracle database versions 11.2.0.x/12.1.0.x.

    July 23, 2020

    Rodolfo Rodriguez

    Rodolfo Rodriguez

    Software Developer

    Viscosity North America

    Uploading Data with APEX

    11:00 AM CT – 12:00 PM CT

    Technologies come and go, and while everything has been moving really fast, no matter when you read this: YOU WILL NEED TO UPLOAD data to your databases.

    We have a lot of tools, features, APIs and even our own good old scripts for data imports in all the flavors and colors, however, how could APEX help us?

    The APEX team, once again, has added a great feature for us. The APEX_DATA_PARSER API.  With it we have limitless possibilities.

    I’d like to show you how we could upload data from almost anywhere (web services include) using the new APEX_DATA_PARSER. 

    We’ll be exploring some real use cases for the API and how we could reduce (at least in a half) the development time for our requirements.

    Finally, I’ll be sharing my demo APEX application with some useful samples.

    July 23, 2020 – Arizona Oracle Users Group (AZORA)

    Charles Kim

    Charles Kim

    CEO and Co-Founder

    Oracle ACE Director

    Get Ready for Brain Overload with Oracle Database 18c/19c/20c Features

    1:00 PM – 2:00 PM CST

    Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas:
    1. Oracle 20c New Features
    2. Oracle 19c New Features

    Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c
    3. Oracle 18c New Features
    4. Upgrade to Oracle 12.2/18c/19c/20c
    a. Upgrade considerations
    b. Zero downtime upgrade options
    5. Multi-Tenancy (PDB) Option
    1. Elimination of support for non-container databases in Oracle 20c
    2. Changes in Oracle licensing policy with Oracle19c
    6. Online Improvements
    7. Partitioning Option
    8. Data Guard
    9. RMAN
    10. General Database
    11. RAC
    12. ASM/ACFS
    13. In-Memory

    Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience. We will share all of the code from our presentation so that you can add them to your arsenal.

     

    July 28, 2020

     

    Rich Niemiec at NYOUG : Virtual Session

    Rich Niemiec

    Rich Niemiec

    Chief Innovation Officer & Oracle ACE Director

    The future of AI & Machine Learning (ML) in Oracle Products

    12:00 PM – 1:00 PM EDT / 11:00 AM – 12:00 PM CT

    This presentation will cover Oracle’s ability to leverage AI and Machine Learning (ML) from within Oracle Advanced Analytics or using their recent acquisition GUI. Every Oracle product will start to leverage AI/ML! Knowing when/where to leverage these advancements may be the difference between success & failure in the future. We’ll look at the latest technology and algorithms that Oracle provides as part of the product, but also the Cx products that are used to leverage AI/ML & Chatbots. We will explore how to leverage and integrate AI into your companies tech plan. We’ll see the state of AI & ML and how you can test and use this technology to create the future. We’ll also look at the current Acceleration of the Cloud with the Big Data Revolution & Internet of Things (IOT) which will drive the Cloud even Faster. You’ll see how to innovate better using leading edge Oracle products.

    Co-Hosted by the New York Oracle Users group (http://nyoug.org/) and Viscosity North America.

      July 29, 2020 – Chicago Oracle Users Group (COUG)

      Sean Scott

      Sean Scott

      Principal Consultant

      Oracle ACE Associate

      Hosted by:

      Getting Started with Oracle and Docker

      12:00 PM CT – 1:00 PM CT

      Docker is widely embraced in the developer community but isn’t as well known or understood in the database world. Database administrators and developers are beginning to realize how powerful containers are and the speed, flexibility, and portability advantages they offer over virtual guests.

      What can be done with Oracle on Docker? Plenty! Create environments for specialized performance testing, confirming and isolating bugs, evaluating environment changes, exploring new features, practicing and perfecting disaster recovery and upgrade procedures, and preparing for certifications. Provision portable test and lab environments, manage software and data separately, and rapidly deploy reference data end users can apply locally with drag-and-drop ease, independent of operating system concerns. Run multiple versions and editions of Oracle on a single system without conflict. Run several databases on an ordinary laptop with resources to spare.

      This session is a practical course for those curious about or just starting out with Oracle on Docker. Attendees will learn terminology and understand how containers differ from virtual machines, followed by demonstrations of Docker’s speed and versatility. Explore basic commands and examples for building Oracle on Docker and making container databases visible on a network. Discover how to separate and preserve data, share and distribute database images and data, then how to create new databases in seconds (not an exaggeration). The session closes with advice on customizing container environments and a peek into orchestrated builds for multi-database needs posed by Data Guard and Sharding.

      July 29, 2020 – Viscosity WFH Series

      Kelsie Brunson

      Kelsie Brunson

      Director of Business Operations

      Viscosity North America

      Conflict, how do we Manage Difficult Situations and People?

      2:00 PM CT – 2:30 PM CT

      One fact of life we cannot change is that we will always have difficult people and situations in our work environment; but working from home adds another layer to workplace conflict. How do we manage these situations, and are there ways to help alleviate conflict from occurring?

      Real life examples could include getting off on the wrong foot with a new coworker – especially during new WFH protocols, unhealthy competition with coworkers, applying for the same in-org-position as a colleague, difficulties managing a new employee without the convenience of in-office culture to help guide expectations, and any other situation that needs healthy confrontation.

      In this session we will discuss the Thomas-Kilman Conflict styles, as well as what your response should be in a conflict situation at work, whether with your management or colleagues. After this session, you’ll have several examples to keep in your pocket of what to say in difficult situations, and take control of the way people treat you, your thoughts, and your goals for growth in your work environment.

      Join us for this 30 minute session that is part of an entire series meant to help you become a more effective communicator as you work from home!

      July 30, 2020 – Rocky Mountain Oracle Users Group (RMOUG)

      Gary Gordhamer

      Gary Gordhamer

      Managing Principal Consultant & Oracle ACE Associate

      DBA 201: Testing your DB upgrades or Balancing Risk

      11:00 AM – 12:00 PM CT

      Database upgrades are often a pain. They are impactful, scary, hard to discuss, and inevitable.

      Just as you finish one upgrade, patch, or application change you will begin discussing the next one. This article will not be a definitive plan for how to test, or exact guidance on what you need to test. Instead we will be having a conversation around some ideas and guidance on how to think about database testing with respect to DB upgrades.

        August 5, 2020

        Rich Niemiec

        Rich Niemiec

        Chief Innovation Officer & Oracle ACE Director

        Converged Database: The Path to a Long and Healthy Oracle DBA Career (and Eventual Retirement)

        12:00 – 1:00 PM CT

         

        Join Rich Niemiec, co-presenting along side Viscosity friends, Jim Czuprynski and Nitin Vengurlekar, for the Chicago Oracle Uesrs Group.  More info coming soon.

          August 7, 2020

           

          Modernize Your Database to Oracle Database 19c

          Friday August 7, 11:00 AM – 1:00 PM CT

          Oracle 19c Hands-On Experience: Upgrading

          Viscosity Online Training

          Companies can recognize immediate ROI by upgrading to Oracle Database 19c, especially those who are still running on legacy databases that will go out of premier support this year (11.2) or next year (12.1).

          Come learn what it takes to upgrade to Oracle Database 19c from Oracle database versions 11.2.0.x/12.1.0.x.

          Two User Groups. One Unforgettable Conference.

          Midwest Oracle Users Group Logo 

          COUG and MOUG invite you to spend your lunch break with them!

          Register for each session you’d like to attend.

          Online – Free Registration   |  Aug 10-14, 2020   |   12:00 PM CST Daily

          Sponsored by:

          Monday August 10: 

          Preparing for Oracle 20c

          Rich Niemiec, Viscosity North America CIO & Oracle Ace Director

            

          Tuesday August 11:

          What’s Your Super-Power? Mine is Machine Learning with Oracle AutonomousDB

          Jim Czuprynski, Zero Defect Computing & Oracle Ace Director
          Read more or Register here

          Wednesday August 12: 

          Oracle APEX New Features and Roadmap

          Joel R. Kallman, Oracle Senior Director, Software Development
          Read more or Register here

          Thursday August 13: 

          The Future is Data Driven

          Maria Colgan, Oracle Master Product Manager
          Read more or Register here

          Friday August 14: 

          Autonomous to Data Safe – From Design to Deployment a Real-World Use Case

          Nitin Vengurlekar, Oracle Chief Technology Strategist, Public Sector
          Read more or Register here

          Aug 11, 2020

           

          Maria Colgan at NYOUG : Virtual Session

          Maria Colgan

          Maria Colgan

          Master Product Manager Oracle Corporation

          Explain the Explain Plan- Interpreting Execution Plans for SQL Statements – Part 1

          12:00 PM – 1:00 PM EDT / 11:00 AM – 12:00 PM CT

          The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This two-part webcast series examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan. Part 1 covers the best techniques for generating an execution plan, understanding cardinality estimates and the different access and join methods. While part 2 covers join orders, partitioning and parallel execution.

          Meet the Speaker:
          Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria’s core responsibility is to advocate for the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product.

          Prior to this role; she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer.

          —-
          Co-Hosted by the New York Oracle Users group (http://nyoug.org/) and Viscosity North America.

            Aug 18, 2020

             

            Maria Colgan at NYOUG : Virtual Session

            Maria Colgan

            Maria Colgan

            Master Product Manager Oracle Corporation

            Explain the Explain Plan- Interpreting Execution Plans for SQL Statements – Part 2

            12:00 PM – 1:00 PM EDT / 11:00 AM – 12:00 PM CT

            The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This two-part webcast series examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan. Part 1 covers the best techniques for generating an execution plan, understanding cardinality estimates and the different access and join methods. While part 2 covers join orders, partitioning and parallel execution.

            Meet the Speaker:
            Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria’s core responsibility is to advocate for the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product.

            Prior to this role; she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer.

            —-
            Co-Hosted by the New York Oracle Users group (http://nyoug.org/) and Viscosity North America.

              August 19, 2020 – Viscosity WFH Series

              Kelsie Brunson

              Kelsie Brunson

              Director of Business Operations

              Viscosity North America

              How to Present our Thoughts and Ideas in a Remote Workspace

              12:00 PM CT – 12:30 PM CT

              As most of us are spread out in a work from home initiative, communicating with our colleagues, customers, and management has become more difficult than a face to face conversation previously was. How do we ensure we can effectively present our message? What strategies should we use for a presentation, regardless of the audience size? In this session, we discuss proven presentation strategies to help bridge the gap while we all work from home. 

              Join us for this 30 minute session that is part of an entire series meant to help you become a more effective communicator as you work from home!

              Don't see your city?

              Let us know if you want to see events like this in your city!  Email us your name, location, organization or interests, and what type of event you’d like to see.

              We’ll track what cities have the most demand and do what we can to make it out towards you!  Till then, keep checking back for online events!