ALL POSTS

Good Database Design is Mightier than Hardware

Have you ever heard the one about throwing hardware at a software problem? I have this nifty RAC system that supports some very public and very mission-critical apps, and one day (it was Sunday night) it starts choking. We’re getting enqueues. Slowly they start climbing. Ten nodes came to a crashing halt. I have now seen a ten-node RAC cluster come to crashing halt and completely lock up. Why, you ask? A simple SQL statement: DELETE FROM a WHERE b=c AND d=e;.

Working at Pythian: 3 Months In

I have been a MySQL DBA at The Pythian Group for three months (and 2 days) now. At most companies that is the probationary period, and I am still here, so that is a good sign….. So, after three months, how do I like it? Glad you asked!

Hotsos Symposium 2008 — Still On

The symposia is still ongoing and my head is slowly filling up — relieved from my presentation, finally, I’m able to focus on others’ sessions. I attended Wolfgang Breitling’s presentation on “Active Statistics”. He provided a lot of insights into statistics gathering options and emphasized lots of new features in 11g. Have a look at my post to read about some of the other great presentations I attended.

Oak Table Network

I’m a member of the Oak Table Network now! I’m so delighted and proud to be the part of that group and also very grateful for the invitation to join those bright people.

MySQL Partitioning

I’ve been setting up partitioning for various customers lately. The goals primarily have been easy purging of large growth tables and keeping indexes small enough to stay in memory and manageable. These have all been range partitions on dates, which is a rather common requirement. As you’ve probably noticed in previous posts, I absolutely hate…

Hotsos Symposium 2008 – The Before

First of all “the before” time is over — I’m done with my presentation. It’s been the first slot of the day — 8:30 and Cary Milsap was presenting in another hall so what chances do I have to get people in? It turned out that some people actually did show up and quite a few considering the circumstances. To find out more about the other great presentations I saw today keep reading. If not, stay tuned — more to come.

Working from Oracle HQ

What I’ll be doing in the next five days is kind of a secret. Unfortunately, that’s all I’m allowed to tell you, except maybe that I know many people who would love to be in my shoes this week.

Webinar: Applying the supply management promise to IT

Courtesy of our friends at Oracle cost containment company Miro Consulting, I am giving a webinar tomorrow at 1pm EST (click this link for the time in other timezones please. The subject I’ve chosen is how to apply the best practices around advanced supply management that are extremely successful and mature in the product supply chain world to the equally extremely immature practices we typically find in enterprise IT supply provisioning. It should be a great presentation; I give an overview of the famous “Toyota Way” and cover some recent findings from the California Management Review as well. Keep reading for a full overview.

Page 225 of 282« First Page...10...223224225226227...230...Last Page »