Dani Schnider

QUALIFY: The WHERE Condition for Analytic Functions Filtering 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…

Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post:

danischnider.wordpress.com/2025/10/24/q...

Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community.

Discover more:
🔗 soug.ch/event/soug-day-zurich-2025/

@helifromfinland.bsky.social @danischnider.bsky.social

A funny last session at #HrOUG2025 with SELECT AI Funhouse and @kibeha.dk

Last day at #HrOUG2025 starts with @salvis.com fighting with bad code

Fundamentals of Oracle security (and some drinks) with @chandlerdba.bsky.social at #HrOUG2025

Basic knowhow that every Oracle developer and DBA should know: how do transactions work in an Oracle database. @martinklierdba.bsky.social explains it in detail at #HrOUG2025

This is how a latch contention looks in real life. The @ora600pl.bsky.social way at #HrOUG2025

The slides were generated by ChatGPT - @ora600pl.bsky.social switches back to his traditional presentation style with beer and live demos

So many slides on a session of @ora600pl.bsky.social ? Something must be wrong here. Let‘s see…
#HrOUG2025

Hopefully not, otherwise beginners like me would be lost

After lunch break session at #HrOUG2025 about CI/CD using #SQLcl, presented by @apexconsulting.nl (with a very nice t-shirt, by the way)

If you are at #HrOUG2025 and don‘t speak Croatian, you are probibly interested in this additional session tomorrow

Quiet moment during the #HrOUG2025 conference

Lot if interest in deep diving into performance of views by @danischnider.bsky.social at #HrOUG2025

#HrOUG2025
@fsarcos.bsky.social talks about dragons and PDB failover approaches in Oracle 23ai (aka 26ai)

I still like this session of chandlerdba.bsky.social about Exadata alternatives and why Exadata is still the cheapest and best solution.
Once again at #HrOUG2025

Looking forward the the 30th anniversary of a wonderful conference

#HrOUG2025

Almost there… #HrOUG2025

Just arrived in Rovinj in time thanks to the professional „Grisselbav Tours“ driver @salvis.com with co-pilot @andreakennel.bsky.social

@danischnider.bsky.social erzählt uns in einem Kurz-Interview von seiner großen Begeisterung für die #DOAG2025 in Nürnberg. ➡️ scomp.ly/jPg3bBb

Die Anwenderkonferenz
📍DOAG 2025 Konferenz + Ausstellung | Nürnberg Convention Center
📅 18.–21. November 2025

🔗Anmeldung | scomp.ly/YAj48bE

Datenbankpannen made in Switzerland: Von DropTable bis Split-Brain – Teil 2 unserer DOAGtv-Geschichten mit Martin Klier, @stefanoehrli.bsky.social und @danischnider.bsky.social zeigt, wie Recovery-Nächte auch mal mit Pizza enden ➡️ scomp.ly/Y3DVQmY

YouTube video by doagtv Zwischen Linux-Fallen und Virenscanner-Schocks: Datenbankgeschichten aus der Schweiz

Von #SQL-Horror bis Dialekt-Wirrwarr: Die erfahrenen Oracle-Experten und ACEs @stefanoehrli.bsky.social, @danischnider.bsky.social und Martin Klier sprechen im DOAGtv 🎥 über #Datenbank Pannen, #Performance Fallen und wie Humor beim #Recovery hilft.

Teil 1/2 ➡️ youtu.be/a8uolY6Or1U

Back home after #POUG2025

Many good discussions, high-quality presentations - and some beers and whiskies 😊

I need some time to sort all these impressions - and I already have an idea for a new session on #POUG2026

It was a wonderful conference again! Thanks to @ora600pl.bsky.social @luizafrompoland.bsky.social and the whole POUG team for organizing #POUG2025

Premiere at #POUG2025: @jloracle.bsky.social shows pictures on his slides 😁

Its weird to meet the kids of old people on conferences 😉

#HrOUG2024 #POUG2025

See you soon in Poznań

Join the Oracle ACEs at POUG 2025 this week in Poznań.
Knowledge, lectures, discussion and networking for two full days! Join them now ♠️ 👉
poug.org/en/edycja/po...
#OracleACE @edelweissk.bsky.social @ora600pl.bsky.social @julianfrey.ch @danischnider.bsky.social @chandlerdba.bsky.social

Book Review: “Data Engine Thinking” by Roelant Vos and Dirk Lerner If you are planing to develop a new data warehouse or replace an existing one, the book “Data Engine Thinking” is a good choice to read. Also if you are interested in data architecture, data modell…

One of my summer projects was to read "Data Engine Thinking", a new book by Dirk Lerner and Roelant Vos on the methodology for developing a data solution. A short review of this book you can find on my blog.

danischnider.wordpress.com/2025/08/22/b...

@dv-modeling.bsky.social

Oracle 23.9 supports GROUP BY ALL Aggregating data is now easier than ever before with the newest version of Oracle database 23ai. Oracle version 23.9 supports the GROUP BY ALL syntax.

With Oracle database 23.9, we can finally use GROUP BY ALL in our SQL queries, as you can read in my latest blog post:

danischnider.wordpress.com/2025/08/05/o...

Members of @sym42.bsky.social on tour in Transylvania 🧛‍♂️

@andreakennel.bsky.social
@mirelarooug.bsky.social
@danischnider.bsky.social