Welcome, readers, to the 129th edition of Log Buffer, the weekly review of database blogs. Welcome also to 2009, so fresh it still has that wonderful new year smell. Let’s take ‘er out on the road and see what she can do.

Starting with Oracle (and reaching back here a little into the holidays), Doug Burns had performance on his mind—to be precise, his own at UKOUG; and some performance-related blogs he’s found worthwhile. Doug’s recommendations themselves always perform well.

Tanel Poder was on the same road. In his item, …

Welcome to the 128th edition of Log Buffer, the weekly review of database blogs.

Let’s begin with some PostgreSQL blogs. Jignesh Shah shares his recipe for making a PostgreSQL 8.3 appliance based on OpenSolaris using VirtualBox. While we’re on appliances, Dave Page shows off PostgreSQL management on the iPhone with an application he himself wrote. Stealth DBA for the bus-rise home.

On Database Soup, Josh …

The 127th edition of of Log Buffer, the weekly review of database blogs, has been published by Robert Treat on zillablog.

As the web’s only technology-neutral compendium of database blogs, Log Buffer thrives on reader contributions, such as story suggestions, comments, and foremost, volunteer editors like Robert (who, by the way, today joins LB’s multiple-edition group). He knows that publishing an edition of Log Buffer on his blog is an excellent way (and a fun way) to present his perspective on database blogs in an established venue. I invite you to do the same— send me an email and I’ll get you started.

Here is Robert’s …

Welcome to the 126th edition of Log Buffer, the weekly review of database blogs. Just to be different, let’s start with PostgreSQL this time.

The Postgres OnLine Journal offers their PostgreSQL 8.3 PLPGSQL Cheatsheet.

The ever-reliable Hubert Lubaczewski of select * from depesz; has a couple posts this week. He has a howto for recovering from a lost PostgreSQL password. Thanks, Hubert. We’ve all been there. He also introduces …

It’s time for another exciting installment of Log Buffer, the weekly review of database blogs.

On Prestidigitation of Oracle, Bradd Piontek gets it started with the second in a series on migration to 10g—Making the database a safer place, reviewing security-related changes in 10gR2. (Full disclosure: I should also mention that Bradd is now sitting just a few desks away from me.)

The ORACLE-BASE Blog has a dynamic duo of articles—one each on installing Oracle 11.1 and installing Fedora …

This is the 124th edition of Log Buffer, the weekly review of database blogs. Welcome.

Here’s what the Oracle blogosphere had to offer. On Oracle and more, Amardeep Sidhu announces the birth of the North India Oracle Users Group. Not too far away, on the AskDba.org Weblog gets the word out about a seminar by Tom Kyte on 18th December in Bangalore, arranged by the All India Oracle User Group.

Vivek Sharma examined …

This is the 123rd edition of Log Buffer, the weekly review of database blogs. Welcome.

Let’s begin with some SQL Server, where it was a week of technical tips. Alexander Kuznetsov looks at defensive database programming. “In most cases LIKE conditions should by followed by ESCAPE clauses,” he asserts, continuing, “You have a choice: you can either have a CHECK constraint disallow special characters, or you can fix the procedure,” thus error-proofing your logic. Readers Alejandro Mesa and Adam Machanic suggest a couple refinements.

On …

Welcome to the 122nd edition of Log Buffer, the weekly review of database blogs.

Let’s start with MySQL. As you probably know, the Americans were at the polls this week. In keeping with this, Keith Murphy is polling for opinion on the question: MySQL on Debian or Ubuntu? The conversation is here; the poll is on Keith’s Diamond Notes.

A quick note by Sun CEO Jonathan Schwartz on how, with the outcome of those other polls, change has come to America, in the form of its new president and his …

This week gives me a chance to get back into something I love to do—write. For those who don’t know, my name is Keith Murphy and I am a MySQL DBA at the Pythian Group. In addition, I have the privilege of being the editor of the MySQL Magazine, a quarterly  magazine for those who use MySQL on a daily basis, either as a DBA or a developer. The sixth issue was just released last week and is available for download now. But enough about me! Let’s see what you all had to say this week.

Beginning with the world of MySQL.

Monty Taylor kicks things off, bringing us news of the …

Previously on Log Buffer: Log Buffer #119.

And now.

Welcome to Log Buffer #120. My name is Warner, and I’m a SQL Server DBA at The Pythian Group. This is my first time on Log Buffer duties ever, so here’s hoping I can give everyone a fair and unbiased look at this week in the database blogging world (and related).

I admit I had no idea of the community or state of the PostgreSQL RDBMS, and so I definitely learned some new stuff this week. First off, over on “The Scale-out Blog” Robert Hodges invites us all to get our …