Everything MySQL

A great place to be!

Sarah Sproehnle
  • Female
  • San Jose, CA
  • United States
Share on Facebook Share on Facebook Share

Sarah Sproehnle's Friends

  • Morgan Tocker
  • Venu Anuganti
  • LinuxJedi
  • Lucas Renan
  • Dan Neff
  • Mark Atwood
  • Roland Bouman
  • Ronald Bradford
  • Seattlegaucho
  • Greg Oehmen
  • Alexandre Almeida
  • Dan Smythe
  • Keri
  • Giuseppe Maxia
  • Stephen Sproehnle

Sarah Sproehnle's Discussions

Misusing LEFT JOIN

SQL is definitely fun, unless it's not. ;) I've seen many cases where developers misuse a LEFT (or RIGHT) JOIN. Either they don't understand what an outer join is, or they needed an outer join at…Continue

Started Sep 11, 2009

Gifts Received

Gift

Sarah Sproehnle has not received any gifts yet

Give a Gift

 

Sarah Sproehnle's Page

Sarah Sproehnle's Blog

MySQL & Hadoop talk at Oracle Open World

I recently gave a talk about importing and exporting data between MySQL and Hadoop at Oracle Open World.  Here are the slides for that talk:

MySQLandHadoopNov2011.pdf

Posted on October 13, 2011 at 1:54pm

Hadoop for MySQL people

There's a lot of buzz lately about Hadoop. If you're completely new to Hadoop, I recommend the free videos from Cloudera (http://www.cloudera.com/resources/?type=Training). If you have a vague idea and want to play around, it's easy!


First, download Cloudera's training VM which has a small Hadoop cluster already installed and running:…
Continue

Posted on June 23, 2010 at 6:04pm

Sarah speaking at the 2010 MySQL User Conference

I'll be giving 2 talks this year. Here's a quick description:





Want Faster Queries?

Fixing slow queries is often very easy if you know what to look for and it can give huge performance gains. In this talk I'll cover common SQL mistakes, how to identify "bad" queries, indexing techniques, using EXPLAIN to verify execution plan, etc.…





Continue

Posted on February 22, 2010 at 4:27pm

Data type confusion: what is an int(11)?

Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.



First of all, there are 5 types of integer. They are all fixed size.

Type # of…
Continue

Posted on October 30, 2009 at 8:04pm — 1 Comment

Comment Wall (1 comment)

You need to be a member of Everything MySQL to add comments!

Join Everything MySQL

At 12:32pm on September 22, 2009, Lakshmi said…
Hey Sarah, interesting blog posts!
 
 
 

© 2017   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service