Dani Schnider

buff.lyHow to Find and Avoid Duplicates in Data Integration #JoelKallmanDayDuplicate rows are the enemy of every data integration developer. They can cause job failures and – even worse – wrong results. Somtimes it is more complex than expected to avoid them. …

Is fighting with duplicate rows in #SQL a common challenge for you? @danischnider.bsky.social shows options you can use to detect and remove them DISTINCT GROUP BY HAVING COUNT (*) > 1 QUALIFY RANK () OVER ( ... ) = 1 And covers their pros & cons buff.ly/4ILDU9z

It seems I’m not the only old guy at #HrOUG2026 talking about the past 🥸 @chandlerdba.bsky.social talking about his first experience in performance tuning

Let’s learn some math basics after lunch at #HrOUG2026 @ora600pl.bsky.social on stage

blogs.oracle.comblogs.oracle.com

Interesting use case for Vector Search in Oracle 26ai: “Which song (based on the lyrics) fits best to my mood” @andreakennel.bsky.social at #HrOUG2026

Dani Schnider reposted

Chris Saxon

@chrisrsaxon.bsky.social

Joel was all about community. So to celebrate #JoelKallmanday I wanted to recognise the work by the customers, partners, ACEs and enthusiasts blogging I've compiled a list of blogs by them covering the #SQL features added to Oracle AI Database over the past year. blogs.oracle.com/sql/communit...

Dani Schnider reposted

buff.lyAggregation Filters in Oracle 26aiThe FILTER clause in SQL allows an easy way of adding WHERE conditions to aggregation functions. There were other ways to implement this before, but this syntax extension is easier to understand. I…

You can do conditional COUNT, SUM, etc. in #SQL with SUM ( CASE WHEN ... END ) Or the SQL standard SUM ( ... ) FILTER ( WHERE ... ) Added to Oracle AI Database in release 23.26.1 @danischnider.bsky.social shows in action and how to use it for pivoting buff.ly/oika3CE

Finally arrived in Rovinj after a long journey. #HrOUG2026, we are coming soon 😊

danischnider.wordpress.comHow to Find and Avoid Duplicates in Data Integration #JoelKallmanDayDuplicate rows are the enemy of every data integration developer. They can cause job failures and – even worse – wrong results. Somtimes it is more complex than expected to avoid them. …

My contribution to #JoelKallmanDay: A new blog post about how to find and avoid duplicates in data integration (examples with fictitious data, inspired by a true story) danischnider.wordpress.com/2026/10/13/h...

Good idea for a Christmas gift: @chris.antognini.ch’s third edition of “Trobleshooting Oracle Performance” will be published on 21 December

Keynote by @ashishray.bsky.social at SOUG Day

SOUG Day 2026 in Zurich starts, @krischan.bsky.social welcomes the audience

Did you know that @jloracle.bsky.social is now an expert on Powerpoint? 😂 … … and of course still an excellent speaker at #POUG2026

Performance quiz with indexes and @carajan.bsky.social at #POUG2026

@monikalewandowska.bsky.social

Crowded rom for @chandlerdba.bsky.social‘s session „Dissecting Performance Tuning“

Dani Schnider reposted

Monika Lewandowska

@danischnider.bsky.social trusts databases... Weird... #poug2026

Discusdion panel at #POUG2026 about Vibe coding with „a lot of experts, but not on this topic)

Some „basics“ about log writer (LGWR) explained by @christophlutz.bsky.social at #POUG2026, including a live demo with foreground session @franckpachot.bsky.social and log writer @chandlerdba.bsky.social

„Positive plan changes are boring. Nobody complains about plan changes that improve performance“ @vldbb.bsky.social talks about Understanding Suboptimal and Unstable Execution Plans at #POUG2026

Many good tips from @kerryosborne.bsky.social at #PoUG2026 on how to become an expert

Standing ovations after @rogermacnicol.bsky.social‘s very last presentation. After #POUG2026 he is retired

Shape-Changing SQL with @kibeha.dk after lunch at #POUG2026

Next session at #POUG2026: @martinberx.bsky.social and Dawid Welder talk about Performance Analysis & Tuning in ADB

It‘s always good to repeat some basic database concepts: @nakdimon.bsky.social explains at #POUG2026 how condtrsints work in Oracle

…including very interesting live demos

Interesting use case for Oracle TxEventQ, presented by @jasminfluri.bsky.social at #POUG2026

Dani Schnider reposted

Oracle ACE Program

@oracleace.bsky.social

1 Sept

🇵🇱 POUG 2026 lands in Kraków on 4–5 September! 🎤 Two days of deep technical content, real-world Oracle expertise and community connections—plus an incredible lineup of #OracleACE speakers sharing knowledge across the agenda. 🚀 🔗 social.ora.cl/6018B1iqFp

danischnider.wordpress.comJOIN TO ONE and Star SchemasOracle’s new JOIN TO ONE syntax offers several benefits for queries in star schemas. Let’s take a look at some typical use cases involving facts and dimensions, and see how the new join option can …

19 July

If you want to know how the new JOIN TO ONE syntax can help to reduce complexity of SQL queries and avoid incorrect results in star schemas, read my lastest blog post: danischnider.wordpress.com/2026/07/18/j...

Dani Schnider reposted

buff.lyJOIN TO ONE and ConstraintsThe new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint defi…

9 July

Detect unwanted join duplicates in Oracle AI Database with t1 JOIN TO ONE ( t2 ) This uses foreign keys to define the join But what if the constraints are DISABLE or NOVALIDATE? @danischnider.bsky.social shows it runs but has performance implications

danischnider.wordpress.comJOIN TO ONE and ConstraintsThe new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint defi…

1 July

How the new JOIN TO ONE syntax extension of Oracle 26ai works with enabled and disabled constraints. Read my newest blog post: danischnider.wordpress.com/2026/06/30/j...

Dani Schnider reposted

buff.lyPartition by ExpressionIn the latest version of the Oracle database, it is now possible to define the partition key of a partitioned table using an expression. This was already possible previously, but only with a small …

11 June

Oracle AI Database 23.26.1 added partition by expression support => you can use an expression directly instead of a column e.g. by email top-level domains with PARTITION BY LIST ( REGEXP_SUBSTR ( email_address, '[^.]+$' ) ) @danischnider.bsky.social demos

29 May

What a nice execution plan 😂 Martin Ladecky presents an interesting „crash case“ at #MakeIT2026

danischnider.wordpress.comImplementing Multi-Temporality with Data Vault (Part 3)In the last part of this blog series, we will look at how to load Slowly Changing Dimension (type SCD1 and SCD2) from the Current Views we created in our multi-temporal Data Vault schema.

18 May

Last part of my blog series about Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/16/i...

danischnider.wordpress.comImplementing Multi-Temporality with Data Vault (Part 2)Loading multi-temporal data into Data Vault is quite simple, a explained in the previous blog post of this series. But how can we extract the current data in a simple and convenient way to populate…

11 May

Part 2 of my blog series about Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/08/i...

danischnider.wordpress.comImplementing Multi-Temporality with Data Vault (Part 1)Data change tracking is a key concept in any data warehouse and many other analytical systems. Rather than explaining the same concepts over and over again, I decided to write a blog series on this…

6 May

Part 1 of my new blog series: Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/05/i...

30 Apr

Yeah, my session for #POUG2026 is accepted 😀 See you in Kraków in September!

Dani Schnider reposted

Mirela Ardelean

@mirelarooug.bsky.social

18 Apr

When community turns into friendship: the traditional annual #sym42 gathering @sym42.bsky.social

12 Apr

New blog post: Playing around with Calendar Functions in Oracle 26ai danischnider.wordpress.com/2026/04/12/p...

Dani Schnider reposted

buff.lyEnhanced Partitioning Metadata in Oracle 23cOracle 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.

8 Apr

Sometimes its the small changes that make the big difference Oracle AI Database 26ai added HIGH_VALUE_CLOB HIGH_VALUE_JSON To the partitioning dictionary views => it's easier to query partition boundaries @danischnider.bsky.social discusses

23 Mar

#OracleBeerBern meetup in Berne. The speaker comes from far away, but the beer is local. Welcome in Switzerland, @connormcd.bsky.social 🇨🇭🍺

sessionize.comPOUG 2026: Call for SpeakersWelcome to the POUG - a vibrant, one-of-a-kind community based in Poland that gathers people from all over the world. Once a POUGer, always a POUGer! ...

17 Mar

Just submitted a nerdy session for #POUG2026: How I build my own database system in my first job. Call for Speakers is still open for another 14 days: sessionize.com/poug-2026 Hope to see you in Krakow in September!

Dani Schnider reposted

buff.lyQUALIFY: The WHERE Condition for Analytic FunctionsFiltering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…

4 Feb

The QUALIFY clause enables you to filter rows using window functions e.g. get the top ranked rows with SELECT ... FROM ... QUALIFY RANK () OVER ( ORDER BY ... ) = ... @danischnider.bsky.social looks at how it works in Oracle AI Database 26ai

Dani Schnider reposted

Gerald Venzl

@gvenzl.bsky.social

27 Jan

🎉 #Oracle #AI #Database 26ai Enterprise Edition is now generally available for Linux x86-64 on-prem!

geraldonit.comOracle AI Database 26ai Enterprise Edition now GA for on-premises Linux x86-64Oracle AI Database 26ai Enterprise Edition is now generally available for Linux x86-64. You can download it from the usual places, such as the Oracle Database download page, Software Delivery Cloud (eDelivery), and My Oracle Support (the RU). Check out the Oracle AI Database New Features Guide to see all the new features that came in this release. …

Dani Schnider reposted

buff.lyWhat’s new for Developers in Oracle AI Database 23.26.0For more information on what’s new in Oracle Database 23.9, see: What’s new for Developers in Oracle Database 23.9 Oracle AI Database 23.26.0 brings some fantastic new features to developers—again!…

25 Nov 2025

Oracle AI Database 23.26.0 developer features include QUALIFY clause GraphQL Table Function for SQL SQL Objects and Collections in MLE JavaScript PL/SQL RESETTABLE clause to avoid ORA-04068: existing state of packages has been discarded @gvenzl.bsky.social

21 Nov 2025

On the way home from #DOAG2025: We were too careful with the expected delay of Deutsche Bahn. So we habe 75 minutes to change in Munich. Time for a beer 😊

Dani Schnider reposted

buff.lyData Types of Join ColumnsThe data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema.

20 Nov 2025

How do the data types of join columns affect query performance? @danischnider.bsky.social compares using Hashes as CHAR(32) and RAW(16) Sequences as NUMBER And finds in Oracle #SQL NUMBER is faster than RAW RAW is faster than CHAR