How To Create an Adobe PDF File From an Access Database
Sunday May 28, 2006
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.
Oracle Certified Professional
Sunday May 28, 2006
The Oracle Certified Professional credential provides database professionals a chance to prove their mettle when it comes to Oracle database administration or development. Until recently, the Oracle certification program was ... Read More
SQL Server 2005 SP1 Released
Sunday May 28, 2006
If you're running Microsoft SQL Server 2005 in your enterprise, you should be sure to download Service Pack 1 if you haven't done so already. This maintenance release adds ... Read More
Book Review: Access Database Design and Programming
Sunday May 21, 2006
O'Reilly is well known within the Unix and web development communities for publishing some of the best books on the market today. Their famous "In a Nutshell" series fills the ... Read More
ACID Model
Sunday May 21, 2006
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive to achieve: atomicity, ... Read More
SA Rights on SQL Server
Sunday May 21, 2006
In a recent forum posting, BATMAN2282 wrote:
"An outside vendor has developed a web based software application that my company is looking at using. They are telling us that they ... Read More
Summarizing Data with CUBE and ROLLUP
Sunday May 14, 2006
Looking for a quick, efficient way to summarize the data stored in your database? The SQL ROLLUP and CUBE commands offer a valuable tool for gaining some quick and ... Read More
Stored Procedures and Large Quantities of Data
Sunday May 14, 2006
A recent forum discussion included the following question:
"I have heard that, when a big amount of data flow caused by a query, then using stored procedure not a correct option. ... Read More
SQL Fundamentals
Sunday May 14, 2006
The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major ... Read More
Data Mining: An Introduction
Sunday May 7, 2006
By this point in time, you've probably heard a good deal about data mining -- the database industry's latest buzzword. What's this trend all about? To use a simple analogy, ... Read More
MySQL 5 Overview
Sunday May 7, 2006
This major new release of the popular open-source database packs in quite a few new features that bring MySQL into the league of full-featured relational databases. In this article, we’ll ... Read More
Can't Drop a SQL Server Table
Sunday May 7, 2006
In a recent forum posting, Dawn wrote:
"I copied a table from Access to SQL Server 2000 Enterprise Manager using DTS Import/Export Wizard. After about 3 minutes, I cancelled the ... Read More