## Reboot

2020 has been a tough year for many, but I can’t complain considering what other people have gone through. While others lost their job due to the shutdown, I could work from home for extended periods.

## OGB Appreciation Day 2019: A Special part of the Oracle Community

I don’t know why I stopped blogging, probably because I am lazy or easily distracted. But this annual opportunity to say thanks to some people who has helped me a lot shouldn’t be missed (I did last year). Tim Hall aka ORACLE-BASE organizes an annual virtual Thanksgiving for us Oracle nerds.

## KSQL server failed to start after upgrade

I just upgraded a small Confluent Kafka cluster at a customer. Almost everything went fine, just following these instructions: https://docs.confluent.io/current/installation/upgrade.html (our servers are running on CentOS). But at the end KSQL server wouldn’t start and failed with this error message:

## Presentation at Riga Dev Days 2019

The slides from my talk at Riga Dev Days 2019 will be available here after the session.

## Presentation at OBUG 2019

Here is the link to the presentation.

## Import Large Excel Files with SQL Developer

If you try to import large Excel files to SQL Developer, it may hang for a long time. But let say you like SQL Developer very much, or you are too lazy to find another tool, here is a way to load large Excel files. By converting the Excel files to CSV SQL Developer can load it much faster.

## Presentation at POUG 2018

Here is the link to my presentation at POUG 2018 in Sopot, Polen

## Converting Epoch Time to Date with a Virtual Column

Epoch time is common in some situations because it is easier to do date calculations than with normal dates. The most popular is UNIX Epoch time which is the number of seconds since the start of January 1, 1970.

## Oracle 12c and SSL

I was supposed to do something else that involved using the package UTL_HTTP from the database accessing an URL over HTTPS. Instead I lost several hours troubleshooting ORA-29024: Certificate validation failure and ORA-28750: unknown error (Nice error the last one).

## ODC Appreciation Day: SQL

Most of my work in the Oracle world has been DBA-oriented. But for the last years, I have rediscovered the joy of development and data analysis. When I haven’t been writing the code myself, I have often helped other developers when they connect to the Oracle database, and their program does not perform as expected.