SQL Server
- SQL Server 2005 useful info
(contains several links in Post #4, including the Free version of SQL Server 2005, tools for it, and the help files [Books Online])
- How can I configure SQL Server 2005 to allow remote connections?
See this MS KB article
- How can I use Windows Authentication with a Pocket PC?
- How can I import/export data from other database systems/files?
See this thread and this thread from our Office Development FAQ's, which use Excel files as an example (the same methods can be used for other sources/targets).
- How can I write a Stored Procedure?
See this tutorial
- How can I debug a Stored Procedure?
See this tutorial
- How can I enable connections from other computers?
See this MS KB article
- How can I create/use a CLR (.Net code) function?
See Creating A CLR Function (SQL SERVER 2005) in our Tutorials forum.
- ...For help with SQL statements, see the articles in the SQL section of this page.
MS Access
- If my program uses an Access database, do my users need Access installed?
- How do I use an Access database from multiple computers (in a network)?
- How can I use an MS Access database which is stored on a Web server?
See How to access remote MS Access database in the CodeBank forum.
- ...For help with SQL statements, see the articles in the SQL section of this page.
- ...More articles about Access (including use from VB code) can be found in the Access section of our Office Development FAQ's
(includes items such as 'How do I perform a Compact & Repair on my database?')
Oracle
- Returning a recordset from an Oracle SP, and Testing a SP from SQL*Plus
- ...For help with SQL statements, see the articles in the SQL section of this page.
MySQL
- Where can I get the .Net provider for MySQL?
See .Net connector on the MySQL web site, documentation can be found here.
- ...For help with SQL statements, see the articles in the SQL section of this page.
