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 …

We've got another round of free Windows-centric webinars coming up tomorrow:

Migrating from SQL Server to MySQL (North America)...covering the fundamentals of why and how to migrate, plus an apples to apples feature comparison. Register here

Windows Server 2008 Failover Clustering with MySQL (EMEA)...Mike Frank will run through step by step how to set up a development environment with minimal cost/effort that implements Windows Clustering and MySQL. Register here

Finally, check out LiveTime's presentation next week where they will demonstrate the methodology and toolset they use to perform free SQL Server to MySQL migrations for their customers. Register …

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, …

That’s right — get your free 10-day trial! All the information I know is here:

http://bit.ly/37E9ld

But the basics are: No access to Rough Cuts or Downloads, for new subscribers only. It’s one of those “sign up and if you do not cancel after 10 days, we bill you” — and at $42.99 a month, that’s not a mistake you want to make. Must sign up by Nov. 24th.

To sign up now: https://ssl.safaribooksonline.com/tryitfree

I was asked to send this information along, so I am…Now’s your chance to skim High Performance MySQL, among other high quality books!

This is the 168th edition of Log Buffer, the weekly review of database blogs. Let’s give the wheel a spin and see who comes first . . . 

MySQL

Brian “Krow” Aker has something to say about Drizzle, InfiniDB, and column-oriented storage: “I have been asked a number of times ‘do you think there is a need for a column oriented database in the open source world?’ The answer has been yes!  . . .  I was very happy to see Calpont do their release of Infinidb last week.”

Vadim of the MySQL Performance Blog said, “As Calpont announced availability of InfiniDB I …