Are you new to Twitter, and need people to follow to get the conversation started? If you work with Oracle, then please continue reading. Don’t forget to check out @BrentO’s Twitter Book! I harangued (definition) my colleague and close friend this morning until he relented in joining Twitter. He specializes in Oracle, so I thought I would send him a quick who-to-follow list in the Oracle Community. As I was building this list, I was…
Assumptions can often get us in trouble. People don’t know what you think they know, and they know what you don’t think they know. I often present to small groups. I ask questions up front to gauge the experience level, but even so I am forced to make some assumptions. Then there are some basics that I assume any database user will have nailed down. I recently spent 90 minutes talking about writing queries and…
A play on words – the Axis of Evil, three countries that foster or promote terrorism. This is not a history lesson or political discussion, go here for that. So what is the Access of Evil? I would propose that the following practices conspire to bring down any well-ordered collection of data: MS Access MS Excel SELECT *. So do I have anything meaningful to add to this discussion at this point, or was I…
My former boss, and current friend, bought an Android phone for himself and his wife last week and asked me for a list of my must-have apps. I’ll list them here for the morbidly curious, but that got me thinking – what are my must-have scripts for managing my Oracle database? I know we’re supposed to use they ‘tool’ things, but I seriously doubt any real DBA relies 100% on what a pretty console screen…
No. For several years now I have been an Oracle database dude who eavesdropped on the SQL community. I hoped to pick up the lingo and become savvy enough that I could say “Yes, I do SQL Server.” If I’m being honest, then I must admit I have largely failed. Yes, I understand what people are talking about, I can read the blogs and get what they are saying. But as Robert Heinlein coined in…
Missed PT I?: Read Part I my favorite aspects of each RDBMS platform Update: Read PT III where I talk about monitoring indexes I had the pleasure of hanging out with @oraclenerd and @SQLChicken earlier this year in Tampa, FL. It was remarkable for a couple of reasons, but what I remember most is playing translator. When @SQLChicken would rave about one of the SQL experts on Twitter, I would relate to @oraclenerd how that…
I love books. I remember when my local school system had a partnership (evil plan) with Pizza Hut. For every six books I read, I earned a free personal pizza. I was reading upwards of 10-20 books a month when I was in elementary school. This may have been partly due to me living in a rural area with no local kids my age to play with, but I’ll pretend it was because I was…
For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data in their relational database. Wow, that opening segue was more awkward than my first date with my wife…which is another…
Many moons ago, this was a pretty straightforward question. It also had a very easy answer, the DBA owned performance. By that I mean if the database or it’s applications did not perform as expected, it was the DBA who would step in and fix it. Several years ago this began to change. More and more shops started to expect the developers to have more than a passing awareness that their applications relied on a…
Someone suggested I document where, who, and what I use to get things done in my day-to-day dealings with all things Oracle RDBMS. Since I am very open to suggestion, here it is: Official Stuff Unofficial Stuff Twitter Folks Updated Dec 14, 2014 Oracle Docs Official Link Oracle’s official online documentation. I generally just ‘Google’ the term I’m interested in alongside the keyword ‘Oracle.’ Nine times out of 10 (unscientific gut feeling), the Oracle Docs…