In addition to Guru's Guide (which is excellent) I'd recommend Murach's
SQL Server 2005 for Developers As a trainer as well as a developer I've been very impressed by the organization and method of all the Murach books. Amazon has them or you can try murach.com
>Is there a very basic learning resource for SQL Server? I have been using free tables since FPD and have no idea how to even use Views or Database Containers so I need to start from the very bottom. I believe there is a low end version of SQL Server (like an Express version) I could practice on without needing to set up a server.
>I also make a lot of use of cursors eg; working at the client end my users work in a cursor then at save I lock all the files and write the data, pretty basic stuff, but it works well and is very fast.
>I feel that I may need to move to the real world of Client Server. BTW I am not a contract developer and as such have not need for RAD, my accounting software has taken years to build and has a good following of regular clients. I feel the security of SQL might be the way to go, it will also give me the opportunity to build thin client apps like smartphones etc.
>TIA, John
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.