Chase Marler

DBA | SQL enthusiast | Musician | Music lover | Husband & Dad | Obligatory: No one tells me to say anything - all from me

[Chase Marler @SQLChaser]

@BungieHelp Still happening...

[Chase Marler @SQLChaser]

anyone know what happened to all these data model examples? https://t.co/ymxEFHlWIz
#sqlhelp

[Chase Marler @SQLChaser]

@BrentO aw - this is broke now :(

[Chase Marler @SQLChaser]

@AmpliFiHome I have been dealing with issues with your Alien mesh system for months with no resolution. Request 324258. Please, Amplifi Twitter gods, help me get this escalated if you can

[Chase Marler @SQLChaser]

@Spotify ok, go ahead and f*ck me all the way up WITH ALL OF THE SABER HILTS?? THANK YOU SO MUCH - MAY THE 4TH BE WITH YOU

[Chase Marler @SQLChaser]

@cl @benrebooted It is. As a DBA who uses their Standard Edition, it’s more like SQL Server express without a size limit, but with a lot of licensing gotchas and red tape

[Chase Marler @SQLChaser]

@cl @benrebooted The worst part is that they don’t even tell you which Views trigger a license. You have to figure that out largely for yourself. There are a few tricks, but most of it is handshakes and contracts.

[Chase Marler @SQLChaser]

@cl @benrebooted Even worse than it sounds. They license by features. Many of those features use Views like DMVs in SQL Server. If you query a history view, for example, the feature that uses the history view will show “used”. Therefore you just used a licensed feature! Oracle gots to go! Lol

[Chase Marler @SQLChaser]

@benrebooted @cl Even if you could, just figuring out what views you can query without causing a license event will send you into the woods screaming.

[Chase Marler @SQLChaser]

Looking for some Postgres training on par with the quality of @BrentO 's for SQL Server. Anyone know of anything? #PostgreSQL #SQLServer

[Chase Marler @SQLChaser]

@thatjeffsmith less ramble: 1. worked for a minute after copied older json file over to new env 2. deleted a bunch of conns trying to help fight corruption 3. happened again 4. deleted json file, still happens. 5. delete .sqldeveloper and relaunch app - everything works, must be something else

[Chase Marler @SQLChaser]

@thatjeffsmith #Oracle what happened to my SQL Dev Connection screen? Is there a switch I can flip to reset?

[Chase Marler @SQLChaser]

@thatjeffsmith ok so...
I deleted the entire .sqldeveloper folder and relaunched the application. All worked well. I added back an older connections.json I had from the prior version folder. Made A LOT of deletions to it. Now I have the same behavior. I've deleted the json file, but still this

[Chase Marler @SQLChaser]

@thatjeffsmith makes sense. I may export what I need and reinstall. I can navigate the filesystem without an issue, open SQL files, save them, etc. Even if I blow all of those connections.json files away I have the same prob ¯\_(ツ)_/¯

[Chase Marler @SQLChaser]

@thatjeffsmith looks like there are multiple connections.json files in my ~/.sqldeveloper dir. Do I need to edit all of them or just the most recent?

[Chase Marler @SQLChaser]

@thatjeffsmith I think this is an OSX or java problem. I ended up granting Full Disk Access to java/sqldev and that fixed the issue....until 2am on Saturday when I got a ring to the on-call rotation. Now i have the same issue.Even deleted the entire system dir and let it rebuild - still no dice

[Chase Marler @SQLChaser]

@Boneist Sounds like the DBA was of MUCH use after all :) Cheers!

[Chase Marler @SQLChaser]

@BrentO

[Chase Marler @SQLChaser]

@corywong WHO IS PLAYING THE SICK BASS SOLO ON ELLIE?!?!?!