MV2ADB – One-Click Move of your Data into OCI Autonomous Databases – Auto Operation
This post was originally published on this siteIn the previous blog post MV2ADB – One-Click Move of your Data into OCI Autonomous Databases – Step by Step I wrote about the new Oracle Cloud Infrastructure tool to transfer local data into Autonomous Databases step by…
Data Vault Queries and Join Elimination
This post was originally published on this siteIf you work with Data Vault for a data warehouse running in an Oracle database, I strongly recommend to use Oracle 12.2 or higher. Why that? Since Oracle 12c Release 2, join elimination works for more than one…
Moving to GitHub
This post was originally published on this siteOver the years, my blog has become one big mess. It was no longer a blog. It contained product pages, change logs, software downloads, FAQs and even a forum. That was a nice experiment. But now it’s time…
Update Center for Free SQL Developer Extensions
This post was originally published on this siteIntroduction In July 2017 Oracle announced to release updates for SQL Developer on a quarterly basis. Installing multiple versions of SQL Developer on the same machine is not a problem. Therefore many developers install a new version as…
Small fix for SQLcl Java problem with Oracle 12.1
This post was originally published on this siteLet’s say you want to quickly use some cool features of SQLcl inside the script running on the database server, but only Oracle below version 12.2 is available there (which is the first one being shipped with SQLcl)….
Last Week in Stream Data Integration & Stream Analytics – 18.12.2019
This post was originally published on this siteThis is the 178th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from…
Workshop von Roelant Vos „Data Warehouse Design Patterns“ vom 18.-20. Feb. 2020 in Zürich
This post was originally published on this siteIch möchte auf einen speziellen Workshop «Data Warehouse Design Patterns – Implementierung und Automatisierung» von Roelant Vos aufmerksam machen. Im Workshop von Roelant Vos wird nicht nur Theorie vermittelt, sondern auch wie man mit den Tools von Roelant…
Constants vs. Parameterless Functions
This post was originally published on this siteDo you use parameterless PL/SQL functions in your queries? Did you know that this may cause performance issues? In this blog post I explain why parameterless functions can be the reason for bad execution plans in any Oracle…
Conference Review 2019 (Part 3)
This post was originally published on this siteIn the last four weeks, I had the chance to speak at three different conferences. This was the finish of an intensive conference year for me with many impressions, learning, knowledge sharing, new and old contacts and of…
Social Media @trivadis