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.
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.
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
And for those of you using SQL Server check with Brian Kelley for things like New SQL Server 2005 Books Online download available.
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?”