A common defence for storing data as flat tables is: Joins are expensive But is that really true? Thomas Kejser ran performance tests and found Joins are CHEAP when compared with the alternatives This can be true even if you read the whole table buff.ly/AFykOZF

My venue this afternoon. Come join my session at 3PM on 26ai assertions new feature. #apexconn26

A marvellous LinkedIn post (no really) from a colleague of mine on one of the promises of AI. Those of you who know my sense of humour, or have ever engaged with the old Oak Table folks, will probably appreciate it. www.linkedin.com/pulse/2-mill...

That's actually pretty good :-)

Got one up and running again 😍

Now.

Then.

Where's Wolowitz when you need him?

youtube.com/watch?v=mD1g... My favorites: #10 and #1. But all are spot on.

Here we go.

Another weekend of just-in-time presentation creation for a user-group...

I updated my SQL Assertion article with some maths and added the ALL ... SATISFY syntax that avoids double NOT EXISTS in Oracle Database SQL Assertions dev.to/franckpachot...

Assertions for data integrity on a less-than-ideal data model. www.kibeha.dk/2026/03/asse... Or "How I could have used assertions 25 years ago when I worked with Concorde XAL"... #OrclDB #SQL #Assertions #OracleACE

SQL-Assertions in #oracle26ai : They work. They are a Very Powerful feature!). And you can even see + inspect some the effort that "makes it happen" /cc @toonkoppelaars.bsky.social @oracleace.bsky.social simpleoracledba.blogspot.com/2026/03/orac...

How do you enforce temporal data integrity? With SQL Assertions in Oracle AI Database, we can now implement constraints such as: ✅ Non-overlapping validity periods ✅ Temporal referential integrity Here's a practical example using an extended DEPT-EMP model. www.salvis.com/blog/2026/03...

For my US followers: careers.oracle.com/en/sites/job...

Assertions Define cross-row, cross-table constraints with simple SQL: CREATE ASSERTION ... CHECK ( <rule> ) Use this to enforce rules like * No overlapping start-end dates * Every parent row must have a child row (invoices must have an invoice line)

Keep hitting ORDS-22001, what's the thing I'm missing? - I've granted my procedure to everyone - I've used ords_admin.add_plsql_gateway_procedure to add it - I've added it to wwv_flow_epg_include_mod_local Any ideas? @alexnuijten.bsky.social @apexconsulting.nl

Oh my... docs.oracle.com/en/database/...

At dbdbd2025.uantwerpen.be

Adds used to be fun...

Next interesting topic.

Next: Roel and Alex. #DOAG2025

This is just fan-tas-tic :-) dev.to/sreeni5018/t...

A little known about SQL feature... being able to "bring along extra columns" when you aggregate.

Apart from the funny pronounciation of SQL, a pretty good summary of history here. www.youtube.com/watch?v=lvCZ...

I noticed different people use the terms "inner" and "outer" table/rowsource differently for NL-joins. Never liked the terms myself: I always use 1st table/rowsource and 2nd table/rowsource when discussing NL-joins. And for HASH-joins: build and probe.

If you're a DBA, this is essential viewing youtu.be/QLyCcOBWb9o

Oracle Database Free 23.8 is now available Get it at www.oracle.com/database/fre... This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL: Enhanced dynamic stats for PL/SQL in FROM & WHERE This can be particularly useful for estimating pipelined table functions

Morgen 80 jaar geleden, verloor mijn vader (nu 90) één van zijn zussen. Zijn ouders hadden gehoord dat NL bevrijd was en gingen met 'n roeiboot met hele gezin van boord naar de wal, om 't te vieren. Een paar Duitse soldaten op de dijk hadden het bericht nog niet gehoord, en schoten op de roeiboot...

Omg... Looks like I'm going to Poland :-)

Recognizable. Mandatory Reading for IT folks....

Just submitted my first abstract for POUG. Now we sit and wait...

Some more details on the SQL Assertions feature. New language construct to get used to 😉.

The (near) future of data integrity in the Oracle database is looking beautiful thanks to @toonkoppelaars.bsky.social and his team.

Feature X session tonight in a (almost) sold-out room. This feature coming soon. There is another chance to learn more about this feature at #apexworld25 this Friday! nloug.nl/events/apex-...

Sneak preview of an awesome new #oracle database feature. Not available yet, but “soon” 😉. #nloug

Friday is the day...

New to database development? We've got a one-stop shop for your to get up to speed in just a few days asktom.oracle.com/databases-fo...

btw, you might be able to get even BETTER performance across the network even when you have set your fetch size well. youtu.be/PQjnaCuqtYw

Another "whoah!" today...

Enjoying a last good wine as a fifty- something. New decade starts tomorrow. 😊

Should have been: Edit Continue sending As I'm already in the Send process...

Cosmologists, what is your take on this work? Is dark energy seriously under threat? Could the accelerating expansion of the universe just be because time runs faster in the voids between galaxies? academic.oup.com/mnrasl/artic...

All, @sayanmalakshinov.bsky.social has joined us here at bluesky. Please give him a follow. #FF