The Incident
While cleaning up some obsolete user accounts, one of my DROP USER commands failed with:
[Read More]
Moved to GitHub Pages
Yet Another Beautiful Jekyll Site!
If you’re reading this, then the migration has worked. My blog is now hosted via GitHub Pages. Many thanks to Kris Rice for his Blogger migration blog post and source code to get me set.
[Read More]
Beware (Sort-Of) Ambiguous Column Names In Sub-Selects
This morning I received an UPDATE statement from a developer that I was testing. It ran without errors but then I saw that it updated 5 rows when it should have only updated 3. The reason gave me a little shock so I whipped up a simple test-case to reproduce...
[Read More]
How (Not) to Change Passwords in PostgreSQL
A few months ago I was doing some testing on a development PostgreSQL database and watching the postgresql server log (akin to Oracle's alert log). I was skimming for lines relevant to my testing when I noticed something chilling:LOG: statement: alter user john password 'IloveDBAs';The username and password have obviously...
[Read More]
The Transition (or: How I Learned to Stop Worrying and Love PostgreSQL)
Note: Yes I re-(ab)used the title.As some of you may know (if you follow me on twitter), after 16 years as an Oracle DBA, I made a career shift last summer. I hung up the Oracle spurs (and that sweet Oracle Ace vest) and threw on a pair of PostgreSQL...
[Read More]