August 5, 2016 — John Sterrett is a Microsoft MVP and is a consultant in the SQL Server field. He specializes in SQL Server performance tuning, high availability, disaster recovery, database design, development and database administration.
April 17, 2016 — This session will describe the ultimate safety net for one of your key investments: your WP site.
A brief overview of the moving parts of a WP install/Setup such as database, application and data files will be covered first. Next, we’ll delve more into the tools and procedures required to perform a manual (non-plugin) backup of a WP Site.
April 5, 2016 — MariaDB è un fork di MySQL il database relazionale, sviluppato da una community sotto licenza GNU GPL che intende mantenerlo come software libero.
Con ottimizzatore avanzato delle performance di MariaDB e le sue specifiche caratteristiche si possono facilmente migliorare le performance della tua applicazione.
December 10, 2015 — This talk will cover a few key “Aha” moments that you should have about the way WordPress works. We’ll talk about things like the template hierarchy, what’s going on in wp-config, where WordPress content is stored (the database vs. the file system), how posts and pages and custom post types are represented in the database, what folks are talking about when they talk about hooks and filters, and just generally review the “behind the scenes” mechanics of how WordPress works. We’ll also touch on a few “tricks of the trade” that you might not realize are out there (version control, staging sites, caching, Vagrant, and other fun tools to make development with WordPress just a little bit easier).
This talk is aimed at designers and new developers who maybe have a few PHP tricks up their sleeves, but still haven’t figured out some of the details behind the scenes.
If you’ve never edited functions.php and don’t know what it is, this probably isn’t a good talk for you just yet. If you’ve written a plugin or modified several .php files in your WordPress themes, this talk will probably be a bit too basic for you. If you’ve set up a child theme before and know what functions.php is, even if you haven’t really used it all that much, or even at all…. you’re probably the exact person who will get a lot out of this talk. And if that’s you, you should be able to walk away with a solid mental model of how WordPress works “behind the scenes” and be in a much better position to do development with it
September 20, 2015 — This session teachs developers how to write custom WP_Query loops, the different functions available for interacting with WP_Query objects, and how to use each function appropriately. We discuss the cases where WP_Query doesn’t fit your needs, and how to deal with the global $wpdb object directly. And we look at the most useful methods available with the $wpdb object, and discuss responsible usage and implementation there of.
August 5, 2015 — Theme security is an intimidating topic for both new and experienced developers but ignoring the issue will make you a target and leave your site vulnerable to attacks. In this talk you’ll learn theme security best practices, the common types of attacks, and many of the functions that WordPress and PHP provide to keep your site safe.
May 17, 2015 — Understanding how the database schema of WordPress is setup, including a walk-through of the tables and how WordPress stores the data and helps you interact with it via its APIs. We’ll also dive into the benefits and dangers of the schema and how to adapt it to go beyond just blog posts.
May 14, 2015 — Could you recover your WordPress website if it was lost due to a hardware failure, hacked, or corrupted during an update or plugin install? Having reliable automated backups can make the difference between taking 10 minutes to restore your site, and needing to do a complete site rebuild that may take a week or more. This presentation will look at the many options and plugins for backing up your WordPress site including backing up to Amazon S3.
May 5, 2015 — This session looks at what HyperDB is, when you might want to use it, how to use it in the first place, as well as some other flavors of MySQL that you might consider taking a look at (in particular MariaDB and Percona MySQL). This session is aimed at advanced developers who are looking to level-up their database chops.