This is my current macro rig. Body's a D70, and the lens alternates between a Sigma 180 (as seen here) and a Sigma 105. I usually mate whichever lens is mounted to a Kenko extension tube, either the 36mm or the 36 and 20.
The bracket is a hightly recommended "CB Jr". CB is short for Custom Brackets, and Jr as in Junior. Well-built and great for macro stuff; it provides adjustable height for the flash, can rotate the flash bracket 180 degreees for vertical composition, and is designed so that the operator can access lens and body while shooting. it was purchased from B&H.
The synch cord is the older SC-17, which provides full dedication to the D70 and is cheaper than the SC-28. You can find the SC-17 on eBay.
The silver thing directly under the flash unit is an old lightweight ballhead, perfect for setting the necessary angle for flash illumination. It's a "Bilora" brand. Actually, a very nice product, locking easily with little effort.
The flash is the nearly legendary SB-800 attached to a Lumiquest Lightbox diffuser. This diffuser softens the light nicely and provides a natural soft shadow from above.