Log Buffer #5: A Carnival of the Vanities for DBAs
Aug 11, 2006 / By David Edwards
Welcome to the fifth edition of Log Buffer. There’s lots to cover this week, so here goes.
By the way, does anyone know what “ACE” means? I searched for a while, but found no satisfactory answer. It looks like an acronym, however I theorize that Oracle might simply have meant “Ace” (as in “expert” or “hotshot”) but capitulated to creeping TLA-ism.
If you’re curious about what DBAs are getting paid (ACEs or not), and what affects their pay, you might participate in The Unofficial Oracle Developer/DBA Salary Survey on Eddie Awad’s Blog. It’s un-scientific (i.e. not accurate within 4%, 19 times out of 20), but should yield some interesting results nonetheless — depending on how much response Eddie gets.
It’s important that qualified, dedicated DBAs are taught and hired because they are the front-line workers in our world of ubiquitous data. How is all that data secured? In Confessions of a database geek, Beth Breidenbach has some thoughts on this, and an open question to all of us about practices. It seems especially relevant in the wake of AOL’s little mistake.
We now return to Monster Chiller Horror Theatre’s presentation of “3D House of SQL Injectors!” Joey De Villa of the Tucows Farm looks the monster in the face, covering two articles that thoroughly dissect what SQL injections attacks are in practice. Scary stuff!
It’s also frightening when your OS platform won’t support your DBMS, particularly when the OS and the DBMS are both products of the same organization. Gustavo Larriera of SQL Junkies links to Microsoft’s announcement that SQL Server 2000 will not be supported on their Vista OS. Bill Vaughn offers a shrewd musing on the situation.
Turning to things that are improved, Francisco Figueiredo Jr posts that release candidate 3 of Npgsql, a .NET data provider for PostgreSQL will soon be available.
Raven Zachary of 451 CAOS Theory posts some business news about PostgreSQL. In short, EnterpriseDB signed a deal with Sun Microsystems to provide PostgreSQL support to Sun’s customers. This could be a big step forward for Postgres’s enterprise adoption.
If you want to learn how to contribute code to MySQL with the MySQL Contributor License Agreement, Kaj has that too. However, Bogomil Shopov of the Open Ideas Company suggests that the new license will hinder, rather than help, MySQL. Several people including Ärno respond, and a worthwhile discussion follows.
Strong Open Source projects like MySQL have strong communities. Bogomil also posts an item about the first meeting of the MySQL Users Group in Sofia, Bulgaria, slides and photos included.
And Jay Pipes announces the birth of a wiki for the upcoming MySQL Camp.
Turning to technical posts — on Tuesday, Pythian’s Shervin Sheidaei wrote the first of a series of articles on a new STATSPACK methodology, and Herod T, Yet Another Oracle DBA, offers some info on finding, installing, and using STATSPACK.
Likewise, maybe scripting in one of the “P-languages” is too in-crowd for you. Maybe you like dark horses… or dark birds. mythago introduces Raven: A Scripting Language for MySQL.
Adam Machanic of data manipulation for fun and profit shows his crafty approach to side-stepping the performance penalty of scalar user-defined functions in SQL Server 2000.
If you’re a DB2 administrator and like to know all the little details (a good trait in a DBA), Craig Mullins’s article Where exactly is a DB2 plan stored? will make you happy.
This week, Log Buffer came back from abroad, ate me out of house and home, and left again without so much as a “goodbye”. It’s going off to Mike Kruckenberg’s for a week, and after that, who knows — your place?