OurSQL Episode 117: Foreign Policy

This week, we take a look at foreign keys - what they are, what you can do with them, and how to troubleshoot the dreaded errno 150. In Ear Candy, we talk about Secrets of Success in the Style of GLEE from CodeConnexx this month, where Jennifer Marsman Microsoft's Developer and Platform Evangelism team talks about how to be successful in a tech job, by using popular songs as illustrating points.

News
2012 CNN/Money's 100 Best Jobs in America
DBA is the 5th best job

Oracle is having free Tech Tours for MySQL in Dublin, San Diego, El Segundo, CA, Miami

Call for papers for SCALE13, open until December 10th, 2012.

Percona Live, London Dec 3 - Tues Dec 4. Millenium Gloucester Hotel.

FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping out because of Open Database Camp. Registration is free, register today!

Percona Live: MySQL Conference and Expo 2013 is being held at the Santa Clara Convention Center Monday April 22nd - Thursday April 25th. The tutorial schedule is up. Register today, early bird pricing goes until Friday, December 28th.

Training
MySQL Marinate, a FREE basic MySQL training course led by Sheeri.

SkySQL Trainings

Oracle's MySQL Trainings

Percona Trainings

Foreign Keys
Sakila sample database

InnoDB Foreign Key constraints

ENUM data type

Mike Hillyer's seminal article about hierarchical data in MySQL, including nested sets
Another good article about nested sets in MySQL

Explanation of ON DELETE and ON UPDATE in the MySQL manual.

REFERENTIAL_CONSTRAINTS MySQL INFORMATION_SCHEMA system view containing information about foreign keys.

MySQL Administrator's Bible, which has a list of how to troubleshoot the dreaded errno 150.

Ear Candy
MySQL error handling MySQL manual pages, and a documentation bug asking for the MySQL manual to contain perror codes and messages.

MariaDB 10.0 has expanded the information in the error messages, which now include the number and the corresponding descriptive text for all the operating system error codes. One less step to diagnose an issue, because you no longer need to use perror in MariaDB 10.

This week in at the movies we present "Secrets of Success in the style of Glee". In this talk, Jennifer Marsman of Microsoft's Developer and Platform Evangelism team talks about how to be successful in a tech job, by using popular songs as illustrating points. This talk was video'd at this month's CodeConnexx.

Where you can see us
Gerry will be at the December Seattle MySQL Meetup on Dec 3rd, topic and venue haven't been decided yet.

Sheeri will be at the December Boston MySQL meetup group on Monday, December 10th from 7-9 pm. The topic is "Elastic Database Scalability: Making your MySQL data tier flexible and adaptable to system demand with ParElastic" by Amrith Kumar, CTO of ParElastic.

MySQL Marinate starts January 1st, 2013. It is a virtual self-study course learning MySQL which both Gerry and Sheeri will be helping lead.

Sheeri will be at the January Boston MySQL meetup group on Monday, December 10th from 7-9 pm. The topic is NuoDB, an emergent database that is 100% SQL, 100% ACID, and scales out elastically on decentralized resources in the cloud, on-premises, or both.

Sheeri will be speaking at the miniconfs at Linux Conf Australia, Monday January 28th through Saturday February 2nd, 2013 about "Getting Started With a Podcast", "mysql security" and "The Art of Cat Herding: How to Manage Geeks."

Sheeri will be speaking at Rocky Mountain Oracle User Group Training Days in denver, colorodo from Monday Feb 11 - Thursday February 14th on "Backing up MySQL" and "Are You Getting the Most Out of Your Indexes?"

Sheeri will be speaking at Confoo in Montreal, Canada on Monday February 25 - Friday March 1, 2013, giving talks in English about "Are You Getting the Most Out of Your Indexes?" and "Different (MySQL) Forks for Different Folks".

Gerry will present a tutorial at Percona Live:MySQL Conference and Expo on Using TokuDB: A Guided Walk Through TokuDB Implementation. Although it's a 'branded' tutorial, many of the concepts apply to custom MySQL / MariaDB installations as well. Percona Live: MySQL Conference and Expo 2013 will be held April 22-25, 2013 in Santa Clara, California.


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32