mySQL is a robust Relational Database Management System. Currently it runs under Linux, Windows, OS2, and several other operating systems. Aside from the fact that it is free (yes, you heard right), mySQL has become the database management system of choice for many small and large solutions (Yahoo has been known to use mySQL).
This tutorial teaches how to install mySQL under Linux.
The purpose of this paper is to enable the developer of Microsoft® Access-based applications to use and understand fully the Microsoft Access Upsizing Tools. The developer should be able to use the tools to facilitate client/server development between Microsoft Access and Microsoft SQL Server™. The paper will discuss design strategies for using the tool optimally in the development process.
In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Procedures. Most of the time we use ASP pages, we use them to retrieve or manipulate records in the database. These database connections are resource heavy and every query takes time on part of the server. Thus we should try to make use of everything possible to optimize and speedup database access as much as possible.