Learn how to acquire data or parameter values required during the execution of a report from a database query, using Data-Driven Subscription in SQL Server Reporting Services (SSRS).
The MySQL LIKE operator is great for finding words or phrases within strings, but you'll be happy to learn that it provides a form of advanced pattern matching based on UNIX utilities.
There are many times as a database developer and administrator that you'll want to know what entities are being excluded from a straight table join; fortunately, MySQL gives you not one but three options.
Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can make full table scans and range scans more efficient.
Converting between MySQL Date and Time Formats03/09
MySQL's thorough and flexible date handling allows you to switch between internal and external date/time formats with relative ease.
MySQL InnoDB File Formats03/02
Versions of MySQL now come equipped with the powerful and stable InnoDB plugin. We will cover file formats in this article, a very important part of the InnoDB plugin feature set.
Using MySQL's Analysis Tools to Improve Query Performance02/18
One nice feature added to the EXPLAIN statement in MySQL 4.1 is the EXTENDED keyword which provides you with some helpful additional information on query optimization.