This manual was compiled by Project A Web Development as a project supported by Jim Teece. It was written by Ethan Townsend as a documented means of migrating our ADO ASP application, SIB (Site­in­a­box), from Microsoft SQL Server 7.0 to an open source database. SIB is a large database­ driven application that includes many views, stored procedures, and complex SQL executed from the ASP pages.
Read the rest of this entry »

• 0 Comments

Microsoft SQL Server 2008 introduces two new compression features (available in Enterprise and Developer editions) that are of interest to users with large databases. Data compression applies to individual tables and indexes within a database and comes in two options: ROW and PAGE. Backup compression is a new option when backing up a database to external storage. Both compression techniques can be used to reduce the amount of online storage required for databases and their backups.
Read the rest of this entry »

• 0 Comments

The Forest Service has the capability to access data residing in Oracle and other databases with Office 2000. Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The purpose of this paper is to explain how to configure a PC for the linkage and illustrate how to make the connection. The primary benefit of using Access to manipulate data is its rich interface to quickly design queries, reports, and forms for data entry.
Read the rest of this entry »

• 0 Comments

Microsoft uses SAP as its primary Enterprise Resource Planning software. The Microsoft Enterprise Application Services Group depends on a variety of SAP systems for online transaction processing, batch processing and analytical reporting.
Read the rest of this entry »

• 0 Comments

The purpose of this white paper is to demonstrate how to use the ODBC driver plugin with Microsoft® Access® database files. This allows LISTSERV® Maestro to use Access databases as a data source, making it possible to have LISTSERV Maestro extract data directly from an Access database [3].
Read the rest of this entry »

• 0 Comments

This paper will examine the differences between the security posture of Microsoft’s SQL Server and Oracle’s RDBMS based upon flaws reported by external security researchers and since fixed by the vendor in question. Only flaws affecting the database server software itself have been considered in compiling this data so issues that affect, for example, Oracle Application Server have not been included. The sources of information used whilst compiling the data that forms the basis of this document include:
Read the rest of this entry »

• 0 Comments

The health of databases is of critical importance to business managers, application owners and enterprise IT teams. The life of an organization is literally represented inside its database servers. Take away the ability to reliably run enterprise applications or complete customer transactions and you will watch the business come to a standstill. One quantifiable indicator of risk to the enterprise of business disruption, or leakage of confidential data, is the number of vulnerabilities that exist in the technical infrastructure. There is a correlation between the number of vulnerabilities and the number of undiscovered vulnerabilities as well as the risk to the enterprise of an exploit successfully launched against the vulnerable database. It is very clear that the more vulnerabilities that exist, the more likely it is that an attack will be successful.
Read the rest of this entry »

• 0 Comments

The customizable PHP script Generic HTML Form Processor is intended to assist researchers and students in quickly setting up surveys and experiments that can be administered via the Web. This script relieves researchers from the burdens of writing new cGi scripts and building databases for each Web study. Generic HTML Form Processor processes any syntactically correct HTML form input and saves it into a dynamically created open-source database. We describe five modes for usage of the script that allow increasing functionality but require increasing levels of knowledge of PHP and Web servers: The first two modes require no previous knowledge, and the fifth requires PHP programming expertise. use of Generic HTML Form Processor is free for academic purposes, and its Web address is www.goeritz.net/brmic.
Read the rest of this entry »

• 0 Comments