Thanks to this tip on the Taragana blog, I was introduced to the mysqlcheck command. In a pinch, the following command will check, repair and optimize all tables in all databases on your MySQL server instance. mysqlcheck -u root -p –auto-repair –check –optimize –all-databases mysqlcheck is available in MySQL 3.23.38 and later. The official documentation

We have a few sites that exist on a MediaTemple DV 3.5 server. We’ve long been concerned about the lack of performance we are getting on this DV versus sites on a smaller Linode.com DV. We are not here to debate that today. What we have done is to install APC on the MediaTemple DV

Here’s a quick fix. We have a site that has been through a number of migrations, moves and upgrades. We use the Admin module that provide a nice UI for site administration. Somewhere along the way, the admin menu items got completely hosed

We recently began testing the installation profile for Drupal called OpenPublish. The good folks at Phase 2 Technology have opened this installation profile (distribution) up for all to use with some key features for the semantic web. This post is not to go over or compares features with other similar distributions. Instead this is more

Today’s SSWUG.org newsletter contained a great few paragraphs regarding what you look for in a new hire. As a hiring manager at various levels over my career, I have often asked myself, in self-reflection, such questions. I believe that beyond the specific technical skill sets you are looking, there are some other specific characteristics you

Keynote Stephen Wynkoop Demo: Capture perfmon counters to binary logs and at the same time capture SQL Profiler. Then you can load both into profiler and see both at the same time. Great for troubleshooting what might be causing a problem or what is happening at a particular point in time

Are you a tattler? No, not the kind mom told you not to be, but rather the Tattler application from Phase2 Technology

So the SSWUG Fall 2009 Virtual Conference begins today. I’ve setup at home to hibernate for hours watching the live and pre-recorded sessions on a wide range of SQL Server and business intelligence topics. An extra LCD monitor brought home, the trackball mouse from the office, headphones and webcam. The kitchen is stocked for my