Musings on topics including product management, tech, art.
Since I know a lot of MySQLers use Perl, I wanted to pass this along. Today was the first I’d heard of this survey, so I’m thinking that there are a lot of other folks who use Perl occasionally as I do (or even regularly) that are in the dark. Apparently it began in late July, and announced at OSCON 2007, so I apologize if you’ve heard about it over and over.
Take the survey now, as you only have until September 30th to do so!
Since I know a lot of MySQLers use Perl, I wanted to pass this along. Today was the first I’d heard of this survey, so I’m thinking that there are a lot of other folks who use Perl occasionally as I do (or even regularly) that are in the dark. Apparently it began in late July, and announced at OSCON 2007, so I apologize if you’ve heard about it over and over.
Take the survey now, as you only have until September 30th to do so!
I know I’ve been away from the MySQL community for a bit….my hand injury is healing nicely, and I was able to concentrate time on things that required less typing and more mouse clicking. One such thing was the site overhaul of http://www.technocation.org to be easier to use on my side for things like embedding video and mp3 files. More user friendly for you, with regards to article names. Please feel free to vote on whether you like the new site (poll is at the top of the home page, or direct link at http://technocation.org/content/do-you-new-technocation-site%3F). You can add a comment to the poll, too, if you want to voice your opinion.
I do hope to get back into podcasting, and have one for next week. Coming very soon: Videos from MySQL Camp!
I know I’ve been away from the MySQL community for a bit….my hand injury is healing nicely, and I was able to concentrate time on things that required less typing and more mouse clicking. One such thing was the site overhaul of http://www.technocation.org to be easier to use on my side for things like embedding video and mp3 files. More user friendly for you, with regards to article names. Please feel free to vote on whether you like the new site (poll is at the top of the home page, or direct link at http://technocation.org/content/do-you-new-technocation-site%3F). You can add a comment to the poll, too, if you want to voice your opinion.
I do hope to get back into podcasting, and have one for next week. Coming very soon: Videos from MySQL Camp!
Administrative note:
I had a bit of a mishap involving my hand and a glass door pane. The OurSQL podcast will be on hiatus for a few weeks as I recover. I injured my left hand, and I’m a lefty, so I’m typing one-handed these days. I apologize for the break in the show schedule, and hope you’ll be able to hear new podcasts about MySQL very soon!
Administrative note:
I had a bit of a mishap involving my hand and a glass door pane. The OurSQL podcast will be on hiatus for a few weeks as I recover. I injured my left hand, and I’m a lefty, so I’m typing one-handed these days. I apologize for the break in the show schedule, and hope you’ll be able to hear new podcasts about MySQL very soon!
MySQLCamp is a free event available to the public, though geared towards the MySQL Community. There is no fee for any participant, and workshops are presented by participants and chosen by the community.
Last year, Google was kind enough to sponsor all of the logistics, from food to meeting space. This year, Polytechnic University is providing the location — and we're opening up sponsorship for the rest!
Technocation, Inc. — a US not-for-profit providing educational resources for IT professionals — is sponsoring a donor campaign for MySQLCamp II, to take place from August 23-24, 2007 at Polytechnic University in Brooklyn, NY, USA.
By sponsoring MySQL Camp, you will not only help out the community and get a tax deduction, but your name and company's name will be mentioned throughout MySQL Camp, on the MySQL Camp website, and you will be allowed to have a banner ad on www.technocation.org. You will be contacted at your e-mail address to discuss banner details.
Technocation, Inc. is a not-for-profit organization. Your contributions are tax-deductible to the fullest extent of the law. Proof of donation will be mailed. Money may be donated through PayPal by sending payment to donate@technocation.org, or by using the links below.
To send a check or money order by mail:
MySQLCamp II Campaign
c/o Technocation, Inc.
PO Box 380221
Cambridge, MA 02238
United States
Technocation's EIN/Tax ID is 20-5445375
MySQLCamp is a free event available to the public, though geared towards the MySQL Community. There is no fee for any participant, and workshops are presented by participants and chosen by the community.
Last year, Google was kind enough to sponsor all of the logistics, from food to meeting space. This year, Polytechnic University is providing the location — and we're opening up sponsorship for the rest!
Technocation, Inc. — a US not-for-profit providing educational resources for IT professionals — is sponsoring a donor campaign for MySQLCamp II, to take place from August 23-24, 2007 at Polytechnic University in Brooklyn, NY, USA.
By sponsoring MySQL Camp, you will not only help out the community and get a tax deduction, but your name and company's name will be mentioned throughout MySQL Camp, on the MySQL Camp website, and you will be allowed to have a banner ad on www.technocation.org. You will be contacted at your e-mail address to discuss banner details.
Technocation, Inc. is a not-for-profit organization. Your contributions are tax-deductible to the fullest extent of the law. Proof of donation will be mailed. Money may be donated through PayPal by sending payment to donate@technocation.org, or by using the links below.
To send a check or money order by mail:
MySQLCamp II Campaign
c/o Technocation, Inc.
PO Box 380221
Cambridge, MA 02238
United States
Technocation's EIN/Tax ID is 20-5445375
Direct play this episode at:
http://technocation.org/content/oursql-episode-21%3A-rise-mysql-dba-1
Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.
News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393
Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123
Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org
Learning Resource:
MySQL Camp II, August 23-24 2007, Brooklyn NYhttp://www.mysqlcamp.org
Feature:
The Pythian Group’s Paul Vallee
http://www.pythian.com
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
or use the Technocation forums:
http://technocation.org/forum
Direct play this episode at:
http://technocation.org/content/oursql-episode-21%3A-rise-mysql-dba-1
Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.
News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393
Current clarification of Enterprise/Community split
http://www.planetmysql.org/kaj/?p=123
Dorsal Source, a community-focused website whose goal is to provide builds of MySQL and related products.
http://www.dorsalsource.org
Learning Resource:
MySQL Camp II, August 23-24 2007, Brooklyn NYhttp://www.mysqlcamp.org
Feature:
The Pythian Group’s Paul Vallee
http://www.pythian.com
Feedback:
Email podcast@technocation.org
call the comment line at +1 617-674-2369
use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri
or use the Technocation forums:
http://technocation.org/forum
The short: 2007 Sysadmin of the Year Nominations being accepted — http://www.sysadminoftheyear.com. Canada and US candidates only (due to prizes and regulations. 🙁 )
Last year, I found out too late about the Sysadmin of the Year Award (see my lament at http://sheeri.net/archives/157). Mark Cohen, this year’s “poster boy” for 2007 Sysadmin of the Year, contacted me to let me know that the 2007 Sysadmin of the Year contest is on. It started on Sysadmin Day, always the last Friday in July.
I asked if DBA’s count as sysadmins, and here’s what Mark had to say:
In our book, DBAs qualify.
I’ve worked with some totally amazing DBAs that not only do their job, but ALSO work as a sysadmin when asked..
Great bunch of people generally.
The press release to Forbes Magazine http://tinyurl.com/2cufvc confirms this:
During the three-month contest, anyone can nominate their system administrator, network manager, database administrator, or other IT professional simply by submitting an online nomination describing why their IT person is a SysAdmin Rockstar, going beyond the call-of-duty on a daily basis.
My hat’s already in the running (from my co-workers, so use skritzer at online-buddies dot com if you’re going to nominate me), so if you think my contributions to the general community through my podcast, my blog, as mentor in the Google Summer of Code for 2 students, or through actually working with me are useful, go ahead and nominate me.
And be sure to nominate other folks as well — the first 2500 folks to be nominated will receive a T-shirt. But I’d really love to go to LISA again, and I’ve already been to the MySQL Conference this year so my training budget is used!
The short: 2007 Sysadmin of the Year Nominations being accepted — http://www.sysadminoftheyear.com. Canada and US candidates only (due to prizes and regulations. 🙁 )
Last year, I found out too late about the Sysadmin of the Year Award (see my lament at http://sheeri.net/archives/157). Mark Cohen, this year’s “poster boy” for 2007 Sysadmin of the Year, contacted me to let me know that the 2007 Sysadmin of the Year contest is on. It started on Sysadmin Day, always the last Friday in July.
I asked if DBA’s count as sysadmins, and here’s what Mark had to say:
In our book, DBAs qualify.
I’ve worked with some totally amazing DBAs that not only do their job, but ALSO work as a sysadmin when asked..
Great bunch of people generally.
The press release to Forbes Magazine http://tinyurl.com/2cufvc confirms this:
During the three-month contest, anyone can nominate their system administrator, network manager, database administrator, or other IT professional simply by submitting an online nomination describing why their IT person is a SysAdmin Rockstar, going beyond the call-of-duty on a daily basis.
My hat’s already in the running (from my co-workers, so use skritzer at online-buddies dot com if you’re going to nominate me), so if you think my contributions to the general community through my podcast, my blog, as mentor in the Google Summer of Code for 2 students, or through actually working with me are useful, go ahead and nominate me.
And be sure to nominate other folks as well — the first 2500 folks to be nominated will receive a T-shirt. But I’d really love to go to LISA again, and I’ve already been to the MySQL Conference this year so my training budget is used!
Sadly, it’s not my bug, it’s a bug in the MySQL Documentation.
http://bugs.mysql.com/bug.php?id=29915
I’m actually quite surprised nobody has run into this before, and in fact many sources quote this stating that %I and %h are the same thing.
I can’t be the only person in the world that’s ever needed hours with stripped leading zeros before. The irony is that before the submitted bug I was 5 points away from being a Basic Quality Contributor, and it would be very funny to me if this is the bug that pushed me over to qualify for a free Basic license….particularly since my company JUST bought a few licenses a month ago.
Sadly, it’s not my bug, it’s a bug in the MySQL Documentation.
http://bugs.mysql.com/bug.php?id=29915
I’m actually quite surprised nobody has run into this before, and in fact many sources quote this stating that %I and %h are the same thing.
I can’t be the only person in the world that’s ever needed hours with stripped leading zeros before. The irony is that before the submitted bug I was 5 points away from being a Basic Quality Contributor, and it would be very funny to me if this is the bug that pushed me over to qualify for a free Basic license….particularly since my company JUST bought a few licenses a month ago.
Today I upgraded the blog software at sheeri.com (and sheeri.net and sheeri.org). Please let me know if you find something that doesn’t work as expected — awfief@gmail.com.
At the MySQL Users Conference, my good friend Mark Atwood (creator of the free Amazon S3 Storage Engine) mentioned that any site with a login should have OpenID as an option.
Mark, I upgraded for you! I was using Wordpress 1.5.2, now I’m at the “latest” version. Anyway, this is just to let folks know that if you so choose, you may now use OpenId if you wish to login and make comments.
Of course, I do not require login (and have a great spam filter) so that’s just another choice you have.
Today I upgraded the blog software at sheeri.com (and sheeri.net and sheeri.org). Please let me know if you find something that doesn’t work as expected — awfief@gmail.com.
At the MySQL Users Conference, my good friend Mark Atwood (creator of the free Amazon S3 Storage Engine) mentioned that any site with a login should have OpenID as an option.
Mark, I upgraded for you! I was using WordPress 1.5.2, now I’m at the “latest” version. Anyway, this is just to let folks know that if you so choose, you may now use OpenId if you wish to login and make comments.
Of course, I do not require login (and have a great spam filter) so that’s just another choice you have.
In the spirit of humor, here are 2 ways I know I am a MySQL geek. These are actually things I do….
You Know You’re a MySQL Geek When….
1. You cannot type the word “myself” without typing “mysql” first, deleting 2 characters and finishing out the word.
2. You type “show processlist” at the commandline when you really mean “ps -ef”
Anyone have anything they can add to the list?
In the spirit of humor, here are 2 ways I know I am a MySQL geek. These are actually things I do….
You Know You’re a MySQL Geek When….
1. You cannot type the word “myself” without typing “mysql” first, deleting 2 characters and finishing out the word.
2. You type “show processlist” at the commandline when you really mean “ps -ef”
Anyone have anything they can add to the list?
For those that follow Daylight Savings Time in the US and Canada, watch out this weekend, because we “spring forward”!
The biggest caveat I have is: Do not arrive 1 hour late to work on Sunday or Monday.
As for MySQL, to test if you are fine, run:
SELECT @@global.time_zone;
If you get back “SYSTEM”, then MySQL is looking to the OS for timezone data, which is the default.
The real sanity check:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), UNIX_TIMESTAMP('2007-03-11 03:00:00');
This should return the same value, even though you are feeding it different times, because this is when the 1 hr change occurs. If not, and you’ve played with timezone data, remember that timezone data is only loaded when MySQL starts, so if you haven’t restarted MySQL since you patched your OS, you need to do that.
This is mostly stolen from a MySQL list post I found here:
For those that follow Daylight Savings Time in the US and Canada, watch out this weekend, because we “spring forward”!
The biggest caveat I have is: Do not arrive 1 hour late to work on Sunday or Monday.
As for MySQL, to test if you are fine, run:
SELECT @@global.time_zone;
If you get back “SYSTEM”, then MySQL is looking to the OS for timezone data, which is the default.
The real sanity check:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), UNIX_TIMESTAMP('2007-03-11 03:00:00');
This should return the same value, even though you are feeding it different times, because this is when the 1 hr change occurs. If not, and you’ve played with timezone data, remember that timezone data is only loaded when MySQL starts, so if you haven’t restarted MySQL since you patched your OS, you need to do that.
This is mostly stolen from a MySQL list post I found here: