chet justice @oraclenerd

dad, oracle (database) enthusiast, nerd, wannabe triathlete oraclenerd.com Tampa, FL Joined February 2008

Tweets

17K
Followers

3K
Following

282
Likes

776

chet justice @oraclenerd

2 years ago

(Re)Reading @TimGormanTech 's Bad CaRMa post from...2006 here: red-gate.com/simple-talk/op… It was part of my required reading from 2013: oraclenerd.com/2013/06/requir… Anywho..."Everything new is old again" is my phrase of the day.

0 0 3 248 0

chet justice @oraclenerd

10 years ago

@krisrice @thatjeffsmith Better?

1 1 4 0 0

Download Image

chet justice @oraclenerd

3 years ago

15 years here? That's nuts.

3 0 10 2K 0

Download Image

chet justice @oraclenerd

3 years ago

oooohhh...name dropping @HeliFromFinland and @KentGraziano in a single call!

3 0 8 0 0

chet justice @oraclenerd

4 years ago

DTIBJ...

0 0 0 0 0

Download Image

chet justice @oraclenerd

4 years ago

It's been awhile Twitter. Please be patient while I relearn how to navigate.

1 0 4 0 0

Download Gif

chet justice @oraclenerd

4 years ago

Pondering how the "data dictionary" came to be...i.e. what drove the idea behind storing the metadata of the data. Who's got insight? @CaryMillsap @oraclebase @TimGormanTech @DBAKevlar @krisrice @JLOracle /me leaves off a lot of people unintentionally...

3 0 5 0 0

chet justice @oraclenerd

4 years ago

Just starting out? Lots 'o questions? I'm 20 years in, learning a whole new thing. I'm a newbie. How to ask questions the smart way. Read it. Internalize it. Ask questions, the *smart* way. I promise you'll find people who will *want* to help you. catb.org/~esr/faqs/smar…

0 0 0 0 0

chet justice @oraclenerd

4 years ago

Oh yeah, I remember now. I came to complain about @jackryanamazon saying, "I have an S.Q.L. query to solve this problem" or whatever nonsense. 1. He mispronounced it. It's "sequel." 2. He should have said federated query as it was 2 (or more) unrelated databases.

0 0 4 0 0

chet justice @oraclenerd

4 years ago

This gif applies to so many different scenarios: Spiders, Snakes, Data Modeling, whatever.

1 0 2 0 0

Download Gif

chet justice @oraclenerd

4 years ago

Kinda annoyed. > The rule is: Use an before a word beginning with a vowel sound (not letter). Tells me that the writer pronounces SQL wrong.

6 1 5 0 0

Download Image

chet justice @oraclenerd

4 years ago

Interesting finding of the week. In AWS Redshift, if you issue a SELECT on a MV, you cannot issue a REFRESH MATERIALIZED VIEW because there's a lock on the underlying internal table. The SELECT *must* be followed by a COMMIT. Or just set AutoCommit=TRUE for your connection.

2 0 9 0 1

chet justice @oraclenerd

4 years ago

Dammit @CaryMillsap... I'm quoting this one, often, as well. carymillsap.blogspot.com/2011/01/axioma… My fav is the reply to @joelgarry

2 0 7 0 1

Download Image

chet justice @oraclenerd

5 years ago

meanwhile, on Redshift... SELECT * FROM svv_table_info WHERE table = 'my_table'; [Amazon](500310) Invalid operation: syntax error at or near "table" My bad, "table" - thanks postgresql person who named a column with the reserved word "table" so now I have to quote it...

2 0 4 0 0

chet justice @oraclenerd

5 years ago

This applies to so many things: "...If spending 10 extra minutes formatting your data better saves 1,000 readers 2 minutes each, then you’ve saved the world 1,990 minutes of wasted effort..." - @CaryMillsap carymillsap.blogspot.com/2016/05/messed…

2 3 6 0 0

Candy Granger @mounttovalley

7 years ago

Very busy day on the Boston Marathon FB page today as they announced new tougher qualifying requirements:/ But a great day to tell them to #LetSamRace #LetThemRace If you have a few seconds let them know we are still fighting for #inclusion ! TIA