Make IT 2019: Slovenian Oracle Users Group (SIOUG) Conference 2019!

Hello all,

I’m very happy to announce I’ll be at this year Slovenia Oracle Users Group annual event, in Portorož, at Kongresni center Portus. When? October 14-15th.

This is one of 6 events on Oracle Groundbreakers EMEA Tour 2019.

There will be:

  • 65+ Slots
  • 6+ Tracks
  • 2+ Workshops

More info:

 

Just a few pics from 2018 to give a taste…

NoSQL Brasil 2019! October 5th!

Hi all,
Just passing by to remind you: Don’t lose this chance!

We’ll have a great and unique event in Brasil to discuss NoSQL Solutions and I will be there too! Didn’t know? Check all about NoSQL Brasil here!

NewScreenshot 2019-09-03 às 19.45.34.png

When? October 5th, 2019!

Where? FIAP Auditorium. 1222, Lins de Vasconcelos Av. São Paulo-SP.

Complete Agenda? Here!

How to confirm me presence? >>>Click here<<<<!

The team of speakers is awesome: Otavio Santana, Gonzalo Urday, Leandro Domingues and Igor de Paula. I’m glad to be among those exponents, sharing about Oracle NoSQL.

My session will be “Oracle NoSQL 101 for Oracle RDBMS DBAs“, where I’ll be sharing specifically from a RDBMS DBA perspective: What are the advantages of NoSQL in comparison to classic RDBMSs? How to integrate traditional data with new NoSQL structures? This session compares Oracle NoSQL with solutions for different proposes like Document, Columnar, Key-Value, Cache Systems e Graph databases, besides explore concepts like Data Integration and Oracle Maximum Availability (MAA) for Oracle NoSQL.

See you there!

GUOB 2019 Review

Hello all!

Last August 10th I had the privilege of being again (4th in a row) speaking in Groundbreakers Tour São Paulo / aka GUOB Techday 2019!

However, this year for the first time as a GOUB Counselor, organizing this event. So, I’d like to thank you all for being there and for the friends in GUOUB for this great opportunity.

This year I had the pleasure to talk a little bit over a few tips in my session: Tips and Tricks from over 20K hours DBA oncall.

Besides those, I could also be in some other awesome sessions delivered by top speakers in the world, including:

  • Mike Dietrich: Master Product Manager on Database Upgrade / Migration team.
  • Sandesh Rao: VP – Autonomous Database Health e Machine Learning.
  • Ricardo Gonzalez: Cloud Migration Product Manager.
  • Nirmala Sundarappa: Java/DB Product Manager.
  • Ricardo Portilho: Oracle Instructor and Consultant
  • Vicent Romero: Java JDK Compiler Engineer

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Some additional stuff:
–  Slides from GUOB Sessions
Event Album

Thanks for everything, GOUB Community! See you soon!

AROUG 2019 Review

Hello all!

This year I had the privilege of attending Buenos Aires Groundbreakers edition for the fist time! This event is organized by AROUG. And here goes my thank you and my congratulations to specially to Sebástian and Rita for the great reception and event organization!

There I had the pleasure to talk a little bit over a few tips in my session: Tips and Tricks from over 20K hours DBA oncall

Besides those, I could also be in some other awesome sessions delivered by top speakers in the world, including (the ones I could attend): Markus Michalewicz, Ricardo Gonzalez, Rodrigo Jorge, Alberto Salazar, Facundo Grande, Anil Niar and Vicent Romero.

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Thanks for everything, Buenos Aires and AROUG! See you soon!

 

UYOUG 2019 Review

Hello all!

This year I had the privilege of attending Montevideo Groundbreakers edition for the fist time! This event is organized by UYOUG. And here goes my thank you and my congratulations to Nelson, Edelweiss, Daniel and Pablo for the great reception and event organization!

There I had the pleasure deliver a session telling a story about a project I have handled recently: ODBCS+OGG+Standby in Cloud: Building an Elastic Environment for your Business.

 

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Thanks for everything, Montevideo and UYOUG! See you soon!

Memorias.jpeg

CLOUG 2019 Review

Hello all!

So, this is a very special review for me, once this is the most special event I have ever participated personally. Why? Because Jen and Pablo surprised me there with my ACE Director Announcement!  😀

ACEDAnnouncement.jpeg

 

SO, then, being ACED, I had the privilege to deliver 2 sessions:

  • Amazing Free Tools for Oracle DBAs
  • Tips and Tricks from over 20K hours DBA oncall

But besides those, I could also be in some other awesome sessions, as per:

  • ADWC for Developers and Data Scientists – by Edelweiss Kammermann
  • Navigating on the Exadata Architecture – by Franky Weber Faust
  • Oracle Sharding for Data Sovereignty and Massive Linear Scalability – by Markus Michalewicz
  • Oracle Partitioning for DBAs and Developers. Why, when and how to use it? – by Franky Weber Faust
  • Rogue One: Avoid the Rebels take your data using DBSAT and other Security Best Practices – by Roy Salazar Valverde

 

What I think? I can’t wait for the next one! Besides the great friends we met, it’s amazing to discuss such relevant topics with specialists on the area.

Thanks for everything, Chile! See you soon!

Formação DBA em Três de Maio (em 19c!)

Olá pessoal,

Atipicamente post em português hoje, para lembrar a todos que no próximo dia 14/09 começa a Formação DBA em Três de Maio/RS, no Campus SETREM. Aulas somente em Sábados.

Não perde tempo e se increve já!

A formação é resultado da parceria entre a SETREM e a TargetTrust, que ministra cursos de TI há mais de 26 anos. Eu serei o instrutor da formação que é de 132 horas no total, dividida em 5 módulos.

O primeiro módulo “SQL e SQL ANSI” a se iniciar no dia 14/9 e tem 24 horas aula (3 sábados: 14/9, 28/9 e 5/10) , tratará de entre outros:

  • Comando SELECT, suas cláusulas e operadores
  • Funções single row, de conversão e expressões de condição
  • Sub-consultas e operadores SET.
  • Criação, gerenciamento e manipulação de tabelas
  • Implementação de constraints e utilização de views
  • Construção de SQLs avançados.
  • Performance de SQL e ferramentas para análise

Inscrições até 30/8!
Valores promocionais pra egressos, colaboradores SETREM e Pacotes Empresariais disponíveis.

HrOUG: Croatian Oracle Users Group Conference 2019!

Hello all,

I’m very happy to announce I’ll be at this years Croatia Oracle Users Group annual event, in Rovinj, at Hotel Istra 4, in St. Andrew island. When? October 15-18th.

This is one of 6 events on european Oracle Groundbreakers Tour this year.

Lectures will have 20 speakers from Oracle ACE Program (11 directors, 5 ace, 3 associate, 1 alumni). I’m happy to be one of those 11. 🙂

The event also has:

  • 4 keynotes
  • 20 Oracle ACE program speakers
  • 10 Oracle Corp. speakers
  • 3-4 Social evening events

More info:

 

Just a few pics to give a taste…

See you there!

Stop Migrating Databases to 12c!

If you are starting an upgrade plan, do it directly to 19c. Why?

Well, first let’s say that 19c is “equal” to 12.2.0.3 on previous version model, while 18c is 12.2.0.2, after latest 12.2.0.1. So, thinking reasonably, you would already plan for latest PSU on the future version, right? So this is 19c.

But not only this. It’s well known that Oracle’s Terminal Patchset is the Long Term Release for each version. And for 12.2 family this is 19c.

The image below (From Doc ID 742060.1) should help on clarifying this:

versions

In summary, since August 1st 2019:
– 11.2.0.4 is already on Extended Support (20% more expensive unless you have ULA)
– 12.1 family is already on Extended Support (20% more expensive unless you have ULA)

Which only leave us with 12.2 Family. Now I ask you, why jump to any “PSU” other than the final one?
Also, support on 12.2.0.1 goes only up to Nov 2020 and for 18c (12.2.0.2) only to Jun 2021, while 19c goes up to 2026 with ES/ULA!

I’m not even raising the great improvements we have on newer versions (if you are in 11.2, shame on you, you are basically 6 years behind the world technology wise).
Myself , I already migrated several databases on different clients to 19c and it’s running preeeetty fine. So trust on it!

Ok, so to migrate to 19c? (Some tips):
– To migrate directly to 19c you need to be on supported terminal patch set (11.2.0.4, 12.1.0.2) or on 12.2 family (12.2.0.1, 18c).
– Get in touch and use AutoUpgrade mechanism (you’ll love it!) – AutoUpgrade Tool (Doc ID 2485457.1)
– Check Upgrade Guide: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/index.html
– Have a look on Mike Dietrich blog for news: https://mikedietrichde.com/
– Test it before doing in prod.

Additional Reference:
Release Schedule of Current Database Releases (Doc ID 742060.1)
Very nice and complete post (in portuguese) on this topic from Ricardo Portilho.

I like very much the table below as well:

NewScreenshot 2019-08-13 às 15.11.34

See you!