Author Archives: sheeri

OurSQL Episode 109: Starting with the right foot

Posted on September 28, 2012 by sheeri

This week we talk about startup scripts and their gotchas. Ear candy is a startup cache gotcha and at the movies presents an introduction to VoltDB.
Events
Percona Live Santa Clara, 2013 call for papers closes Friday October 12th.
Oracle’s “Scale with … Continue reading →

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 109: Starting with the right foot

OurSQL Episode 62: Data Warehousing 101

Posted on October 21, 2011 by sheeri

Josh Berkus of PostgreSQL Experts spoke at OS Bridge this summer on Data Warehousing 101:
Everything you never wanted to know about big databases but were forced to find out anyway (http://it.toolbox.com/blogs/database-soup/data-warehousing-101-slides-… Continue reading →

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 62: Data Warehousing 101

OurSQL Episode 61: Security Blankets, Part 2

Posted on October 14, 2011 by sheeri

We go over the open calls for papers, upcoming conferences, conversations with Oracle, and finish up our 2-part series on MySQL security.
Calls for papers:
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! They opened it on … Continue reading →

Posted in Conferences, Learning, Podcasts, Security | Comments Off on OurSQL Episode 61: Security Blankets, Part 2

OurSQL Episode 60: Charming Data

Posted on October 12, 2011 by sheeri

This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news.
News:
There was a lot of news this week! There were three really big announcements at Oracle OpenWorld that r… Continue reading →

Posted in Conferences, Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 60: Charming Data

OurSQL Episode 59: Security Blankets, Part 1

Posted on October 4, 2011 by sheeri

This week, we talk about MySQL security.
News/Feedback
Collaborate Call for papers is open until Sunday October 14th – http://events.ioug.org/p/cm/ld/fid=15
Collaborate is an Oracle Technology and Applications conference put on by IOUG, OAUG and Quest…. Continue reading →

Posted in Learning, Podcasts, Security | Comments Off on OurSQL Episode 59: Security Blankets, Part 1

OurSQL Episode 58: Opening up Oracle’s World

Posted on September 23, 2011 by sheeri

The main content this week is previewing Oracle OpenWorld’s MySQL sessions.
News
Call for papers for Percona Live: MySQL Conference & Expo 2012 is open! The call will close on Monday, December 5th. To submit a paper, first register as a speaker … Continue reading →

Posted in Conferences, Podcasts | Comments Off on OurSQL Episode 58: Opening up Oracle’s World

Drizzle Podcast #1

Posted on February 25, 2009 by sheeri

In this first Drizzle Podcast, Sheeri K. Cabral and Jay Pipes talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint.
The main web page for Drizzle is http://drizzle.org/.
The main project … Continue reading →

Posted in General, Podcasts | Comments Off on Drizzle Podcast #1

OurSQL Episode 23: Back To School

Posted on October 4, 2007 by sheeri

Current MySQL Webinars:
http://mysql.com/news-and-events/web-seminars/
Archived MySQL Webinars:
http://mysql.com/news-and-events/on-demand-webinars/
MySQL University:
http://forge.mysql.com/wiki/MySQL_University
Classes for October 2007:
Architectu… Continue reading →

Posted in Podcasts | Comments Off on OurSQL Episode 23: Back To School

OurSQL Episode 22: Things To Avoid With MySQL Querie

Posted on August 17, 2007 by sheeri

Feature:

Things to Avoid in Queries
Subqueries and Correlated subqueries
http://dev.mysql.com/doc/refman/4.1/en/correlated-subqueries.html

Jan Kneschke’s post on Groupwise Maximum:
http://jan.kneschke.de/projects/mysql/groupwise-max

Calculated comparisons do not use indexes

INSERT IGNORE
REPLACE
INSERT…ON DUPLICATE KEY

Feedback:

Email podcast@technocation.org

call the comment line at +1 617-674-2369

use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri

or use the Technocation forums:
http://www.technocation.org/forum

Continue reading →

Posted in Podcasts | Comments Off on OurSQL Episode 22: Things To Avoid With MySQL Querie

OurSQL Episode 21: The Rise of the MySQL DBA

Posted on August 9, 2007 by sheeri

Paul Vallee is back for this non-technical podcast about the special creature that is the MySQL DBA.
News:
October 2006 Enterprise/Community Split announcement
http://www.planetmysql.org/entry.php?id=4393
Current clarification of Enterprise/Community s… Continue reading →

Posted in Podcasts | Comments Off on OurSQL Episode 21: The Rise of the MySQL DBA