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

My first encounter with computers, circa 1982?

A new version of github.com/oracle/rwloa... has been released! Many new features to simplify scripting, updated Oracle Net tools (ociping, connping), and much more. Download at github.com/oracle/rwloa..., Users' Guide at oracle.github.io/rwloadsim/ including link reference manual.

Just installed an Apex application into current version of Apex and 23ai DB, that I last used on 11Gr2 and exported with Apex4 back then. It Just Works #orclapex

Kinda funny, that whenever I'd like to quickly check my timeline, that instead of entering 'tw' I now enter 'bs' in my url field...

New Oracle Red Bull Racing race car from Lego announced. You can pre-order now 🏎️ #oracle #Lego www.lego.com/en-dk/produc...

Nu op NU.NL... Zouden ze daar op de redactie ook zelf krom liggen van 't lachen, of is de domheid al tot zo'n dieptepunt gedaald dat ze 't gewoon niet doorhebben?

Sad not to be able to join the community in Nuremberg at #doag2024. There's a project entering the critical end-game phase, that needs a lot of my attention these weeks. ;-)

ORA-39405 Great start of the week. Not....

Left X. Here now.

Now seriously contemplating leaving this platform...

This morning...

😎

Fellow miracle workers.

https://docs.oracle.com/en/database/oracle/oracle-database/23/aliad/iad_home.html Nice...

Never trust stated behavior of Java (with frameworks) code towards the database. Do a sql-trace and see what really happens.

Today's surprise 🙂

:-)

The moral here is: DB Time is *still* less than network time in apps that we get to see. https://twitter.com/ToonKoppelaars/status/1807388775615545553

⁦@BjornEngsig⁩ Sure do. My copy looks slightly different though.

New DBMS_USERDIAG package. You can now sql-trace binds and waits in ADB of your, or any other session in your PDB. https://docs.oracle.com/en/database/oracle/oracle-database/23/arpls/dbms_userdiag1.html First set it...

If you're moving a chatty application into OCI, be sure to quickly have a read of this new doc: https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/low-latency-connections.html

Bijna 300 kentekenhouders met meer dan 50 verkeersovertredingen per jaar https://www.nu.nl/binnenland/6311781/bijna-300-kentekenhouders-met-meer-dan-50-verkeersovertredingen-per-jaar.html CJIB heeft de Group-By clause van SQL ontdekt.

Tuning by color. Do I tune that latch, of find the root-cause why it's taken so often?

This has #SmartDB vibes all over it: https://www.youtube.com/watch?v=sC1B3d9C_sI#SmartDBQuotes: - One TX needs around 10 SQL statements - Each one does a network roundtrip - You can use stored procedures to get that down to 1, but that's only a 10X win - If you put 100 TXs in one SP-call,...

Rare footage from 1987 of someone developing data-entry screens in Forms 2.0. :-)