• Impressions from Percona Live, London

    October 27, 2011

    Am now back from Percona Live, London. Here are some quick impressions of mine. The physical location of the conference was excellent, not far from Tower Bridge. The conference area itself was nice and has good atmosphere. Very well organized. Kudos to Percona! Theme The official theme for the conference was "Discover the Power of […]

  • Contest for Glory: write a self throttling MySQL query

    October 27, 2011

    What's all this about? I've you've been to my talk in London, then you've already got this as homework. If not, allow me to fill in the details: I was speaking about MySQL's programmatic nature in many aspects (best if you read the slides!). We discussed user defined variables, derived tables, ordering constructs, order of […]

  • Slides from my talk: "Programmatic Queries: things you can code with SQL"

    October 27, 2011

    Here are the slides from my talk Programmatic Queries: things you can code with SQL held on October 25th on the Percona Live event, London. Programmatic Queries: PDF I wish to thank those who attended my talk. The topic of the talk was irregular and, to some extent, controversial. Should one really rely on internal […]

  • Test-driven SQL development

    October 20, 2011

    I'm having a lot of fun writing common_schema, an SQL project which includes views, tables and stored routines. As the project grows (and it's taking some interesting directions, in my opinion) more dependencies are being introduced, and a change to one routine or view may affect many others. This is why I've turned the development […]

  • Speaking on Percona Live, London: "Programmatic Queries: things you can code with SQL"

    October 10, 2011

    I'll be speaking at the Percona Live event, held in London, October 24, 25, 2011. My session is called Programmatic Queries: things you can code with SQL. It's a short 30 minute talk, in which I present underlying knowledge of the programmatic nature of SQL queries within MySQL, and how to take advantage of such […]

 
Powered by Wordpress and MySQL. Theme by openark.org