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