In the last two weeks I was very busy: three conferences in ten days are exhausting – but it was a lot of fun. The last conference for this year is over now. Time for my personal conference review that I write since a couple of years.
Star Schema Design in Oracle: In-Memory
In the third part of this blog post series about star schema design, let’s have a look at a powerful, but for many people still unknown feature: Oracle Database In-Memory enables massive performance improvements for typical data warehouse queries.
New “Sales History” Sample Schema in Oracle 23c
The newest version of the Oracle sample schema “Sales History” (SH) finally contains current data again and is easier to install than the previous versions. If you work with star schemas, the SH schema is a must.
SQL Performance Tips in Execution Plans of Oracle 23c
Oracle 23c is like Christmas for me. There are many surprises to be found. This weekend I discovered another nice little enhancement.
Enhanced Partitioning Metadata in Oracle 23c
Oracle 23c has a lot of small, but useful enhancements that makes life of developers easier. For example two new columns in the data dictionary views for partition metadata.
GROUP BY Extensions in Oracle 23c
Since a few days, Oracle Database 23c Free Developer Release is available. It contains many new features that are interesting for developers, especially some nice little extensions in SQL that we missed since years. Let’s start with an easy one in this blog post.
Star Schema Design in Oracle: Partitioning
Partitioning 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 for a star schema, and what are the advantages of partitioning?
2022: Live again at Conferences
It 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 in 2022: I changed my job and work now for Callista.
Star Schema Design in Oracle: Fundamentals
What 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.
Bye Bye Trivadis
Today 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 that happened to me over the years.