Hi Mark,
I'm getting to SQL Server for the first time now, too, and found a source of good information for people using VFP:
"Client-Server Applications with Visual FoxPro and SQL Server", by Chuck Urwiler, Gary DeWitt, Mike Levy and Leslie Koorhan (fellows you'll find here in UT).
I already ordered (and received) my copy <s>
You may check
http://www.hentzenwerke.com/catalogavailability/csvfp.htm if you wish.
Hope it helps,
Fernando