User Groups

Presentation and Interview at NoCOUG Spring Conference

NoCOUG Spring Conference 2010 is in just 10 days, I’ll be doing my two hour long presentation — Demystifying Oracle RAC Workload Management. If it’s your local conference, I hope you can attend and say hello. You might also want to download the whitepaper that I put together few years ago for Hotsos Symposium — Oracle RAC Workload Management.

RMOUG Training Days 2010 Round Up

I have really enjoyed few technical sessions that I managed to attend. I want to mention couple that I liked especially. I managed to attend the full session by Robyn Sands about adopting variance to performance troubleshooting and performance acceptance — lots of interesting goodies. have been honored to participate in the opening keynote amongst other Oracle ACEs and ACE Directors including Stanley

Oracle ASM 11g — The Evolution (slides from RMOUG10)

Oracle Automatic Storage Management has proven to be one of the most widely adopted new features in Oracle Database 10g and it has been dramatically improved in the later 11g releases. This presentation will explain what changes are solved by ASM, how these challenges are solved, what barriers there are to ASM adoptions, and how 11g Release 2 addresses these barriers. The slides are linked here.

RMOUG10 — Do Sharks Eat Oracle ACE’s?

Denver Convention Center at the Oracle ACEs and ACE Directors Breakfast at 7:50am. This is your chance to ask any questions you want and get honest answers on anything from Oracle databases and Fusion Apps to diving with sharks and anything in between. Also consider dropping by the OakTable / Apress booth to have a more private conversation with members of the OakTable Network. Traditional OakTable Challenge begins again tomorrow so if you think you have a tricky question around Oracle databases — by all means let us know.

Basic Joins and Subqueries Video

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.

Pythian Goes to RMOUG Training Days 2010, Denver

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!

UKOUG 2009 — Server Manageability Roundtable

This is a call for topics for the upcoming Server Manageability Roundtable that I will be running at UKOUG Conference 2009 Technology and E-Business Suite. The topic is quite broad so we will obviously need to focus on the most relevant areas for the attendees and this is the chance to state your interest so please comment away! Here are the topics that I think might be particularly interested…

Where’s Everyone Gone?

Now that our new web-site is live I’d like to do the first blog post on it!

You shouldn’t be surprised if you notice that it’s difficult to locate your DBAs in the first week of December (i.e. in just two weeks from now)! And you know why? Because you need to be looking in the right place to find them.

Video: Building a MySQL Slave and Keeping it in Sync

Last night at the Boston MySQL User Group I presented on how to get a consistent snapshot to build a slave, use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies. The links to the slides and video are here.