Audio

OurSQL Episode 24: The Sun is Shining

Click to play
13:25 minutes (6.15 MB)

Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.

Tell us what you think of Sun buying MySQL by calling the comment line or sending your voice through Odeo!

Links:
Register for the MySQL Users Conference Today!
www.mysqlconf.com

A special thank you to our sponsor, The Pythian Group, www.pythian.com.

Feedback:

Email podcast@technocation.org">podcast@technocation.org

OurSQL Episode 23: Back To School


12:43 minutes (5.82 MB)

Current MySQL Webinars:
http://mysql.com/news-and-events/web-seminars/

Archived MySQL Webinars:
http://mysql.com/news-and-events/on-demand-webinars/

MySQL University:
http://forge.mysql.com/wiki/MySQL_University
Classes for October 2007:
Architecture of NBD
Following a Query Back and Forth in the Server
How to Create a Test Case

Previous University Classes:
http://forge.mysql.com/wiki/MySQL_University#Previous_Sessions

Skoll -- Community-Based Testing Framework
Demo video:
http://technocation.org/node/111

Download the testing client for MySQL:
http://www.cs.umd.edu/projects/skoll/contribute/

OurSQL Episode 22: Things To Avoid With MySQL Querie


16:48 minutes (7.69 MB)

Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY

Feedback:

Email podcast@technocation.org">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://www.technocation.org/forum

OurSQL Episode 21: The Rise of the MySQL DBA


15:34 minutes (7.13 MB)

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 NY
http://www.mysqlcamp.org

http://www.poly.edu

Feature:
The Pythian Group’s Paul Vallee

OurSQL Episode 20: The Pythian Group


27:48 minutes (12.73 MB)

In this less technical episode we interview Paul Vallee, where he explains in depth about the Pythian Group.

Special thanks to folks who have linked to the podcast:
WebDevRadio
http://www.webdevradio.com

Episode 34, July 9th, in which Michael mentions OurSQL and hopes I haven’t “gone dark”. Nope! http://www.webdevradio.com/index.php?id=50

Kristina Hadges, a web designer, linked to the podcast
http://www.nineofnine.com/resources

Feature:

The Pythian Group
http://www.pythian.com

Feedback:
Direct play this episode at:
http://tinyurl.com/3bt3xo

Feedback:

Email podcast@technocation.org">podcast@technocation.org

OurSQL Episode 19: MySQL Proxy


26:35 minutes (12.17 MB)

Feedback:
http://odeo.com/sendmeamessage/Sheeri

Call the comment line at +1 617-674-2369.
E-mail podcast@technocation.org">podcast@technocation.org

News:
MySQL Focuses on Japan
http://www.mysql.com/news-and-events/news/article_1368.html

MySQL Associate Certification Now Available
http://www.mysql.com/certification/

Learning resource:
Pythian Group’s Carnival of the Vanities for the DBA community, published weekly on Fridays.
http://www.pythian.com/blogs/category/log-buffer/

Feature:
MySQL Proxy
Giuseppe Maxia’s Blog:
http://datacharmer.blogspot.com

Getting Started with MySQL Proxy article plus tutorials:

OurSQL Episode 18: De-myth-tifying Indexes


21:55 minutes (10.04 MB)

Feedback:

Email podcast@technocation.org">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://tinyurl.com/sc6qw

Episode 18: De-Myth-tifying Indexes

Where I have been:
Wedding video (short) and photos:
http://www.sheeri.com/wedding

Honeymoon (and wedding) photos:
http://www.sheeri.com/photos

News:
FREE training for Oracle DBAs who want to learn MySQL
http://www.planetmysql.org/robin/?p=51
http://www.mysql.com/oracle/

mysqlnd (PHP native driver) needs testers and benchmarkers:

OurSQL Episode 17: Hashing it out


12:40 minutes (5.8 MB)

May 30th, 2007
In this episode we tackle what a hash looks like in terms of a data structure, in preparation for next episode’s discussion on the difference between hashes and btree indexes, and what kind of indexes are good for what kind of optimizations.

Show Notes:
Direct play this episode at:
http://tinyurl.com/33wuff

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

News:
MySQL Connector/NET 5.1.1 released:
http://tinyurl.com/23a9ax

Download the new Connector/NET version:
http://dev.mysql.com/downloads/connector/net/5.1.html

OurSQL Episode 16: The Art of Innovation, Guy Kawasaki

Click to play
49:45 minutes (22.78 MB)

I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.

Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.

The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!

Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/

Direct play this episode at:
http://tinyurl.com/2h2d7j

Download all podcasts at:
http://technocation.org/podcasts/oursql/

OurSQL Episode 15: Eben Moglen's Keynote at the 2007 MySQL Conference

Click to play
35:24 minutes (16.21 MB)

"Freedom Businesses Protect Privacy"
Eben Moglen, director of the Software Freedom Law Center, discusses why Free Beer isn't so good if your data are getting drunk! The keynote looks at how "Free as in Freedom" businesses help prevent the ultimate privacy catastrophe.
 
This speech is not to be missed! 
 
 
 
Direct play this episode at:
http://www.technocation.org/content/eben-moglen-keynote-2007-mysql-conference
 
Download all podcasts at:http://technocation.org/podcasts/oursql/