SQL server

Home :: SQL Server

Many of you will have begun your web development using Microsoft Access as your backend database. Access is widely supported, user friendly and (perhaps best of all) cheap!

However, as your visitor numbers increase you inevitably follow the logical path and upgrade to SQL-server. I will therefore devote a couple of pages in this section to that perilous journey.

SQL server is a different world to Access. Typically SQL server is deployed on an entirely diferent machine from your web server (so your ISP saves on their licensing). This opens up a can of worms because you now have data and commands being swapped over your ISP's local area network. This requires an entirely different approach to ADO. You must optimize your application to this environment.

The rest of this page is hidden, you must be a member to view it

To become a member and get immediate access to the course please join here Free!

Already Enrolled? please click here to Login