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

Unisys and Microsoft have dispelled the perception that for high performance ETL, the only alternative is a UNIX-based solution. With SQL Server 2005 Integration Services, Microsoft and Unisys deliver an optimized ETL solution that will support even the most demanding enterprise Business Intelligence (BI) initiatives. They conducted a series of real ETL (Extraction, Transformation and Load) tests with Microsoft SQL Server 2005 Integration Services (SSIS, formerly known as DTS). Performance tests compared throughput, scalability and performance on both 32- and 64-bit processor configurations on a Unisys ES7000. SSIS demonstrated parallelism and the ability to utilize all available CPUs in multiple aggregation, parallel lookup and transformation testing.
Read the rest of this entry »

• 0 Comments

This tutorial demonstrates how to import an Excel file into an Access database. You can also follow these same steps to import other data tables into Access, such as dbf files or txt files, with some minor variation. This document uses some standard database terminology, referring to columns as fields and rows as records.
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

This tutorial demonstrates how to import an ESRI shapefile into an Access database using the ArcCatalog. Microsoft Access databases are compatible with ArcGIS, as tables within Access databases can be directly accessed by ArcGIS and added to ArcMap. When geographic boundary files are exported to an Access database, the database can then serve as a personal geodatabase: a container for organizing and storing multiple geographic boundary files and data tables. (see the How to Import Data into Microsoft Access tutorial for importing data tables into Access).
Read the rest of this entry »

• 0 Comments

OpenOffice.org (OOo) is able to read and write from a wide variety of databases, as long as they support one of the standard interface specifications such as ODBC or JDBC. Fortunately, Microsoft Access (MS-Access) supports ODBC. This HOW-TO takes you step by step through the process of linking OOo to MS-Access using ODBC.
Read the rest of this entry »

• 0 Comments

A database manager is a computer program for storing information in an easily retrievable form. It is used mainly to store text and numbers (for example, the Library catalogue, which includes the author, title, class number and accession number for each book). Most modern database managers also allow the storage of other types of information such as dates, hyperlinks, pictures and sounds. As well as being able to store data, a database allows you to select information quickly and easily (for example, a list of the books written by a particular author or those on a certain subject). Finally, it may allow you to produce printed summaries (reports) of the information selected.
Read the rest of this entry »

• 0 Comments

Borland ® InterBase ® is a powerful, SQL-compliant database that is often considered for embedding in applications and for application-specific uses. Savvy developers and application architects who take the time to examine InterBase closely find that it offers substantial advantages over Microsoft® SQL Server™.
Read the rest of this entry »

• 0 Comments