(Seth Grimes) Business intelligence (BI) creates competitive advantage for organizations of all sizes and in all industries. It is an important business tool, a means of exploiting data previously locked in operational databases. (pdf)

(Max Hetrick) Whether you realize it or not, you’ve been exposed to some form of open-source software in your travels. With the popularity of vendors embedding open-source solutions into everything from cellular phones and routers to Web applications and full-blown software installations for running

(Robin Schumacher) In my first article on partitioning, I demonstrated that you can get some pretty impressive performance benefits when you properly design partitioned tables to match the SQL queries that are routinely shot across the bow of your database server. I’d now like to continue in that ve

(Matija) If you are not so confident with programming languages and web technologies you may be wondering what SQL stands for. Well, it’s an acronym for Structured Query Language (pronounced “sequel”). It’s “de facto” the standard language to access and manipulate data in databases.

(James Yaple) In the summer of 2003, Dr. Neil Gunther used several CMG MeasureIT articles to introduce what he called “Guerrilla Capacity Planning.” Since many of the factors involved in developing a performance model are unknown or uncertain, an accurate model can be difficult to construct. A “gue

(defwebserver) I created this example because I could not find a simple explanation for using MySQL 5 with ObjectDataSources in ASP.NET 2.0.

(Jon Stephens and Chad Russell) Looking even further ahead, we expect continued improvements in MySQL 5.1, with the possible addition of another major feature that so far hasn’t been implemented yet. This is the implementation of triggers. Triggers are almost certain to make an appearance in MySQL 5

(Jan Stafford) Open source software developers offer freebies, and the reward they reap is input that spurs advances in their creations. When a proprietary vendor offers free software, however, there is usually a hook inside, says MySQL AB CEO Marten Mickos. So, he says, look carefully before you bi

(Alejandro Gervasio) This is the article that you’ve been waiting for! Welcome to the last part of the series “Separating logic from presentation.” In three tutorials, this series teaches you how to develop an expandable template processor class using PHP 5, which exposes some useful features, such

(Ian Gilfillan) In May 2003, I wrote an article entitled MySQL–Yesterday’s Toy, Tomorrow’s Contender. I followed it up a year later with MySQL, Still tomorrow’s contender? Two years have now passed, and, since it is May once again, I thought it is time to follow up and see where MySQL stands today.