Arthur Fuller Arthur Fuller
Arthur Fuller has been developing database applications for more than 20 years. He frequently works with Access ADPs, Microsoft SQL 2000 and 2005, MySQL, and .NET.
The Database From Hell
by Arthur Fuller | 19 February 2008 |  19 comments |
In which Arthur Fuller comes to the aid of a friend who is doing his best to administer The Database From Hell, and manages to set up a reasonable test database with which to solve some of the headaches that only a 65 million row, 600 column, table can cause. Read more...
Database Design: A Point in Time Architecture
by Arthur Fuller | 22 February 2007 |  41 comments |
In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller... Read more...
Intelligent Database Design Using Hash Keys
by Arthur Fuller | 17 February 2006 |  11 comments |
Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows?... Read more...
A case for canned SQL
by Arthur Fuller | 18 January 2006 |  6 comments |
Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many of the proponents of the dynamic argument are web or Access developers, or developers of some other front end. Arthur takes another look... Read more...
FUD (fear, uncertainty, doubt)
by Arthur Fuller | 10 October 2005 |  3 comments |
FUD (fear, uncertainty, doubt): Where does Access fit in Microsoft’s future? And why is that question important? Read more...
Software patents - stupid or insane?
by Arthur Fuller | 22 August 2005 |  3 comments |
Arthur Fuller considers software patents to be both stupid and insane, is it time for a review of patent law? Read more...
Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk