About Me
I am a Leader who is not afraid of the commandline while understanding that budgeting, project planning, processes and methodologies are also valuable work. I am detail-oriented and follow up to make sure that everyone is happy, as customers drive my team's needs. I have experience managing and directing across data storage, data integration/ETL, and data visualization.
My background is an expert in MySQL with strong performance and schema optimization, stored code, and delighting customers. My strongest beliefs are "it is not good until it is measurably good," and "it is not completed until it is automated, monitored, backed up and documented."
Table of Contents
Where no one has gone before: compiling LDAP with PHP and with Python for use with MySQL's auth_pam plugin for secure, non-plaintext LDAP authentication.
- Pragmatic Certified Product Manager
- ITIL Foundations Certification October 2016
- MySQL™ 2012 Community Contributor of the Year Award April 2012
- Oracle ACE Director for MySQL, March 2010
- MySQL™ 2008 Community Advocate Award April 2008
- MySQL™ 2007 Community Advocate Award April 2007
- MySQL™ 5.0 DBA Certification April 2006
- MySQL™ Core Certification Feb 2004
Brandeis University, Waltham, MA
- Master's Degree in Computer Science, Specialization in Databases May 2001
- Master's Project in Groupware Mediated Cooperative Programming
- Bachelor's Degree, Concentration in Computer Science May 2000
Author
Cabral, S.K. and Murphy, B.K. (May 2009) MySQL Administrator's Bible. Wiley-Blackwell.
Technical Editor
Bradford, Ronald. (June 2012) Effective MySQL: Advanced Replication Techniques.
Date, C.J. (Dec 2008) SQL and Relational Theory: How to Write Accurate SQL Code. O'Reilly Media, Inc.
Schwartz, B. and Zaitsev, P., et. al. (June 2008) High Performance MySQL 2nd Edition. O'Reilly Media, Inc.
Cumming, A. and Russel, G. (Nov 2007) SQL Hacks. O'Reilly Media, Inc
Sole Product Manager for the
O-FISH project, as featured in
NBC News.
Github presence
MySQL Nagios plugin - mysql_health_check.pl - flexible and extensible monitoring of arbitrary status and system variables in Perl-based calculations, with caching option -
plugin -
presentation
MySQL Puppet Module
mysqltuner 2.0 presentation -
software
Technocation, Inc. - Mar 2007 (inception) - Dec 2019
Founder, treasurer, website administrator and videographer for most of the videos at http://youtube.com/tcation.
Boston MySQL Meetup Group - Oct 2005 (inception) - Nov 2015
Founder, organizer and frequent presenter
Planet MySQL Nov 2005 - Dec 2013
Contributor to
Planet MySQL through
sheeri.com,
Pythian.com and
Mozilla's IT blog
OurSQL Database Podcast - Nov 2006 (inception) - Jan 2008, Dec 2010 - June 2015
Podcast creator, maintainer and co-host, oursql.com
IOUG MySQL Council member, 2011-2013
2021 MongoDB.live Innovation Track moderator, conference review committee for Operations & Tools track, Make It Matter track
2020 MongoDB.live conference review committee
2012 OSCon - July 2012
Program Committee Member
2011 OSCon - August 2011
Program Committee Member
2011 Collaborate - April 2011
MySQL Track Manager for Collaborate 2011
2010 OpenSQL Camp Boston - October 2010
Organized and managed the free 2-day OpenSQLCamp conference.
2010 MySQL User Conference & Expo - April 2010
Program Committee Member for the 2010 MySQL User Conference & Expo
2009 MySQL Camp - April 2009
Organized and managed the free track at the 2009 MySQL Users Conference & Expo.
See
http://www.sheeri.com/testimonials and
LinkedIn recommendations.
MySQL Marinate - a virtual MySQL self-study course. Monitoried and verified homework on github. Sep 2012 - Nov 2014.
Advanced Topics in MySQL and MariaDB at lynda.com, released October 2014
Understanding MariaDB for MySQL Users at lynda.com, released September 2014
Up and Running with MySQL Development at lynda.com, released March 2014
2024 - 2023 -
2022 - 2021 - 2020 -
2019 - 2018 - 2017 -
2014 - 2013 - 2012 -
2011 - 2010 - 2009 -
2008 - 2007 - 2006
PDF slide decks are linked for each presentation. Video, where available, is also linked. All videos are on youtube unless otherwise indicated.
-
Beyond Implementation: Nurturing the Spirit of Data Mesh. (Sep 2023). Denodo DataFest.
-
Implementing OpenLineage: A work in progress. (Dec 2022). OpenLineage TSC. - PDF
-
Collibra + Snowflake: Better Together with Data Lineage. (Nov 2022) Data Citizens '22, San Diego. PDF - Video (note: you need to register to see the video, but registration is free)
-
Getting to No: Tactics and Scripts to Stay Close to Your Path. (May 2022). Building Product That Matter, Together. PDF
-
Building Web Applications: Good, Fast, Cheap - Pick 3!. (Jul 2021). MongoDB .live Conference. PDF - Video
-
Data Modeling with MongoDB (Sep 2020). MongoDB Twitch Stream. PDF - Video
-
Are Transactions Right For You? Using and Not Abusing Transactions. (Jun 2020). Mongodb .Live. Slides - Video
-
Problems with RDBMS and How to Solve Them. (Feb 2020) Combined MongoDB and MySQL meetup groups, Barcelona.
- MongoDB ACID Transactions Deep Dive. (Oct 2019). MongoDB Webinar. PDF - Video
- Best Practices for Migrating from RDBMS to MongoDB. (Oct 2019). MongoDB Webinar. PDF - Video
- Keynote: On Being a Senior Engineer. (April 2018). Darkmira PHP Tour, Brasilia. PDF
- Office 3.0: Remote or On Premises, Making it Work at Work. (Apr 2018). Salesforce, Inc. PDF
- Are you getting the best out of your MySQL indexes? (May 2017). Salesforce. PDF - video
- Optimizing Queries with EXPLAIN (May 2017). Salesforce. PDF - video
- Better MySQL Indexes and Schema (December 2014). Mozilla. PDF
- NoSQL and MySQL - Dynamic Schemas (November 2014). Oracle Virtual Technology Summit, Remote. PDF
- Being a MySQL Ninja (September 2014). Oracle OpenWorld, San Francisco. PDF
- What's New with MySQL and MariaDB (April 2014). Linux User Group, New York City. PDF - Video
- Percona Replication Manager (January 2014). MySQL User Group, Boston. PDF - Video
-
MySQL Marinate (November 2013). AvidGeo, Ignite Spatial and Ignite Data Conference, Boston. PDF
- Recognizing and Overcoming Bias: Ways to Make Your Workplace More Successful and Welcoming (November 2013) Usenix LISA, Washington, D.C. PDF (co-presented with Leslie Hawthorn)
- Alerting with MySQL and Nagios (September 2013). Nagios World Conference, St. Paul, Minnesota. PDF - Video (Position 44:05 has an audience member ask if Sheeri actually wrote the code)
- Upgrading to MySQL 5.6 (September 2013). MySQL Connect at Oracle OpenWorld, San Francisco. PDF
- Managing Hundreds of MySQL Servers Efficiently (September 2013). MySQL Connect at Oracle OpenWorld, San Francisco. PDF - Video
- MySQL Utilities (September 2013). MySQL User Group, Boston. PDF
- Getting Started with MySQL's Performance Schema. (July 2013) MySQL User Group, Tokyo. PDF - Video - Also presented at the August Boston MySQL User Group meeting.
- MySQL and Puppet (April 2013). Back Bay LISA User Group, Boston. PDF - Video
- Different MySQL Forks for Different MySQL Folks (February 2013). Confoo, Montreal. PDF - Video
- Are You Getting the Best Out of Your MySQL Indexes? (February 2013). Scale 11x, Los Angeles. PDF - Video
- MySQL Backups (February 2013). Northeast LinuxFest, Cambridge MA. PDF - Video
- Backing up MySQL. (February 2013). Rocky Mountain Oracle User Group Training Days, Denver. PDF
- Are you Getting the Most Out of Your Indexes? (February 2013). Rocky Mountain Oracle User Group Training Days, Denver. PDF
- The Finer Art of Being a Senior Sysadmin (January 2013). PDF - Video
- MySQL Security: More Than Just ACLs (January 2013). MySQL User Group, Boston. PDF - Video
PDF
- The Art of Cat Herding: How to Manage Geeks. (November 2012) CodeConnexx, Indianapolis. PDF - Video
- Alerting on MySQL with Nagios. (September 2012) NagiosWorld, St. Paul, Minnesota. PDF - Video
- Database Scaling at Mozilla. (September 2012) Oracle OpenWorld, San Francisco. PDF
- Google-Hacking MySQL. (September 2012) Oracle OpenWorld, San Francisco. PDF
- Are you Getting the Best Out of Your MySQL Indexes?. (August 2012) Northeast PHP, Boston. PDF
- Getting Rid of Scheduled Tasks Using MySQL Events. (August 2012) Northeast PHP, Boston. PDF
- Oracle ACE Latin American Tour, North, July 2012
Venues
Universidad Icesi, Cali, Colombia
Universidad de las Américas, Quito, Ecuador
Ministry of Science, Technology and Tertiary Education, Trinidad
Universidad Galileo, Guatemala, Guatemala
Universidad Technológica, UNITEC, Tegucigalpa, Honduras
Universidad Latinoamericana de Ciencia y TechnologÃa ULACIT, San José, Costa Rica
Talks given
Get Rid of Cron Scripts Using MySQL Events - Video
Optimizing Queries with EXPLAIN - Video
MySQL Security - Video
Ideas for DBAs (formerly, Best Practices for DBAs)
The Art of Cat Herding: How to Manage Geeks
- Intermediate MySQL administration. (June 2012) Open Database Camp at Southeast LinuxFest, Charlotte, North Carolina. PDF - Video
- Getting Started with a Podcast. (May 2012) Professional IT Community Conference (PICC), New Brunswick. PDF
- MySQL Security. (May 2012) Central Virginia MySQL meetup, Charlottesville, Virginia. PDF - also delivered at:
OUG Harmony Conference in Helsinki
Open Database Camp in Charlotte
Boston MySQL User Group
Professional IT Community Conference (PICC), New Brunswick, NJ.
MySQL/NoSQL/Cloud Conference Latin America in Buenos Aires
- Optimizing MySQL Joins and Subqueries. (May 2012) OUG Harmony Conference, Helsinki. PDF
- MySQL Security: More Than Just ACLs (April 2012) Effective MySQL User Group, New York City.. PDF - Video
- Google Hacking MySQL and more MySQL Security (April 2012). Percona Live, Santa Clara. PDF
- How to be a Rockstar DBA - Lightning Talk (April 2012). Percona Live, Santa Clara. PDF
- Creating Data Warehousing Schemas. (April 2012) SkySQL and MariaDB Solutions Day, Santa Clara.
- MySQL User Groups and Community (January 2012). Oracle User Group Leader's Conference. Oracle Headquarters, Redwood Shores, California. HTML slides
- Securing MySQL (September 2011). Oracle OpenWorld, San Francisco, CA.
- Becoming a Rock Star MySQL DBA (September 2011). Oracle OpenWorld, San Francisco, CA. PDF
- The Art of Cat Herding: How To Manage Geeks (Jul 2011). OSCon, Portland, OR. ODP - Video
- Securing MySQL (Jun 2011). Long Beach, CA.
- mysqltuner 2.0 (May 2011). Open Database Camp, Sardinia Italy. PDF - Video
- Keeping a MySQL Slave Server in Sync (May 2011). Open Database Camp, Sardinia Italy. PDF whitepaper - PDF of presentation - Video
- Nagios Plugins for Monitoring MySQL (April 2011). Collaborate, Orlando, FL. Video
- Converting MyISAM Tables to InnoDB. (April 2011). Collaborate, Orlando, FL.
- Deep Dive (6 hours): Configuring MySQL for Optimal Performance (April 2011). Collaborate, Orlando, FL.
- mysqltuner 2.0 (Oct 2010), OpenSQL Camp, Boston, MA. PDF - Video
- Keeping a slave in sync with mk-table-checksum and mk-table-sync (Oct 2010), OpenSQL Camp, Boston, MA. PDF - Video
- Proactively Optimizing Queries with EXPLAIN and mk-query-digest, (Sept 2010). Oracle OpenWorld, San Francisco, CA. PDF
- What You Need To Know To Upgrade from MySQL 5.0 to MySQL 5.1 (July 2010). IOUG webinar. PDF
- Navigating MySQL Stored Procedures & Functions and Triggers (Jun 2010). ODTUG Kaleidoscope 2010, Washington, D.C. PDF
- MySQL Syntax (Jun 2010). ODTUG Kaleidoscope 2010, Washington, D.C. PDF
- Bulk Loading with MySQL (Jun 2010). ODTUG Kaleidoscope 2010, Washington, D.C. PDF
- How to Stop Hating MySQL (May 2010). Professional IT Community Conference (PICC) 2010, New Brunswick, NJ. PDF
- Time Zones in MySQL (April 2010). MySQL Users Conference & Expo, Santa Clara, CA. PDF - Video
- Tutorial (6 hours): MySQL Configuration Options, Files, and Variables (Apr 2010). MySQL Users Conference & Expo, Santa Clara, CA. PDF part 1 - PDF part 2 - Video (part 1, pre-break) - Video (part 2, post-break) - Video (part 3, pre-break) - Video (part 4, post-break)
- Finding Query Problems Proactively with Query Reviews (April 2010). MySQL Users Conference & Expo, Santa Clara, CA. PDF - Video
- Optimal Joins and Subqueries in MySQL (Jan 2010). MySQL User Group, Boston. PDF - Video
-
Time zones and MySQL (Dec 2009). MySQL User Group, Boston. PDF
- Slave Setup and Syncing Issues aka Building a MySQL Slave and Keeping it in Sync (Nov 2009). MySQL User Group, Boston. PDF - Video
- SHOW ENGINE INNODB STATUS explained (Oct 2009). MySQL User Group, Boston. PDF - Video
- A better mysqltuner (Aug 2009). OpenSQLCamp, St. Augustine, Germany. PDF - Video
- Agile environments and DBAs (Apr 2009). MySQL Users Conference & Expo, Santa Clara, CA. PDF
- Connect and Replicate Securely: How to use MySQL with SSL (Apr 2009). MySQL Users Conference & Expo, Santa Clara, CA. PDF
- Tutorial (3 hours): Understanding How MySQL Works by Understanding Metadata (Apr 2009). MySQL Users Conference & Expo, Santa Clara, CA. PDF - Video, part 1 - Video, part 2
- Keynote: How to be a MySQL Community Superhero (Apr 2009). MySQL Users Conference & Expo, Santa Clara, CA. PDF
- MySQL Partitioning (Jan 2009). MySQL User Group, Boston - PDF - Video
-
What's new in MySQL 5.1 (Dec 2008). MySQL User Group, Boston PDF - Video
- How to stop hating MySQL (Nov 2008). LISA, San Diego PDF - Video
- How to be an Oracle ACE. (Sep 2008). Oracle OpenWorld, San Francisco. MySQL Views. (Sep 2008). MySQL User Group, Boston. PDF - Video
- Best Practices for Sysadmins and Database Admins BoF. (July 2008) OSCon, Portland, Oregon.
- Pros and Cons of Managed Services. (June 2008) Usenix, Boston.
- The Guru is In: MySQL. (June 2008) Usenix, Boston.
- What is MySQL Cluster Good For? (March 2008). MySQL User Group, Boston.PDF
- Why Are Databases So Hard to Secure? (Feb 2008). Shmoocon, Washington D.C. PDF
- Database Basics. (Feb 2008) MySQL User Group, Boston.PDF
- Best Practices for Database Administrators (April 2008). MySQL Users Conference & Expo, Santa Clara, CA.
- Database Security Using White-Hat Google Hacking. (April 2008). MySQL Users Conference & Expo, Santa Clara, CA.PDF
-
Capacity Planning With MySQL (Aug 2007). MySQL User Group, Boston. PDF
- MySQL Proxy. (Sep 2007). MySQL User Group, Boston. PDF - Video
- Testing the Security of Your Site (April 2007). MySQL Users Conference & Expo, Santa Clara, CA.
- Monitoring MySQL Servers With MySQL Network. (April 2007) MySQL Users Conference & Expo, Santa Clara, CA. (Also presented Nov 2006, MySQL User Group, Boston.)
-
Graphical User Interfaces to MySQL. (Dec 2006). MySQL User Group, Boston. Boolean Values and Bit Operators (Nov 2006). MySQL Camp, Mountain View, CA. (Also presented Oct 2006, MySQL User Group, Boston.)
- Storing Images in MySQL. (Jun 2006). MySQL User Group, Boston.
- So You've Inherited a MySQL Instance on Unix....(Feb 2006). MySQL User Group, Boston. PDF - PDF checklist - Excel checklist - PDF
- MySQL Backups. (Jan 2006). MySQL User Group, Boston PDF - Video
All presentations should be available at
http://sheeri.com/files/presentations/
Many presentations have accompanying video, available at
https://www.youtube.com/user/tcation