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

MySQL

Sun’s Trent Lloyd cautions Watch out for hostname changes when using replication!, for there is a gotcha there.

Justin Swanhart was also in the cautioning business this week, saying Be careful with BETWEEN clauses, because the MySQL optimizer is not smarter than a fifth grader!. The readers say, that’s SQL.

Anyway, it’s probably unwise to underestimate the intelligence of a child. …

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

SQL Server

Simon Sabin has a TSQL Challenge – counting non zero columns. He says, “I’m working on a project where I need to cycle a flag amongst a set of columns. To achieve this I am storing a position value in each column which allows me to cycle them . . .  So the challenge is to find out the how many non zero columns there are, the twist is to use as little code as possible.”

On a cue from Simon, Aaron Bertrand shares …

Welcome to the 157th edition of Log Buffer, the weekly, cross-platform review of database blogs.

SQL Server

We start with Michelle Ufford, the SQL Fool, who gives us the poor (wo)man’s graph, a fast and ingenious way to create handsome text-based graphs.

What is the importance of running regular consistency checks? Paul S. Randal returns with some survey results and analysis. He writes, “The results are actually surprising – I didn’t expect so many people to be running consistency …

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

Oracle

Jonathan Lewis gets things rolling with his post, Empiricism. Jonathan asks his readers if an empirical approach to tuning would be appropriate for a particular wait scenario.

Doug Burns was also looking into wait times, beginning, “Sometimes you think a subject is understood so well, including by yourself, that you tend to overlook it until asked to explain it. That which seems intuitive to us …

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

SQL Server

On the SQL Server blogs this week, CSS SQL Server Engineers demonstrated that using DateDiff can query performance problems in SQL 2005 and 2008.

The kind of problems, perhaps, that Linchi Shea examines in his post on linked server security configuration and how it can hurt you. Linchi writes, …

Welcome to the 154th edition of Log Buffer, the weekly review of database blogs. Let’s dive right in, shall we?

Oracle

On Radio Free Tooting, Andrew Clarke says, “No SQL, so what?” taking as his keynote something Nuno Souto said: “ . . . Google, Facebook, Myspace, Ning etcetc, and what they do as far as IT goes, are absolutely and totally irrelevant to the VAST majority of enterprise business.”

Aman Sharma gives an overview of Library Cache on Arista’s Oracle Blog.

On The Dutch Prutser’s Blog, …

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

Let’s start by revisiting a perennial issue with Craig Mullins addresses with the question, Are DBAs Obsolete? “Before we go any further, let me briefly answer the question posed in the title of this blog entry: ‘No Way!’,” writes Craig. “Every time I hear this it makes me shake my head sadly as I regard just how gullible IT publications can be.” He argues that an Internet-paced attitude regarding the work of the DBA may be the first culprit in the devaluation of the DBA’s work.

Oracle

Dion Cho, the Oracle Performance Storyteller, …

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

PostgreSQL

Courtesy the United States PostgreSQL Association, the big news: PostgreSQL 8.4 Released!.

Josh Berkus writes, “Now that PostgreSQL 8.4 is out, I thought I’d write a little about my favorite 8.4 feature. As Mr. Performance Whack-a-Mole, what makes me happy about 8.4 is the ability to whack moles faster … which is why I’m very fond of pg_stat_statements.”

On ad’s corner, …

Welcome to the 151st edition of Log Buffer, the weekly review of database blogs. We’re going to take a fast tour through the best blogs from the week gone by, beginning this time, with Oracle.

Jonathan Lewis writes, “It occurred to me recently that I might be making casual use of terms that weren’t necessarily very well known to the less experienced user. So I’ve decided to build a glossary of terms – and I’ll try to add to it from time to time whenever I have a few minutes.”

Jonathan might want to add “Method R” to the glossary. Cary Millsap was making it understood, …

This is the 150th edition of Log Buffer, the weekly review of database blogs. Someone accidentally left Dave Edwards‘ cage unlocked, and he escaped, thus leaving me with the pleasurable duty of compiling the 150th weekly Log Buffer.

Many people other than Dave are finding release this week. Giuseppe Maxia explains some details of MySQL’s New Release Model. Andrew Morgan announces a New MySQL Cluster Maintenance Release. Aleksandr Kuzminsky of the MySQL Performance …