Posts Categorized: Technical Blog
On Thursday, January 21, Pythian hosted the Ottawa Valley System Administration Guild (OVSAGE) Ottawa Valley System Administration Guild (OVSAGE). The highlight of the meeting was an interesting presentation on security by the founder of OVSAGE, Scott Murphy. The focus was on the fact that security is a mindset, not a product. Scott’s presentation can be viewed here.
Good morning and welcome to a new Blogrotate. We missed last week’s edition because last week was insanely busy. We take customer service very seriously here at Pythian, so when there is a conflict between client issue and a blog, the client always wins out. ‘Nuff said.
Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .
Unrecoverable data files are those that involve nologging operations since the last successful backup took place. There are several ways to identify them. I’ll take you through them.
Want to contribute to your favorite CPAN module, or maybe create your own, but don’t have the foggiest idea how to do it? Here’s a few notes, tips, tricks and links that might help you get started.
Last month at the Boston MySQL User Group, I went through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. I also explained how to recognize when you want those types of joins, and best practices for the semantics of writing joins and design patterns. Subqueries were explained in this session, and some examples of how to think differently so that you end up writing JOINs instead of subqueries. The slides and video are posted here.
This is the 176th edition of Log Buffer, the weekly review of database blogs.
I’m so much looking forward to the next conference in my schedule — RMOUG Training Days 2010. It would be only my second time I’m presenting at the RMOUG but it was enough to go there once to understand that it’s one of the top rated Oracle User Group conferences in the world. Some of the great speakers are presenting and registration fees are very low compare to other events of comparable quality. If your conference budget is low this year — that’s the conference you don’t want to miss!
In light of the official Oracle acquisition of Sun, I dug out a presentation video I realize I never officially shared with either the MySQL or the Oracle community. It’s the presentation I did at the 2008 Oracle Open World conference called, “So, you want to be an Oracle ACE?” and is a good resource for anyone who wants to contribute to anything — not just Oracle or MySQL, though certainly it’s based on my experiences with contributing to MySQL. Have a look.
Happy Friday and welcome once again for news from the whacky world of IT. Big Thanks to Tim for pushing out last week’s edition. I was busy banging my head against a particularly nasty wall. If you think my head looks bad, you should see the wall.