“Those people are fine, they JUST write SQL.” I often hear this in the context of visiting customers and offering to provide training (and yes, software) to their database users. There is a class of people who are deemed unworthy of such productivity tools because they do nothing but ‘just write dumb SQL all day long.’ The only problem is, I know that it’s these people that are largely responsible for running the business. When…
Oracle 11gR1 Enterprise Edition with the Diagnostic and Tuning packs has a very compelling new feature, Real-Time SQL Monitoring. Oracle thinks enough of the feature that it was highlighted prominently in whitepaper by ACE Directory Arup Nanda titled “Oracle Database 11g: The Top Features for DBAs and Developers” (read it here) Long story short: Too late or too lazy to start a trace on a poorly performing query? Want to know what is going on…
Coming up with themes and titles for a blog post can be very challenging. You want something that will catch the eye, but not be so random or out of left field that no one catches your drift. This morning I had two themes battling inside my head for this post. Welcome to the Jungle Baby! Pigs In Space You’re here so you already know who won. Pigs in space? Pigs don’t belong in space?!?!…
Ask questions, get answers – and a Toadie! He wants questions. You want answers (and a Toad). So, ask away – stump the Toad chump! We’re looking for challenging questions dealing with Oracle Database and Toad, for example: Can Toad do that? I had this problem once where… I hate it when… The Rules! If I like your question, you get a Toad beanie. I’ll answer any and all questions submitted. Please keep the questions…
My database crashed today. My ‘production’ database that is. The one I rely on for product demonstrations, that thing I do that Quest gives me money for. Pretty funny considering in the last few weeks my blogs have included such gems as: Are You a Real DBA – I argue that you are indeed NOT if you have not went through the crash and recovery nightmare What Databases Should You Back Up – I argue…
So the news is out, Charlotte NC is a destination city! image courtesy Wikipedia 2012 Democratic Presidential Convention 2013 PASS Summit Already folks are wondering, hey, where is Charlotte? And, can I get good sushi there? Charlotte is a city I visit frequently. Here are a few things I’ve picked up along the way: It’s the ‘Queen City’ – but so are a half dozen other towns in the US The downtown area is called…
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…
If I had a dollar for every time someone asked me to help them setup their database application or utility to not ‘let someone do something in the database they are not supposed to do’ over the past 10 years, I would literally have about $347. This is generally how it goes: Them: We want your tool, but we don’t like that it lets user do X. Me: Awesome! I want to give you our…
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…
Wait a sec, we don’t let developers even look at Production, much less touch it! There’s no way they can break anything over there. Whew! Jeff was just pulling our chains! I hate to be the bearer of bad news, but it’s even worse than you think. The code that those developers wrote? Guess where it runs everyday? That’s right – in production. So instead of them fat-fingering in production, a bad piece of code…
