Posted by Sheeri Cabral on Dec 1, 2009
OpenSQLCamp was a huge success! I took videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded). Unfortunately, I was busy doing administrative stuff for opensqlcamp for the opening keynote and first 15 minutes of the session organizing, and when I got to the planning board, it was already full….so I was not able to give a session.
Posted by Sheeri Cabral on Nov 25, 2009
OpenSQLCamp was a huge success! Not many folks have blogged about what they learned there….if you missed it, all is not lost. We did take videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded).
All the videos have been processed, and I am working on uploading them to YouTube and filling in details for the video descriptions. Not all the videos are up right now….right now all the lightning talks are up.
Read the rest of this entry . . .
Posted by Sheeri Cabral on Aug 27, 2009
In record time, less than a week after the conference (thanks to the free Pinnacle Video Spin and YouTube), all 11 videos that were taken at OpenSQLCamp Europe are online.
For those who missed the sessions, or just want to relive the fun!
Almost all the sessions were filmed; regrettably Darren Cassar’s Securich – MySQL user administration and security made easy! and Stephane Combaudon’s Minimizing data access with covering indexes were not.
The YouTube videos have the descriptions and resources from the official conference pages, and links to pages. If there is more information to add (for example, the slides from a talk are now online), or if you spot an error, please feel free to add a comment on the YouTube video, or as a comment to this blog post.
Individual presentations:
Enjoy!
Posted by Sheeri Cabral on Jun 12, 2009
This is the 150th edition of Log Buffer, the weekly review of database blogs. Someone accidentally left Dave Edwards’ cage unlocked, and he escaped, thus leaving me with the pleasurable duty of compiling the 150th weekly Log Buffer.
Many people other than Dave are finding release this week. Read the rest of this entry . . .
Posted by Sheeri Cabral on Jun 9, 2009
About six months ago, the question of storing images in a database came up. This is one of my favorite topics, and has many database-agnostic parts.
Personally, I think “tell me about storing images in a database” is actually a great interview question, because you will be able to see the difference between someone who has just memorized “what’s right” versus someone who is really thinking. It also helps you see how someone will communicate — if they just say “NEVER do it, it’s as bad as crossing the streams!” then they are a type of person that gives you a short answer, without much explanation, and without many nuances. (That may be what you are looking for, but usually you want someone who gives reasons for why they strongly feel one way or another).
Consider the following cases:
Read the rest of this entry . . .
Posted by Sheeri Cabral on May 11, 2009
A year ago, the outline was being written. A lot of work was crammed into the intervening months, and I am happy and proud to announce that the MySQL Administrator’s Bible has been published, and is sitting on the shelf at many major booksellers already. The official publication date is today — Monday, May 11th, 2009 — although some stores have had copies for a week, including Amazon.com.
The MySQL Administrator’s Bible, published by Wiley Press (available on Amazon.com at http://www.amazon.com/MySQL-Administrators-Bible-Sheeri-Cabral/dp/0470416912/, fully covers how to administer MySQL 5.1. It is suitable for people new to MySQL, although as an experienced MySQL DBA I can say that I learned a lot while researching and writing this book, and I believe that even veteran DBAs can learn from this book.
This book for anyone who wants to learn how to use and administer MySQL. Unlike other beginning books, however, it will appeal to DBAs who are experienced in other database systems such as Oracle, Postgres, Microsoft SQL Server, DB2, Sybase, Firebird. For example, the book contains a chapter on how MySQL’s SQL is different from the SQL standard. Basic SQL has been added as a feature of the companion website, so that those who do not know how to form a query can learn, but those who are well versed in SQL do not feel they have wasted money buying a book where they already know some of the material in it.
The detailed table of contents can be viewed or downloaded as a PDF. Or, if scanning the index is your cup of tea, it is also available as a PDF. The cover price is $49.99, but Amazon.com is selling it for $31.49.
Posted by Sheeri Cabral on Mar 26, 2009
I am passing this along — I am not sure if most folks reading this can make it, as it is last-minute and in the Boston area, but I figured I’d let people know that the New England Database Society exists. It’s free, sponsored by Sun (and has been for years, long before Sun bought MySQL), and is hosted by my college database professor, Mitch Cherniack. (To that end, I should probably make sure to promote the Boston User Group here more often! I keep forgetting…)
You can find information on how to be a part of the mailing list at http://www.cs.brown.edu/sites/neds/
The next New England Database Society will be held on Friday, March 27 and the speaker is Christian Jensen of Aalborg University.
===================================================================
[N]ew [E]ngland [D]atabase [S]ociety
sponsored by Sun Microsystems, presents
Data Management for Location-Based Services
Christian S. Jensen
Center for Data-Intensive Systems
Department of Computer Science
Aalborg University
Read the rest of this entry . . .
Posted by Sheeri Cabral on Aug 29, 2008
Though the event is still happening in Charlottesville, VA Nov. 14-16th (Fri night through Sunday), the new web page for OpenSQL Camp is http://www.opensqlcamp.org. The content has been ported over to MediaWiki, and a captcha has been put in place that is activated on any page change that adds an external URL.
Whether you are into MySQL, PostgreSQL, Drizzle, or some other open source SQL database, go forth and register for OpenSQL Camp, without having to login! (Disclosure: if you do not create a login, your IP is tracked.)
