(Joe Foley) Can the computer be a helpful business intelligence assistant rather than a guard protecting a massive collection of data? Can it answer the constant stream of both important and small questions that are faced in every business day, by every business person? The answer is that your
Other News
Army looks to IBM to halt paperwork
(Eric Auchard) The U.S. Army has enlisted IBM and a handful of other companies to create an automated record-keeping system that ends the need for electronic forms to be printed out, signed and delivered up the military service’s chain of command.
Derby database development with Apache Ant
(James M. Snell) The open source Derby database engine provides developers with a powerful new tool for lightweight database development. Derby databases are file system based and portable across different types of systems. Because of this, a common strategy is to create databases at development
Data Access with Microsoft Application Blocks
(Keenan A. Newton) Microsoft recently launched the Microsoft Patterns and Practices section of their Web site, offering several complete architectural and design application blocks, complete with source code, that you can use in your .NET applications.
Fascinating Query Tricks
(Danny Lesandrini) I love writing VBA code but I am convinced that, many times what I am trying to accomplish can be done in a more efficient, graceful and elegant way using SQL queries. Over the last few months, I have tried to develop my applications with this in mind. The following article is a
Working XML: UML, XMI, and code generation, Part 4
(Benoît Marchal) In this final article in his series on UML and XML, the author wraps up the technique. He discusses the need to simplify the model by burying some of the logic in the XSLT stylesheet. He also points out several common pitfalls.
Customized Output Labels
(Leo Peysakhovich) Last month I had an interesting task to deal with. It had to do with the way our business views the data. In many cases my company is using MS Access as the way to access the data from tables and then save user filtered, ordered, or grouped reports in various formats. I am not say
SQL Server 2000 – Merge Replication Step by step Procedure
(D J Nagendra) Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of the database and share the copy with different users so that they can make changes to their local copy of database and later synchronize the changes to the s
Joining Derived Tables
(Rudy Limeback) have three tables — table1, table2, and table3. All three contain information on a daily basis. I have written SQL statements to summarize the information of each table based on certain columns in the respective tables. Can I write an SQL statement where in it should perform th
HOW TO: Install MySQL as Part of a UNIX-to-Windows Migration
MySQL is an open-source relational database management system (RDBMS) that supports the SQL query language. MySQL is available for most UNIX and Windows platforms, and it is typically used in combination with languages such as Perl, Python, and PHP. This article describes how to install MySQL on Win