Viscosity Upcoming Events

View Past Events

November 30, 2021 – Webinar


Building Generic Search Screens Using Dynamic SQL

11:00 AM – 12:00 PM Central

Michael Rosenblum

Michael Rosenblum

Software Architect/Development DBA, Dulcian Inc.

Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major implementation headaches on the back end because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of creativity.

Presented by Michael Rosenblum, Software Architect/Development DBA, Dulcian, Inc.

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), PL/SQL Performance Tuning Tips & Techniques (Oracle Press, 2014), contributing author of Expert PL/SQL Practices (APress, 2011), and author of multiple database related articles and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc.)

This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)

Oracle Exadata and Exadata Cloud Expert Panel

Thursday December 9, 2021   |   12:00 PM CT – 1:00 PM CT 

Charles Kim

Charles Kim

Founder and CEO, Viscosity North America

Oracle ACE Director

Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Viscosity North America

Oracle ACE

Ashish Ray

Ashish Ray

VP Product Management, Oracle Corporation

Troy Ligon

Troy Ligon

Oracle ACE & Enterprise Architect, President of SOUG

Hear what this rare combination of industry experts have to say about the Fastest Oracle Database and how it effects you.
Submit your own questions at registration!

Countdown to Master Class Expert Panel

Day(s)

:

Hour(s)

:

Minute(s)

:

Second(s)

December 9, 2021

Catch Viscosity Consultant and Oracle ACE, Sean Scott at the Docker Community All-Hands

Thursday, December 9, 2021 | 8 – 11am PT

 

Sean Scott

Sean Scott

Principal Consultant, Viscosity North America

Oracle ACE Director

10:10 AM PT: How to talk about Docker with your database administrator

My first experience with Docker came in 2014 when my employer announced we were going fully cloud-native. I knew nothing about Docker so I reached out to peers in the database world for advice. Their unanimous opinion: Docker was an inappropriate platform for databases and I would do well to educate my executive team that trusting anything as important as a database to “fad” tech was irresponsible folly. I made passionate appeals—even threatened to resign—but the decision was made. Everything goes in Docker. No exceptions. Not even the database.

You might say I was resistant at first. Defiant, even. (I prepared an “I told you so” speech for the inevitable disaster only ‘database people’ could see coming.) A few months later I was blogging and presenting on the advantages of running databases on Docker.

Sean Scott is an Oracle ACE and Oracle Cloud Infrastructure Certified Architect Professional with over 25 years of experience as a database architect, engineer, administrator, and developer.

As a Managing Principal Consultant with Viscosity North America, an Oracle Platinum Partner, he focuses on migrations, upgrades, database automation, and designing and optimizing highly available and resilient databases. His expertise includes Exadata, Oracle Database Appliance, RAC, Data Guard, Sharding, and Recovery Manager.

Sean is a globally recognized authority on Oracle and Docker and he’s delivered over 100 presentations and workshops to user group audiences around the world.

December 14, 2021 – Webinar


Under the Hood of Oracle Autonomous Database

11:00 AM – 12:00 PM Central

Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation

What does “autonomous” really mean, and what makes a database autonomous? How do I simplify ongoing database management, patching and upgrades? If you’re looking for the answers to these questions, this is the session for you! During this presentation, we will explain in-depth how an Autonomous Database works. We will provide details on the combination of database features, best practices and machine learning algorithms used to deliver this family of cloud services. Including Automatic Indexing, Automatic SQL Plan Management, Autonomous and Real-Time Statistics Gathering, OCPU Auto-Scaling, SQL Quarantine, High Availability, Patching, AI-Ops and more! With the use of demos, we’ll illustrate how Oracle Autonomous Database can simplify your approach to data management and accelerate your transition to the cloud.



Presented by Maria Colgan

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.

This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)

January 25, 2022 – Webinar


How Oracle’s converged database helps Oracle MovieStream generate more value from data

11:00 AM – 12:00 PM Central

Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation

Oracle MovieStream is a fictitious movie stream platform – like Netflix, Amazon, Hulu, etc., which have seen massive growth in the last 18-months. As a result, they face challenges typical to many organizations across industries, including understanding their customers better and anticipating their needs to ensure they love their service. This session will show how MovieStream designed its data platform using Oracle’s converged database to generate value from the massive amount of structured, semi-structured, and unstructured data, retain their customers and ultimately improve profitability. In addition, this session includes demos of Oracle new AutoML, Spatial and Graphic analytics.



Presented by Maria Colgan

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.

This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)

February 7-10, 2022

RMOUG Training Days  |  February 7-10, 2022

Charles Kim

Charles Kim

President, Viscosity North America

Oracle ACE Director

Automate and Bulletproof Your Data Guard

Mon Feb 07, 12:35 PM – 1:35 PM MST / 1:35 PM – 2:35 PM CST

Learn how you can setup Data Guard with all the best practices. Attendees will get a brief history of Data Guard and how it became Data Guard. Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c. In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Viscosity North America

Oracle ACE Director

Machine Learning 101 Deep Dive (Part 1)

Mon Feb 07, 2:20 PM – 3:20 PM MST / 3:20 PM – 4:20 PM CST

This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man’s Mind to further replace man’s most basic tasks.

This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don’t know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future. We will also dive into where AutoML fits in the process with many examples of Machine Learning.

Craig Shallahamer

Craig Shallahamer

Technologist, Viscosity North America

Oracle ACE Director and Founder of OraPub

Top 10 Ways to Totally Mess-Up an AWR Analysis

Mon Feb 07, 3:35 PM – 4:35 PM MST / 4:35 PM – 5:35 PM CST

You think you have seen it all… and then you see something new. I have studied literally hundreds of AWR reports and thought through thousands of performance scenarios.

While I know how to use an AWR or Statspack report to analyze Oracle performance, I have also learned how to totally mess-up the analysis.

There are some obvious ways to totally invalidate your analysis. But there are also some subtle mess-ups that fool you into thinking your time-based analysis is rock solid…yet it’s worthless and probably misleading.

Join me for a light-hearted session as we explore what NOT to do.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Viscosity North America

Oracle ACE Director

Machine Learning 101 Deep Dive (Part 2)

Mon Feb 07, 3:35 PM – 4:35 PM MST / 4:35 PM – 5:35 PM CST

This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man’s Mind to further replace man’s most basic tasks.

This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don’t know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future. We will also dive into where AutoML fits in the process with many examples of Machine Learning.

Craig Shallahamer

Craig Shallahamer

Technologist, Viscosity North America

Oracle ACE Director and Founder of OraPub

AAS Predictions Using Deep Learning Neural Networks With Sysmetric Data

Tue Feb 08, 9:00 AM – 10:00 AM MST / 10:00 AM – 11:00 AM CST

Smooth database operations are hindered when unexpected performance incidents occur. What if we could predict an incident was likely to occur within the next 60 seconds? Using Oracle Sysmetric data with Deep Learning neural networks, this can be a reality. This presentation will begin with recognizing patterns and how neural networks try to do the same. Then we’ll look at Sysmetric data, understanding and leveraging its time-series nature.

Now we’re ready to understand why neural networks and deep learning are sought after in performance prediction. An Oracle Cloud-Free Tier account is enough for a mind-blowing graphical demonstration of making real-time performance predictions. You can download everything necessary to replicate my demonstration and enabling you to tinker and explore! Once you get a glimpse of what is possible, a whole new world of performance monitoring and alerting will appear before you. Join me for a fascinating applied Machine Learning presentation for the Oracle DBA of the future.

Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Viscosity North America

Oracle ACE

Tune that SQL: Now What Do I Do?

Tue Feb 08, 11:25 AM – 12:25 PM MST / 12:25 PM – 1:25 PM CST

Tuning SQL statements in Oracle is more of an art than a science. In this session we will cover the basic tools and steps to tuning a SQL statement starting with finding the SQL statement and collecting the right information. How does the Optimizer work to transform SQL into an execution plan? What information is an execution plan is trying to show? Finally, what are some of the things that can be tuned as well as tools Oracle has provided to make things easier. If you are new to tuning SQL in Oracle or trying to freshen up your skills, this session should have enough information for everyone.

Sean Scott

Sean Scott

Principal Consultant, Viscosity North America

Oracle ACE

Building Technology Labs on Oracle Cloud

Tue Feb 08, 1:10 PM – 2:10 PM MST / 2:10 PM – 3:10 PM

Among the challenges faced by instructors is how to provide environments for students. It often comes down to sharing instructions for installing and setting up software and … hoping for the best! Testing procedures against various operating systems and dependencies is time-consuming for the presenter and burdens students. Does their system have adequate resources? Will they understand the instructions, particularly if they call for knowledge to be gained in the class itself? What’s the benefit if they can’t get it running or give up in frustration?

Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Viscosity North America

Oracle ACE Director

Converged Database is Oracle’s Best Kept Secret

Tue Feb 08, 1:10 PM – 2:10 PM MST / 2:10 PM – 3:10 PM CST

In the brave new digitally-driven world, IT organizations can no longer focus on internal-only RDBMS databases as the central pillar of their infrastructure; data must be accessed externally as well, regardless of format or location, with utmost security. As we move into the future, the efficiency of Oracle in using InMemory, Machine Learning, Exadata, Documents, JSON, XML…etc. will be their main strength. Fortunately, Oracle’s Converged Database strategy makes it simple to satisfy these demands.

Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career’s future path.

Charles Kim

Charles Kim

President, Viscosity North America

Oracle ACE Director

The Rise of the PDBs

Tue Feb 08, 2:20 PM – 3:20 PM MST / 3:20 PM – 4:20 PM CST

By now, everyone is aware that starting with Oracle Database 21c, non-containerized databases will no longer be supported. As customers upgrade to Oracle Database 19c, customers are adopting and embracing PDBs and learning to adapt to the new paradigm shift.

Come learn what it takes to effectively create, configure, manage, and monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

Sean Scott

Sean Scott

Principal Consultant, Viscosity North America

Oracle ACE

Oracle 21c Upgrade Workshop (Part 1)

Wed Feb 09, 1:10 PM – 2:10 PM MST / 2:10 PM – 3:10 PM

Oracle Database 21c brings significant changes and considerations for database administrators. With Oracle 21c, multi-tenant architecture is required, and the familiar Optimal Flexible Architecture changes, with new default locations for database and network configuration files. These are just some of the innovations delivered by Oracle Database 21c (and beyond). Will you be ready?

In this lab, you’ll gain valuable, hands-on experience upgrading an existing non-container database to Oracle Database 21c. You’ll learn how to prepare the environment, choose the best migration technique, safeguard the database, and fall back from failed upgrades. Once the upgrade is complete, we’ll guide you through demonstrations of the most exciting and notable features introduced in Oracle 21c.

Sean Scott

Sean Scott

Principal Consultant, Viscosity North America

Oracle ACE

Oracle 21c Upgrade Workshop (Part 2)

Wed Feb 09, 2:20 PM – 3:20 PM MST / 3:20 PM – 4:20 PM CST

Oracle Database 21c brings significant changes and considerations for database administrators. With Oracle 21c, multi-tenant architecture is required, and the familiar Optimal Flexible Architecture changes, with new default locations for database and network configuration files. These are just some of the innovations delivered by Oracle Database 21c (and beyond). Will you be ready?

In this lab, you’ll gain valuable, hands-on experience upgrading an existing non-container database to Oracle Database 21c. You’ll learn how to prepare the environment, choose the best migration technique, safeguard the database, and fall back from failed upgrades. Once the upgrade is complete, we’ll guide you through demonstrations of the most exciting and notable features introduced in Oracle 21c.

Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Viscosity North America

Oracle ACE

Deep Dive into SQL Tuning

Wed Feb 09, 3:35 PM – 4:35 PM MST / 4:35 PM – 5:35 PM CST

Tuning SQL statements in Oracle is more of an art than a science. In this session we will cover the basic tools and steps to tuning a SQL statement starting with finding the SQL statement and collecting the right information. How does the Optimizer work to transform SQL into an execution plan? What information is an execution plan is trying to show? Finally, what are some of the things that can be tuned as well as tools Oracle has provided to make things easier. If you are new to tuning SQL in Oracle or trying to freshen up your skills, this session should have enough information for everyone.

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!