Question: How do I find the hour portion of the value between to timestamps? Answer: Use the EXTRACT() function! Thankfully @TheRealLewisC (twitter | blog) pointed us in the right direction! I was tempted to do a subtraction and then a substr() to pull out just the hour portion of the returned string – way more work than necessary for the Optimizer. EXTRACT (Oracle Docs) gives us just what we want! So there is not an…
After a year of tweeting my brains out for the past year, I have some data I could talk about Boring stuff, even meaningless one could argue. Number of followers, number of Re-Tweets, number of lists, my Klout (link) score – ALL BORING. When I try to convince someone to join Twitter, I never reference these slightly less than meaningless metrics. I talk about the REAL value of Twitter – the relationships I’ve cultivated or…
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…