Lightnews — Scholar-powered news

Reposted by Dani Schnider

DOAG e.V. @doagev.bsky.social · 20h

@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

3 5

Reposted by Dani Schnider

DOAG e.V. @doagev.bsky.social · 14d

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

3 4

Reposted by Dani Schnider

DOAG e.V. @doagev.bsky.social · 25d

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

Zwischen Linux-Fallen und Virenscanner-Schocks: Datenbankgeschichten aus der Schweiz

YouTube video by doagtv

youtu.be

4 7

Dani Schnider @danischnider.bsky.social · Sep 7

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

2 15

Dani Schnider @danischnider.bsky.social · Sep 6

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

4 25

Dani Schnider @danischnider.bsky.social · Sep 6

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

2 6

Dani Schnider @danischnider.bsky.social · Sep 5

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

#HrOUG2024 #POUG2025

11

Dani Schnider @danischnider.bsky.social · Sep 4

See you soon in Poznań

5

Reposted by Dani Schnider

Oracle ACE Program @oracleace.bsky.social · Sep 2

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

6 16

Dani Schnider @danischnider.bsky.social · Aug 22

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

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…

danischnider.wordpress.com

1

Dani Schnider @danischnider.bsky.social · Aug 5

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...

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.

danischnider.wordpress.com

3 7

Dani Schnider @danischnider.bsky.social · Jul 21

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

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

9

Dani Schnider @danischnider.bsky.social · Jun 27

An informative day at the #TDWI conference in Munich, organized by #DDVUG (German Data Vault User Group), fully packed with bitemporal data integration. Presentations about concepts, design patterns and practical experience.

3

Dani Schnider @danischnider.bsky.social · Jun 27

Another year, another certificate: I'm happy to still be part of the #OracleACE community 😊

@oracleace.bsky.social @sym42.bsky.social

1 1 16

Reposted by Dani Schnider

Polish Oracle User Group @pougorg.bsky.social · Jun 20

We know that beer & database are a perfect pairing 🍻

At #POUG2025, @danischnider.bsky.social will walk you through a real-life brewery use case to show how Data Use Case Domains in Oracle 23ai can organize, secure, and simplify your data like never before.

poug.org/edycja/poug-...

2 3

Reposted by Dani Schnider

SQLDaily @sqldaily.bsky.social · Jun 17

Build a solid foundation for star schemas in Oracle Database with these guidelines by @danischnider.bsky.social

Dimension

Primary key on the surrogate key
Unique constraint on the business key column(s)

Facts

Foreign key & a bitmap index on each dimension column

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 abo…

buff.ly

1 6

Dani Schnider @danischnider.bsky.social · May 31

After #MakeIT2025 conference: Istrian breakfast with all local products

1 11

Dani Schnider @danischnider.bsky.social · May 30

Last session at #MakeIT2025: Performance Grand Prix by @monikalewandowska.bsky.social - who will win the race?

1 4

Reposted by Dani Schnider

Kim Berg Hansen: SQL ♠ 🤓 👨‍🍳 🍺 @kibeha.dk · May 30

Can 👉you👈 do better than both @danischnider.bsky.social and #ChatGPT?

All the tables and data used in that #SQL battle is available at github.com/kibeha/pract...
(Companion code repository for the book Practical Oracle SQL amazon.com/dp/1484256166)

May the best intelligence win 🤓

Andrej Pashchenko @andrejsql.bsky.social · May 30

Who will win? @andreakennel.bsky.social , @danischnider.bsky.social or #ChatGPT? We'll see.

1 5

Reposted by Dani Schnider

Andrej Pashchenko @andrejsql.bsky.social · May 30

Who will win? @andreakennel.bsky.social , @danischnider.bsky.social or #ChatGPT? We'll see.

1 4

Dani Schnider @danischnider.bsky.social · May 30

Day 2 of #MakeIT2025 starts with block corruption. Fortunately not in real, but in
the presentation of
@cgohmannde.bsky.social

1 4

Dani Schnider @danischnider.bsky.social · May 29

Very clear explanation how SQL Macros work

1 2

Dani Schnider @danischnider.bsky.social · May 29

I finish the first day of #MakeIT2025 like I started it: with a session of @andrejsql.bsky.social. This time he talks about parameterized views in Oracle

1 1 5

Dani Schnider @danischnider.bsky.social · May 29

Different ways to open a beer bottle: @ora600pl.bsky.social talks about „low level stuff“ at #MakeIT2025

1 5

Reposted by Dani Schnider

Andrej Pashchenko @andrejsql.bsky.social · May 29

How can we help the Oracle optimizer to do better with function calls? @danischnider.bsky.social explains. #makeit2025

1 3