You better run and catch it then! You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is. I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before their query will finish executing. You sit down and write what looks to be a pretty straightforward request for some…
Farming out your application to a hosting service really has a lot of appeal. Let someone else worry about backups, performance and uptime Service Level Agreements (SLAs), upgrades, etc. But do you really know exactly what your hosting agreement includes? What you will have access to? What is and is not covered? Picture courtesy Public Domain Pictures.NET One of the most eye-opening conversations I’ve ever had was with %*#@(^* – you know where they are…
Think the NHL or PGA seasons are brutally long? Try keeping up with all of the SQL Server and Oracle events. The friendly folks in Denver, CO tend get the conference ball rolling with the Rocky Mountain Oracle User Group (RMOUG) Training Days event. I had the pleasure to attend a couple of years ago and catch some skiing with my wife. Every conference doesn’t turn into a vacation, but I try! The 2011 calendar…
Relational databases are powerful for many reasons, but you cannot deny the ‘relational’ part is pretty compelling. Rows or ‘tuples’ in a table are comprised of related data. So for one row in an Employee table, you can assume that each value or column pertains to that particular Employee. Of course you can’t – or rather shouldn’t – put everything about said employee in a single row or table. I hate using absolutes, but in…
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…