I'm currently working on my first SQL Server project with VFP as front end.
It's a little bit different then I used to with native DBF, but nevertheless, when you got the hang of it, it works great.
You can use REMOTE VIEWS (via a connection) for the most part, or use SQL PASS THROUGH functions with SQLEXEC() for direct access to the server.
Both work amazingly fast.
But remember, native DBF is table/record-based and commands like GOTO BOTTOM work very fast and don't generate traffic, but SQL Server is Set-based, so you have to parameterize big table-views to prevent huge networkload.