The “Who Ya Gonna Call” edition of Log Buffer, a Carnival of the Vanities for DBAs.
July 28, 2006 – By Bill “Shrek” Thater
The “Something strange in the neighborhood” feeling happens to all of us at one time or another. When it does we all have people we go to for answers. This week I thought I’d wander through some of the places I go to look for the latest information and to get questions answered.
One of the first places I go is to AskTom and so does Robert Vollman. And as he points out in his AskTom post sometimes the questions and answers there are just funny.
And that leads to how to ask questions. Let’s not follow the example that Tom Kyte himself points out in Shine up that crystal ball shall we?;-)
If it’s security that’s the issue, I go visit Pete Finnigan’s blog where we find such gems as Blackhat Las Vegas 2006 and unwrapping PL/SQL. And hot off the press 07/27/2006: “How to bypass the protection implemented by DBMS_ASSERT” looks like SOL injection rears it’s ugly head again. Always a good read even if you’re not having security issues. Maybe especially if you’re not having them.
For more mind-stretching stuff I go visit Mark Rittman for things like Partition Exchange Loading using OWB10gR2.
I sometime go straight to the source and check Oracle Blogs where we find a whole bunch of stuff by Oracle employees like Allison Holloway’s post on her new PHP and Oracle book.
If it’s more general stuff you’re looking for like Monitoring Index Usage you can go visit Doug Burns. Just watch out for the monkeys.;-)
If MySQL is your platform of choice, and performance is suffering [I hate it when that happens.;-)] go visit MySQL Performance Blog to find such things as Extended EXPLAIN or MySQL EXPLAIN limits and errors.
If Postgres is more to your liking try Celebrity Deathmatch: Postgres vs. PostgreSQL or maybe Postgres compatible table names for MediaWiki. And you can always check the weekly news at PostgreSQL Weekly News – July 23 2006
Visiting my friend Niall Litchfield always produces some interesting coments like Listing RMAN backups and the importance of syntax.
And for those of you using SQL Server check with Brian Kelley for things like New SQL Server 2005 Books Online download available.
Another good source of information are the blogs at DBAZine.com where you’ll find people like Chris Foot with musings on being a DBA: The Non-Technical Art of Being a Successful DBA.
Archive Log
The no longer newbie Lisa Dobson [ as she points out in Happy Birthday Newbies Blog post] still has a lot of good information in her blog. like this blast from the past Studying for the OCA/OCP Exams – Hints and Tips that includes excellent advice for those of you taking the exams.
Finally, as a full disclaimer, most of the people mentioned here are friends of mine. Yup I am that lucky.;-)
Next week be sure to visit Doug Burns for Log buffer #4.
So as we say here in Texas “Y’all come back soon now, hear?”
Re the PostgreSQL-Postgres name change: I’m in favour of it, for all the reasons mentioned in the original article.
Maybe later they can change it again to Post-diddy.
Thanks Bill!
Dave Edwards
Nice job Bill.
I totally agree that the name “PostgreSQL” is actually a terrible name for good software. I’m pretty sure it has held them back, frankly. Postgres is a definite improvement.
Maybe then we’ll hear that Ingres has relaunched as IngreSQL to differentiate?
Paul
Well done Bill! Thanks for MySQL Performance Blog – full of interesting stuff.
Btw, MySQL explain plan is missing the cost-like numbers completely…
How would the optimizer make the decision? Purely based on number of rows or some magic value is used?
Carnival of the Vanities?!? You rock.
[…] Thater has published the third Log Buffer on his gruntdba. Good job, Bill — […]
MLwQs0 hi great site thx http://peace.com
great picture/very nice site
great thoughts
Wow.. I’m literally lost reading this post. So many links and so many details. Great post!
Hello !!! Good job admin… Nice website… 🙂
Why Am I following you art? 🙂
скачать и смотреть онлайн новые кино фильмы
только у нас новые фильмы на фтп
Отделка квартир
Hey, I found your blog in a new directory of blogs. I dont know how your blog came up, must have been a typo, anyway cool blog, I bookmarked you. 🙂
I’m Out! 🙂
tattoo book designs,
[…] Log Buffer #3 — Bill Thater’s gruntdba […]
http://www.merce-infos.com.pl/krzyzak-wraz-z-satelitami-rozdziela
Shopping for a new or used car might be a hard approach unless you know what you are actually performing. By teaching yourself about vehicle purchasing prior to deciding to head to the dealership, you may make points less difficult on your own. The following tips will help your next buying getaway become more pleasurable.
Generally take a auto mechanic alongside when buying a fresh car. Automobile merchants are popular for marketing lemons and you may not wish to be their following patient. When you can not get yourself a technician to consider cars along with you, no less than make certain you have him take a look at ultimate selection before you purchase it.
Know your limitations. Prior to starting shopping for your forthcoming car or pickup truck, make a decision what you can afford to spend, and stay with it. Don’t neglect to feature fascination with your calculations. You will probably pay all around twenty percent as a down payment too, so be ready.
Well before seeing a car dealership, know which kind of car you need. Research most of you choices ahead of shopping in order to decide what works well with your financial budget and household needs. Do your homework to learn simply how much you need to be paying to get a potential vehicle.
Before you sign any commitment spend some time to read through each line, including the small print. If you find something detailed that you do not comprehend, do not sign up until you have an answer which you comprehend. Unsavory salesmen are able to use a contract to put in numerous charges that were not discussed.
In the event you maintain the preceding suggestions under consideration the very next time that you go looking for a auto, you will certainly be prone to get a full package. Getting a car does not have to become headache. Simply use the tips using this write-up and you may receive the car you desire at a excellent price.