Sean D. Stuber (@sdstuber) | teapawt

Sean D. Stuber retweeted

Tim Hall ∞🐵+∞⌨️@oraclebaseOct 14

Continuous Delivery of Oracle Database Features #JoelKallmanDay oracle-base.com/blog/2026/10… @OracleDatabase @oracleace

26

862

Sean D. Stuber retweeted

Connor on SQL and Database

@connor_mc_dOct 13

Can we get faster DDL? #JoelKallmanDay connor-mcdonald.com/2026/10/… @oraclebase @oracleace @OracleAPEX #orclapex

Blazingly fast DDL? #JoelKallmanDay

We’ve all had that common frustration when we’re in the middle of building a query, or a database API, or a PL/SQL module and we need to know the structure of a table. We fire up either…

connor-mcdonald.com

19

918

Sean D. Stuber@sdstuberOct 14

seanstuber.com/2026/10/14/lo… #JoelKallmanDay

Looking at Proxy Users #JoelKallmanDay

I had a few questions come up lately that involved proxy users and some of the answers were surprising. To illustrate the scenarios I’ll create a couple of users, one with a password, one wit…

1

157

Sean D. Stuber@sdstuberAug 23

New post! seanstuber.com/2026/08/22/cm…

CMU bug fixed in July DBRU for 19c and 26ai

Oracle’s July 2026 Database Release Update (19.32 and 23.26.3) contains an unannounced fix for a subtle bug in Centrally Managed Users. The bug is easy to reproduce but likely not seen in mos…

72

Sean D. Stuber@sdstuberJun 15

seanstuber.com/2026/06/15/se…

See you at KScope!

After a 7-year hiatus from speaking at any conferences, I’ll be presenting at KScope 26 in Denver.

1

20

Sean D. Stuber@sdstuberMay 4

seanstuber.com/2026/05/03/so…

Solving Performance Problems with a Touch of Magic

When I’m tackling a complex performance problem spanning multiple programs, machines, services, etc. I like to wave a magic wand, invoke mystic elves, or call on friendly gnomes to assist me …

1

21

Sean D. Stuber@sdstuberJan 2

After the holiday break, jumping back into the puzzles with a fun one using Oracle Spatial and Graph seanstuber.com/2026/01/02/ad…

Advent of Code 2025- Day 9

Movie Theater Part 1 was pretty straightforward. I extract the X and Y coordinates from each line and then using a self-join, I compare the areas of each possible rectangle. As with many other, sim…

1

49

Sean D. Stuber@sdstuber24 Dec 2025

seanstuber.com/2025/12/24/ad…

Advent of Code 2025- Day 8

Playground This one felt tricky at first with lots of words and seemingly numerous combinations of how to arrange the boxes, but the solutions turned out to be fairly straightforward. It wasn’…

1

32

Sean D. Stuber@sdstuber17 Dec 2025

seanstuber.com/2025/12/16/ad…

Advent of Code 2025- Day 7

Laboratories This one was a little misleading, but that’s probably more due to me assuming too much going in than any tricky wording. My first thought was this would be a recursion puzzle bec…

1

27

Sean D. Stuber@sdstuber14 Dec 2025

seanstuber.com/2025/12/13/ad…

Advent of Code 2025- Day 6

Trash Compactor Like Day-5, I accepted a slight efficiency hit by reading the data twice for logical convenience. I read the numbers as one CTE and then read the corresponding operators as a second…

1

39

Sean D. Stuber@sdstuber10 Dec 2025

Advent of Code Day 5 seanstuber.com/2025/12/10/ad…

Advent of Code 2025- Day 5

Cafeteria I accepted a small inefficiency in part 1 by reading through all of the data twice in order to come up with two data sources. One for the ranges of fresh ids, and the other the list of id…

1

35

Sean D. Stuber@sdstuber9 Dec 2025

Advent of Code Day 4 seanstuber.com/2025/12/09/ad…

Advent of Code 2025 – Day 4

Printing Department The first map puzzle of the year. Part 1 was a simple count; just loop through each position and see how many neighboring rolls it has, if it’s less than 4, increment a co…

1

18

Sean D. Stuber@sdstuber6 Dec 2025

This took me longer than it should have. I knew that I knew how to do part 2, but it took me a long time to remember the trick. seanstuber.com/2025/12/05/ad…

Advent of Code 2025 – Day 2

Gift Shop Day 2 was both easy and hard. Easy because it was easy to understand and hard because I knew there was a trick that would make an efficient solution for part 2 but I couldn’t rememb…

23

Sean D. Stuber@sdstuber6 Dec 2025

Single function works for both parts 1 and 2, just changing length parameter. seanstuber.com/2025/12/06/ad…

Advent of Code 2025 – Day 3

Lobby I was kind of disappointed in day 3 because it’s the same puzzle twice. So one solution solves both parts 1 and 2, just changing the length from 2 to 12. I start by looping from the fir…

20

Sean D. Stuber@sdstuber5 Dec 2025

26ai coming to on premises Linux for non-engineered systems! seanstuber.com/2025/12/05/26…

26ai coming to on-prem in January!

Many of had given up hope, but an official announcement has been made and I am, like many others, excited to start installing it on our Linux systems.You can read the official announcement hereR…

16

Sean D. Stuber@sdstuber5 Dec 2025

Starting late, but I'll try to catch up seanstuber.com/2025/12/05/ad…

Advent of Code 2025 – Day 1

I’m late getting started on the puzzles this year, I’ll try to catch up and see how many I can do before I break for the holidays and family time.Secret EntrancePart 1 was fairly obviou…

15

Sean D. Stuber@sdstuber15 Oct 2025

seanstuber.com/2025/10/15/cr…

Creating APEX report with rolling set of columns #JoelKallmanDay

The last several years I’ve participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contrib…

28

Sean D. Stuber@sdstuber14 Oct 2025

seanstuber.com/2025/10/14/du…

Duplicating an IG does not duplicate Automatic Row Processing DML

When you duplicate an Interactive Grid in APEX, if that region has a process to perform Automatic Row Processing DML; the new, duplicated region, will not have a DML process created for it. You can…

31

Sean D. Stuber@sdstuber29 Jul 2025

seanstuber.com/2025/07/29/us…

Using SQL to derive dice distributions in D&D

In a previous article (Bringing APEX and PL/SQL to D&D) I used a package with formulas of predetermined distributions for rolling multiple dice. In this article I will show how I came up with t…

1

72

Sean D. Stuber@sdstuber20 Jul 2025

New blog post - Oracle, APEX, PL/SQL, and Dungeons & Dragons seanstuber.com/2025/07/19/br…

Bringing APEX and PL/SQL to D&D

While there are plenty of opportunities in the real world to use APEX; I felt the need to bring APEX into my gaming. The idea started with a conversation in mid-game about some tactical decisions i…

63