Recently Posted Videos

These are just the first of many planned video tutorials on the multithreaded, multi-user SQL database management system MySQL. These particular videos require a little more background knowledge from the viewer, in terms of overall php development experience. In the following video I go over some basic MySQL theory.

Summary Guy L. Steele heads the Sun Programming Language Research Group. He's held positions at Carnegie-Mellon University, Tartan Laboratories, and Thinking Machines Corporation and is the author or co-author of several books on languages (Common Lisp, C, High Performance Fortran, the Java Language Specification) as well as "The Hacker's Dictionary" (also known on the Internet as the...

Subtotals worked great all week, but today we encounter a gotcha - for some reason, the subtotals are COUNTING our revenue cells instead of summing them. Episode 242 reveals while Excel does this on somedays and not on others.

Today, I am appearing at the IMA Continuing Education Workshop in Kent Ohio. There will be a few hundred serious accountants in that room with me today, and most of them will know this trick. Today, we have a spreadsheet where someone added manual subtotals to the worksheet. Rather than building a formula to point just to the totals, there is a cool trick that uses a bit of algebra to solve the...

After yesterday's podcast, I am sure you tried to copy the manager view to a new file and found out that it did not work. There is an obscure method for copying just this view. Episode 240 shows you the way in the book plus a bonus method that is much faster.

After using the Subtotals function, look for three new buttons called the Group & Outline buttons. Use these tiny buttons to produce quick reports for your manager. Episode 239 will show you how.

An AMAZING trick for adding subtotals to a dataset. Episode 238 shows you how.

Brian Chapados shows how to install and work with the latest JRuby release.

Summary SpringSource CTO and AspectJ project lead Adrian Colyer discusses where Aspect-Oriented Programming (AOP) should be used, practical applications of AOP in enterprise situations such as Hibernate exception translation and automatic operation retry on nonfatal exceptions, and AOP mechanisms in Spring 2.5. Bio Adrian Colyer is the Chief Technology Officer for SpringSource (formerly Interfa...

Redeye is probably the most common flaw in digital photography. In this episode we take a look at how to quickly eliminate this problem by using channels in Photoshop.