Posts Categorized: Technical Blog
Welcome to another edition of Blogrotate. This has been an interesting week in the IT world, with Microsoft security issues being the major focus of attention.
Pythian is hosting the February meeting of the Ottawa Valley System Admistrators Guild (OVSAGE). This free event is open to all those interested in System Administration.
Gerry Narvaja has published the 178th edition of Log Buffer, the weekly review of database blogs.
What should you expect coming to the Hotsos Symposium 2010? It’s 3 days packed with sessions on all aspects of Oracle performance optimization whether it’s design, troubleshooting, development, methodologies and processes. Legendary Tom Kyte — who else can you expect for the keynote?! If you take an optional training day with Tanel Poder then you are likely to learn at least as much about troubleshooting Oracle database performance as you do during the conference and probably even more. Every presentation by Tanel has been an eye opener for me. If you’ve seen his material, you’d know what I’m talking about. Now, imagine that it’s not a one-hour session but the whole day! It will fry your brains so this day is for the strongest! :)
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.