Friday, July 13, 2007

Log Buffer 53 - Friday the 13th Carnival of the Vanities...DBA Style!

Before the fun begins...I want to express my sincerest THANK YOU to Dave Edwards and the rest of the people at The Pythian Group. They are a great bunch of folks and a class act all the way.

It's Friday the 13th...the traditional day of bad luck.

On the dark side, after discussions of SQL Injection by Tom Kyte and Pete Finnigan. Alex Kornbrust finds we learn our bad habits from some pretty reputable names. Tim DiChiaria has collected some amusingly sad, but true, security bloopers. To steal and mangle a rather famous saying "The most secure database is the one that does not exist." Syed's database is not haunted, but the days of ordered data without an ORDER BY are coming to an end. However, Laurent's database might be! And Alex's surely is! Kevin Closson searches for a missing alert log.

On to some good luck!

Niall Litchfield takes a look backward and forward...Let's bookmark this one to revisit in 10 years (Hey, Dave...I'll volunteer for that Log Buffer.. #578 I think). In the same vein, let's take a look back at an old post that we should look at every month (at least) where Joel Spolsky talks about 7 Steps to Remarkable Customer Service (we're all in Customer Service!). Looking forward, Bob Beauchemin illustrates new Join and Merge functionality in SQLServer 2008. Sheeri Kritzer blogs...audio style about De-myth-tifying Indexes (De-myth-tifying...I'll definitely be stealing that phrase!)

Peter Scott notes that datatype conversions can cause performance degradation. Jay Pipes pipes in with answers to common MySQL tuning questions (sorry, Jay, but I just could not resist the pun). On a very low level note, Howard Rogers illustrates performance improvements from aligning disks in Windows. Sergey Petrunia traces storage engine activity in MySQL to identify performance issues.

In the PostgreSQL world, PGDay (which was a 2 day event...must be that pesky exchange rate thing) was this past weekend. Josh Berkus, Stefan Kaltenbrunner, On the heels of PGDay, the first PostgreSQL benchmark was announced.

MySQL v. SqlServer...a comparison. On the heels of comparison, Kristian Koehntopp writes about Replication Now and Then. Sheeri Kritzer lists the community's Top 5 wishes and Peter Zaitsev asks "What's Next?" Opensource goes right to the source with 3 very interesting interviews.

Of course, the really, really big news of the week, Oracle 11g! Coskan has some of the highlights, Marko Gralike has the XMLDB Top 10, Kevin Closson ponders Fast or Secure?, Jeremy Schneider examines Data Compression in 11g, Doug Burns (with the rather handsome Randy assisting) looks at Total Recall, Jurgen continues the discussion with PL/SQL 11g CONTINUE feature , Mark Rittman looks at some of the new BI products. Of course, the real question from Tim Hall is "When will 11g actually be released?"

As the final bit of bad luck, I'll remind everyone of the Power of the Technical Myth, an Interesting Marketing scheme, the results of nagging a certain newbie to update her blog

Sliante! Prost! Salut! Skål! Na Zdrowie! L'Chaim! Cheers!

Daniel Fink

0 comments:

Followers

Blog Archive

About Me