Tag: MySQL

Community dinner at Pedro’s during the O’Reilly MySQL Conference

I was sad that last year there was no community dinner, and I missed the one the year before when Jonathan Schwartz and Rich Green made an appearance. This year I am determined not to miss it, and so I am calling for a community (pay-your-own-way) dinner on Monday, April 12th, at Pedro’s

Read More >

Log Buffer #179: A Carnival of the Vanities for DBAs

You have found the 179th edition of Log Buffer, the weekly review of database blogs. Welcome. Enjoy your stay. We begin with . . .

Read More >

How to tell when using INFORMATION_SCHEMA might crash your database

There are those that are very adamant about letting people know that using INFORMATION_SCHEMA can crash your database. Of course they leave out one extremely important piece of information: you can actually figure out how dangerous your INFORMATION_SCHEMA query will be, ahead of time, using EXPLAIN. Here’s how.

Read More >

Pythian Launches ISV Partner Program

Pythian has launched a Partner Program to assist Independent Software Vendors (ISVs), whose applications have intensive database requirements. We assist their client base by helping them correctly plan, deploy, and manage the underlying database infrastructure, be it MySQL, Oracle or SQL Server, to ensure the ISV customers’ software environment is sound, and performs well over time.

Read More >

Log Buffer #178: A Carnival of the Vanities for DBAs

Gerry Narvaja has published the 178th edition of Log Buffer, the weekly review of database blogs.

Read More >

Log Buffer #177: A Carnival of the Vanities for DBAs

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

Read More >

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.

Read More >

Log Buffer #176: A Carnival of the Vanities for DBAs

This is the 176th edition of Log Buffer, the weekly review of database blogs.

Read More >

How to Submit a BoF Session for the MySQL Conference

The call for proposals for Birds of a feather sessions closes at 11:59 pm PST on Thursday, February 18th, 2010. Sessions can be added during the conference, but if you submit and your BoF is accepted it will be printed in the schedule.

Read More >

So, You Want to be an Oracle ACE? Oracle OpenWorld 2008 Presentation

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.

Read More >
Page 46 of 88« First Page...10...4445464748...60...Last Page »