Welcome the the 85th edition of Log Buffer, the weekly review of database blogs. Here we go! Oracle We start with the obscure. Eddie Awad has started the Obfuscated SQL Code Contest on his Oracle Community site, thanks to an idea by Chen Shapira. If you’re familiar with this contest’s antecedents, like the [...]

It’s the 84th blog-tacular edition of Log Buffer, the weekly review of database blogs! We begin with some Oracle security news. A tutorial of Oracle’s on defending against SQL injection attacks gets a good review on Pete Finnigan’s Oracle security weblog. Pete writes, “This is a superb tutoral, well written and positioned just right. . . . [...]

Today was a mini-Pythian day at RMOUG. Both Alex and myself gave two presentations each. My first session was on using LDAP with Oracle Applications. It was at 8:30am and there were a few brave souls that fought the snow and icy road conditions to make it. The group was small and I was pleasantly surprised that almost everyone in the room indicated that they were currently using LDAP, although most were NOT using Oracle LDAP offering ( Oracle Internet Directory).

George Trujillo was presenting on MySQL for the Oracle DBA in the same room, so I stayed and learned a few things. Although I must have been really tired as I missed his comments on the Blackhole engine for database replication. George also shared some of his experiences from customer sites visits. All in all, I am glad I stayed.

Riyaj Shamsudeen had an interesting session on De-bunking the Myths about redo-undo-rollback. I enjoyed this presentation style of making an …

http://pgfoundry.org/projects/pllolcode/ Do I really need to say more?

Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so (so that if you have an [...]

In a linkage of biblical proportions, Log Buffer #83 pointed me to Tom Kyte’s reiteration which pointed me to Coding Horror’s rant about source controlling the database schema. Now, for starters, I agree with Tom’s sarcasm and Coding Horror’s rant — the database schema really should be source controlled in the same place as the application [...]

A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. Now, the specifics of how a query optimizer handles queries, how backups, restores and security are done and with MySQL specifically, how different storage engines act are [...]

Welcome to the 83rd edition of Log Buffer, the weekly review of database blogs.

Little things can make big differences. Archimedes (no blogger, but a very smart guy) said, “Give me a lever long enough and a fulcrum on which to place it, and I shall move the world,” and With CLUE as (Select * from Random_Thought ORDER BY Common_Sense DESC) proves him right with a story of leverage: “This story is how changing one character in a 300 line stored procedure removed 90% of the impact of the worst single query on the entire server.”

On Third Abnormal Form, Paul McMillan shows that in SQL Server 2005, …

Welcome to the 82nd edition of Log Buffer, the weekly review of database blogs. Some MySQL news to start. They call the engine Maria. “They” being MySQL AB co-founder Monty Widenius, and Maria being his new storage engine for MySQL. On his new blog, Monty Says, Monty says Maria is, “. . . a crash-safe alternative [...]

A friend asked for this, so I thought it’d be helpful: All tables with no primary key:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, from TABLES AS t LEFT JOIN KEY_COLUMN_USAGE AS c ON (t.TABLE_NAME=c.TABLE_NAME AND c.CONSTRAINT_SCHEMA=t.TABLE_SCHEMA AND constraint_name='PRIMARY') WHERE t.table_schema!="information_schema" AND constraint_name IS NULL;

All tables and their primary keys, if exist:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, c.column_name,c.constraint_name from TABLES AS t LEFT JOIN [...]