Some of my earliest memories involve trips to the dentist when I was maybe 3 or 4 years old. To this day, my blood pressure rises whenever I go in for a simple cleaning. There’s a particular poster I can’t seem to get out of my head, like a bad 80’s song. The intent was to encourage us kiddies to floss our teeth. I remember thinking “Well, I don’t need ALL my teeth…” Hmmm, this…
A lot of good news this week about jobs here in the United States and a bunch of new hires for the month of April has many people feeling much better about the US economy. After being hammered with depressing reports for the past two years, it’s very nice to see the pendulum swing in the other direction. Quest has hired a couple hundred people in the past few months. This is kind of a…
I know you can read, you’re here. But maybe you’re a functioning illiterate. Here’s what I mean. You spend a lot of time in the database writing queries, analyzing data, doing important stuff. Most of the time, things go great for you. You can answer questions for people. You make things happen. The wheels of the business bus go round-and-round. But there’s one thing that really, really scares you. Execution/Explain/Access Plans. Those things that describe…
Disclaimer: I work for Quest Software. I am paid to promote and help sell their software. Did you know we also give away a lot of software, with no intention of selling it? One of the most popular database platforms out there is MySQL. I’m going to guess that’s because it is free (for now). Apparently it is downloaded more than 70,000 times a day. WOW. I don’t use MySQL Jeff. If you are a…
So you’re on Twitter. An interesting blog post rolls by. You click on it. You love it. You reward the author with a RT or even better, a Follow, or a reply on Twitter. The blog author, sees said Twitter response, and is like ‘Awesome!’ But secretly, they are disappointed. Why? Because what they really wanted was a RT AND for you to leave your comment on their blog. Because comments on a blog let…
I’m sorry, I didn’t realize there was such a thing as a ‘fake’ DBA Jeff! Ok, so labeling someone as a ‘real’ DBA is a bit insulting to DBAs everywhere. If you have children, that makes you a parent. If you are responsible for a database, then you are a DBA. So what exactly am I getting at? What do you most fear, and have you ever faced that fear? If you are sitting there…
Did you know you can run Oracle RDBMS for free? Updated on 11/25/2011 – 11gR2 now available for Windows x32 and Linux x64 Yes, there are limitations (fine print), but just about anyone can take advantage of this offering. So, why should you care? Maybe you are a developer, and your DBA refuses to grant you privs you need to do your job. Well, if you can run your own local copy of Oracle, you…
A lot of folks contact me off-line, asking if I really do hate Chet, or do I just like kidding him. Mostly, it’s me forgetting that Chet hates it when I InitCap his Twitter handle, @oraclenerd. Or am I remembering that he hates that? Hmmmm… Anyways, I needed to write this post so people would know, that, ‘yes’, I really do like picking on Chet. He refuses to wear my Toad t-shirts, and more importantly,…
Do you take pleasure in killing peo…people’s sessions in the database? If so, you are not alone. If you have Blocking Locks, the easiest way to fix that is kill the offending session and free up the requested resource. But, who should win this battle? What transactions take precedence? Should the business analyst have his report kiboshed because a developer is testing a new feature? Should an ETL process be allowed to finish under any…
Database developers and DBAs often play the role of gunslinger, or a hired gunman. Someone brought in to ‘kill’ the bad guy, in this case, an under-performing database. Our tools of the trade are not as dramatic as firearms, but we can do just as much damage. Ever heard of Angry Birds? In this mobile game, users get various weapons (in the form of Angry Birds) to launch at the naughty piggies. What are your…