Star Schema Design in Oracle: Partitioning
This post was originally published on this sitePartitioning is one of the most powerful features for data warehouses in Oracle databases. In this blog post, I explain how it can be used for the physical design of star schemas. What is the recommended partitioning strategy…
2022: Live again at Conferences
This post was originally published on this siteIt has become almost a tradition for me to write an annual review of my conferences and presentations. The good news: In 2022, most of the conferences were on-site again. Additionally, there was another important event for me…
proxysql-nagios with Python 3.x
This post was originally published on this siteIf you use MySQL together with ProxySQL and if you ever wondered if very handy proxysql-nagiosscript (https://github.com/sysown/proxysql-nagios) will work with Python 3.x, I can give you an answer – yes, but at least with the current version (v….
Duplication of Oracle database on same node/cluster with skip of tablespaces
This post was originally published on this siteIn this blog post I want to write about a typical restore scenario. You need to restore a database to a historical point in time to investigate some former data or maybe even rescue some data, but need…
Star Schema Design in Oracle: Fundamentals
This post was originally published on this siteWhat are the design rules for good performance in a star schema in an Oracle database? This blog post series introduces some recommendations for the physical database design. This first post is about constraints and indexes. For the…
optimizer_secure_view_merging and plsql_declarations
This post was originally published on this siteThe Original Problem A customer is currently upgrading some Oracle databases from 11.2 to 19c. One query was extremely slow on the new test system and my job was to find out why. The root cause was that…
Bye Bye Trivadis
This post was originally published on this siteToday is my last day at Trivadis. I worked for this company more than 23 years, and most of the time, I loved my job. To conclude my time as a consultant and trainer, here are three funny stories…
Quoted Identifiers #JoelKallmanDay
This post was originally published on this siteBackground and TL;DR Connor McDonald wrote a blog post named Cleaner DDL than DBMS_METADATA. Back then he asked me if it would be possible to let the formatter remove unnecessary double quotes from quoted identifiers. Yes, of course….
DOAG2022 Highlights
This post was originally published on this siteNobody knows what kind of restrictions we will experience later this year. That’s why the DOAG Conference + Exhibition 2022 took place in September instead of November. The organizers wanted an in-person event. While you can access some…