Providing educational resources and monetary grants to IT professionals.

OurSQL Episode 119: I Do DECLARE

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.

OurSQL Episode 118: Not Our Usual Routine

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

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.

Are You Part of OurSQL Events?

OurSQL, the MySQL Database Community Podcast, lists events, conferences and training that are relevant to MySQLers around the world. Gerry and Sheeri get the information for events/conferences/training from Planet MySQL and Oracle, SkySQL and Percona websites. Often, webinars are posted to Planet MySQL a week or 2 before they happen, which is not enough lead time for the podcast. We usually record on Tuesdays and publish on Fridays, with the understanding that not everyone listens to the podcast on Friday. So on the podcast, we talk about events that are at least 1 week from publication date. For example, we are recording today (Tue 20 Nov) for a podcast that will be published Friday (23 Nov). We will talk about events, conferences and training that will happen Sunday, December 2nd or later.

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

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
SHOW EXPLAIN FOR thread_id feature for running an EXPLAIN on a running query, and multi-source replication.

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

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

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

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!

OurSQL Episode 113: A JS API with JDD

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

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

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

Pages


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