>I'm looking for a good resource for explaining the basics along with examples for connecting VFP6 and above with SQL Server. Any ideas?

Many ideas :-)

Here you can find a few books for this http://www.hentzenwerke.com/catalog/zcatalog.htm

In download section of UT there are a few examples too

If you will use VFP8/9 you can use newest CursorAdaptor class for this.

etc.