OurSQL Episode 120: Trigger Happy

Posted on December 17, 2012 by podcast

This week we discuss triggers in MySQL. Ear Candy is SQL in the Shell, and At the Movies is Project Triage and Recovery, by Keith Casey of Twilio, at the 2012 CodeConnexx conference.

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!

read more

Posted in Learning, Podcasts | Comments Off

OurSQL Episode 119: I Do DECLARE

Posted on December 11, 2012 by podcast

This week we talk more about stored routines, including the several different DECLARE statements. Ear Candy is about ssh hacks to make logging into multiple servers easy, and At the Movies is "Everything You Ever Wanted to Know About Deployment But Were Afraid to Ask".

Events
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.

read more

Posted in Learning, Podcasts, Routines | Comments Off

OurSQL Episode 118: Not Our Usual Routine

Posted on November 30, 2012 by podcast

This week we go over stored routine basics. Ear Candy is linux.die.net, online man pages for Linux, and At the Movies is key things that DBA need to know.

News
Open Source DBA's Holiday Gifts for MySQL DBAs - check out the CafePress link, many are positively funny.

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

read more

Posted in Podcasts, Routines | Comments Off

OurSQL Episode 117: Foreign Policy

Posted on November 23, 2012 by podcast

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 perror, and in At the Movies, we share 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.

read more

Posted in Learning, Podcasts | Comments Off

OurSQL Episode 116: Do You Make the Grade (part 5)?

Posted on November 16, 2012 by podcast

This week, we finish our series on the Operations Report Card as it applies to database administrators. In Ear Candy, we discuss one problem with setting table_open_cache higher than needed., and At the Movies is Tools and Techniques of Index Design by Bill Karwin.

News
MariaDB 10.0.0 alpha is out, including the SHOW EXPLAIN FOR thread_id feature for running an EXPLAIN on a running query, and multi-source replication.

read more

Posted in General, Podcasts | Comments Off

OurSQL Episode 115: Do You Make the Grade (part 4)?

Posted on November 14, 2012 by podcast

This week, we continue our series going through the Operations Report Card as it applies to database administrators. This week in Ear Candy, we talk about a hidden client value for max_allowed_packet (separate from the session variable). In At the Movies, we present Karen Tegan Padir of Enterprise DB presenting The More Things Change, the More They Stay the Same.

Events
Oracle's "Scale with MySQL" seminars:
Madrid, Tuesday 27 November

read more

Posted in Business, General, Podcasts | Comments Off

OurSQL Episode 114: Do You Make the Grade (part 3)?

Posted on November 5, 2012 by podcast

This week we continue part 3 of the Operations Report Card and how it relates to database administration. This week we talk about the section on "Operational Practices", and it covers how operations are run. In Ear Candy we present different tools for finding a machine's external IP address, and in At the Movies we present a video about MySQL Security from when Sheeri was touring Latin America in July.

Feedback
Webyog's blog noted that the OurSQL blog/podcast was among the Top MySQL Blogs You Should Be Reading. Thanks for your support!

read more

Posted in Business, General, Podcasts | Comments Off

OurSQL Episode 113: A JS API with JDD

Posted on October 29, 2012 by podcast

While we were at MySQL Connect last month, we interviewed long-time MySQL developer JD Duncan about integrating NoSQL and JavaScript with MySQL. His team developed the Node.js API for MySQL. This week, we present the interview we did. In Ear Candy, we discuss what makes a senior DBA, and in At the Movies we present a ScaleBase webinar.

Events
Oracle's "Scale with MySQL" seminars:
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

read more

Posted in Performance, Podcasts, Query Optimization | Comments Off

OurSQL Episode 112: Do You Make the Grade (part 2)?

Posted on October 23, 2012 by podcast

This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

read more

Posted in Business, General, Podcasts | Comments Off

OurSQL Episode 111: Do You Make the Grade (part 1)?

Posted on October 14, 2012 by podcast

This is part one of a series where we will explore the Operations Report Card and explain how it applies to DBAs. Listen and grade your own organization, this is a great opportunity to get some new ideas on how to organize your department and make your job more efficient and streamlined.

News
Alaska Airlines system crash

Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October

read more

Posted in Business, General, Podcasts | Comments Off