I just finished re-reading that trilogy. Simon Hawke, The Reluctant Sorcerer (1992), The Inadequate Adept (1993), and The Ambivalent Magician (1996).
Let's see, the dwarf is a leprechaun, the knight is a nearly blind bandit that 'Brewster Doc' makes lenses for, and aluminum is the Philosopher's Stone.
