Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .

PostgreSQL

David Fetter shares his recipe for adding only new rows: “Let’s say you have a table and a data set, and would like to add only those rows in your data set that aren’t already in the table. There are hard ways, but here’s an easy one.”

Simon Riggs, the Database Explorer, offers his thoughts on …

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

There were heaps of mostly technical posts this week. I think bloggers are tired of kicking around the ins-and-outs of Sun and Oracle, and wanted to talk about what really matters. So let’s start with . . .

Oracle

Harald van Breederode shows how to setup a private DNS for your virtual cluster.

Pythian’s Alex Fatkulin discusses Oracle GoldenGate …

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

Oracle

Let’s begin with remoteDBAexperts blog, and Chris Foot’s prediction of the future of database tuning and database administration. It will be, ” . . . administrators interpreting and implementing the recommendations generated by the intelligent advisors and ADDM.  . . .  I also think that Oracle will eventually become self-tuning.”

Here in the present, DBAs (Oracle and otherwise) are still Striving for Optimal Performance as Christian Antognini is. Here’s his item on join …

Happy New Year to all our readers! Welcome to 2010 and the 174th edition of Log Buffer, the weekly review of database blogs.

MySQL

The MySQL ‘sphere since the holidays has been thick with posts on the matter of Oracle’s purchase of Sun, and thereby of MySQL. And in particular, there’s been a lot of talk about MySQL founder Monty Widenius’s response. I call all of this the . . .

Monty My-Thon

On the 28th of December, Monty framed the issue thus: Help keep the Internet free.

Singer Wang of Pythian, in reply, offers his perspective …

Nicklas Westerlund has published the 173rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;.

Log Buffer will be off next week for the holidays, and back early in 2010 to begin another year of presenting the best of database blogs. Please get in touch with the Log Buffer coordinator if you’d like to publish an edition of your own.

Happy Holidays to everyone! Here is Log Buffer #173.

Time keeps on moving and we’re now only one week from Christmas, when people spend time with their families and loved ones. But, that is in a week, today it is time for a new edition of Log Buffer, where we catch up on database blogs from across the world, starting with SQL Server.

SQL Server
Over at Less Than Dot Ted Krueger brings up the question of the good, the bad and the ugly of database design where he says “In my career I have seen the ugly and then the really ugly but I found on this particular implementation it could get even uglier.”

Over at Carpe Datum the question is …

One week and a whole lot of snow later, it is time for the 173rd edition of Log Buffer, the weekly review of database blogs. MySQL goes first this week.

MySQL

On the MySQL Performance Blog, Peter Zaitsev and his readers discuss the question, how many partitions can you have? In Peter’s opinion, ” . . . be careful with number of partitions you use. Creating unused partitions for future use may cost you.”

Also, Peter’s colleague Aleksandr Kuzminsky announces the release of xtrabackup-1.0, an “open source online …

Hello, and welcome to the 171st edition of Log Buffer, the weekly review of database blogs. Let’s get it going this week with . . . 

Oracle

Uwe Hesse, the Oracle Instructor look at result cache, another brilliant 11g new feature. He says, “There are many amazing New Features in the 11g version, one of them is the possibility to cache the result sets of statements, that access large tables but return relatively few rows. Think of it like automagically created materialized views inside the SGA.” Commenters contribute some thoughts on problems with result cache and latch contention.

Christian Antognini is, as …

This is the 170th edition of Log Buffer, the weekly review of database blogs. Welcome. Let’s kick off this week with a double-helping of . . . 

SQL Server

There are lots of good technical posts this week. The SSIS Junkie has some observations and a straw poll on sort transform arbitration. He writes, “This post was prompted by a thread on the MSDN SSIS forum today where the poster was asking how he could replicate the behaviour of SSIS’s Sort transform using T-SQL, specifically he wanted to know how the Sort transform chooses what data to pass through when the ‘Remove Duplicates’ option is checked.”

Another poll, …

The 169th edition of Log Buffer, the weekly review of database blogs, has been published on Pakistan’s First Oracle Blog by Fahd Mirza.

This is the first Log Buffer published outside Pythian in quite a while, and we’d love to have more. Log Buffer has a regular readership, and so makes a great way to present yourself and your blog to the DBA community at large. To get started, just send an email to the Log Buffer coordinator.

And now, here is Log Buffer #169.