SOUG Days 2020

The SOUG Days will take place as a hybrid event at the launchlabs in Basel. A top-class program is waiting for you. Take the chance to expand your knowledge and to maintain your business contacts.

Agenda 01.10.2020


Starting Ending Description
12:50 13:00 Welcome and Introduction
13:00 13:45

Migration to Multitenant with Oracle 19c – Mike Dietrich, Oracle Corporation

Abstract
How do you migrate to Oracle Multitenant?
Sounds simple – but the devil is in the detail.
Database components, time zone, patches – a lot of potential pitfalls. And not to forget the outage.
In 45 mins I will make you fit for a successful migration to the CDB-architecture.

Language
English

Room
Live-stream via Zoom

13:45 14:00 Questions and Break
14:00 14:45

Oracle Cloud Infrastructure Basics – Marco Mischke, Robotron Datenbank Software GmbH

Abstract
The Cloud is the next big thing. So everyone wants to participate, but what is it really? This talk is about the basic things in Oracle Cloud Infrastructure. You will learn, which components make up your cloud, what do you use for what and how is it best set up. Also it will give an overview of how you connect to your cloud. Last bit not least it will highlight some pitfalls you might run into and how to avoid that. The talk is based on the lessons learned througout the first cloud projects and the tests with the Free Tier that can maybe do more than one might expect.
If you ever wanted to know how to start your Oracle Cloud, this talk will answer your basic questions.

Language
German

Room
Live-stream via Zoom

14:45 15:00 Questions and Break
15:00 15:45

Extend your SQL Developer – Philipp Salvisberg, Trivadis AG

Abstract
Do you have existing SQL*Plus scripts, reports or charts to integrate into SQL Developer? Would you like to display further details for a selected object in the Connections window or execute a JavaScript via a context menu? I show you how to do that without writing a single line of Java code.
In this presentation I will explain how to do this using simple examples. All examples are available online.

Language
English

Room
Live-stream via Zoom

15:45 16:00 Questions and Break
16:00 16:45

SQL 101: Why and How (back to the basics) – Franck Pachot, dbi services

Abstract
It was abandoned for a while when NoSQL was the trend. So, you may not have learned SQL, and relational tables, and foreign keys, and Atomicity, Consistency, Isolation, Durability… And now those come again in our databases. Let’s learn it now as when it appeared 40 years ago: with demos on simple examples. Only the practical things – no normal forms here! – focusing on which problems it solves. If you are a fan of NoSQL I may convince you that SQL can provide an awesome developer experience.

Language
English

Room
Live at Launchlabs Basel

16:45 17:00 Questions and Break
17:00 17:45

Automating Oracle Cloud Infrastructure – Ralf Ramge, ICT.Technology

Abstract
For the automation of Oracle Cloud Infrastructure, Oracle relies on Terraform as a tool for orchestration and provisioning.
But why do they want to use this, what are the advantages over the manual administration?
Which challenges await a customer?
How does such automation look like in practice?

Language
German

Room
Live at Launchlabs Basel

17:45  17:55 Questions / End of Day

Agenda 29.10.2020


Starting Ending Description
08:15 08:30 Welcome and Introduction
08:30 09:15

The Fast Lane to Database Expertise – Connor McDonald, Oracle Corporation

Abstract
We have user groups, forums, and meetups…and yet often we’re critical of people who don’t build and learn everything from scratch. We accuse them of using the knowledge of others. But they SHOULD be doing this – we SHOULD be sharing our knowledge and experience! This session is all about sharing!

Language
English

Room
Live-stream via Zoom

09:15 09:30 Questions and Break
09:30 10:15

Grafana and Prometheus just married & PMM was born to monitor your DBs – Elisa Usai, dbi services

Abstract
Do you use Open Source RDBMS such as MySQL, MariaDB, PostgreSQL, Galera Cluster and want to have a single tool to ensure that your system is healthy and performances are good?
PMM is a free software for monitoring, alerting and graphing your DB using some integrated tools (Grafana and Prometheus).

Language
TBA

Room
TBA

10:15 10:30 Questions and Break
10:30 11:15

Die Nacht ist zu kurz: 10 ETL Performance Tipps – Dani Schnider, Trivadis AG

Abstract
Viele ETL-Entwickler und DBAs, die mit Data Warehouses arbeiten, kennen die Situation, wenn die Nacht zu kurz ist. Die nächtlichen Ladejobs laufen ewig, die Benutzer sind morgens unzufrieden, weil sie die neuesten Daten nicht abfragen können. Dies kann mit guter ETL-Performance vermieden werden.

Language
German

Room
Live at Launchlabs Basel

11:15 11:30 Questions and Break
11:30 12:15

Data Lake und Autonomous DB, ein perfektes Paar – Holger Friedrich, sumIT AG

Abstract
Data Lakes sind heute eine Standardkomponente der Information Management Architektur. Dort gelagerte Rohdaten für ein Data Warehouse zu erschliessen ist essentiell. Autonomous DB ist perfekt ausgerüstet, um Daten aus Data Lakes für beliebige Zwecke nutzbar zu machen. Wie das geht erfahren sie hier.

Language
German

Room
Live at Launchlabs Basel

12:15   Questions and End of Morning

Agenda 25.11.2020


Starting Ending Description
12:50 13:00 Welcome and Introduction
13:00 13:45

Morning has broken! The Role of the DBA in the era of Cloud, Machine Learning, and more. – Thomas Baumann, die Mobiliar und Paolo Kreth, Oracle (Schweiz)

Abstract
A DBA-Bear awakens after hibernation. A lot of new creatures buzzing around: Open Source, ML, Big Data, IOT, Cloud Computing; Lean, SaFe and DevOps mushrooms everywhere. Are we an endangered species, or is it just a new step in our evolution?

Language
TBA

Room
TBA

13:45 14:00 Questions and Break
14:00 14:45

PDB Security, Isolation and DB Nest 20c – Stefan Oehrli, Trivadis AG

Abstract
Lockdown profiles, PDB_OS_CREDENTIALS and other measures have been available since Oracle 12c to increase the security of multitenant DBs. However, these functions cover only part of the measures. Oracle 20c introduced DB Nest, which provides a different approach to security in PDBs.

Language
TBA

Room
TBA

14:45 15:00 Questions and Break
15:00 15:45

JSON in Oracle Database:features, use cases and why developers love it (and DBAs, too) – Beda Hammerschmidt, Oracle Corporation

Abstract
This presentation gives a technical overview of the current JSON and SODA features in the Oracle database (news in release 20c and the new Autonomous JSON Database cloud service). It also shows some common customer use-cases and migration stories from NoSQL products to Oracle Database.

Language
TBA

Room
TBA

15:45 16:00 Questions and Break
16:00 16:45

Die ODA erfolgreich einsetzen: Ein Kunden-Projektbericht – Marc Wagner, dbi services

Abstract
Welchen Nutzen bietet mir eine ODA (Oracle Database Appliance)? Sollte ich eine ODA-Lösung in Betracht ziehen? Mit Demos wird gezeigt, wie eine Migration einer 11g-Standard Edition-DB unter Windows mit kurzem Unterbruch auf die ODA auf Oracle 12c beim Kunden migriert wurde.

Language
TBA

Room
TBA

16:45 17:00 Questions and Break
17:00 17:45

Hochverfügbarkeit für Oracle Standard Edition – Eero Mattila, Quest Software GmbH

Abstract
Mit Oracle 19c verschwindet die Möglichkeit, RAC für die Standard Edition einzusetzen. Oracle hat zwar eine „Alternative“ dafür eingeführt, die „Standard Edition High Availability“ (SEHA), aber die ist mehr als ungelenk. In dieser Präsentation erfahren Sie, wie man es erheblich besser machen kann.

Language
TBA

Room
TBA

17:45  17:55 Questions / End of Day



Register for your upcoming event below.

Separator

search previous next tag category expand menu location phone mail time cart zoom edit close