Home
Schedule
Books
Articles
Newsletters
Speaking Engagements
SQL Puzzles
Courses available
Database Resources
E-mail
INTELLIGENT ENTERPRISE: (CMP, nee Miller-Freeman) combination of DBMS and DATABASE PROGRAMMING & DESIGN into one magazine. Credits here include web site articles. Column is simply called "Celko", based on my name recognition.
2004 Dec 04: CSI: Data Warehouse
2004 Nov 13: Closed Loop
2004 Oct 16: Enough Truth?; Data Quality; Correction
2004 Sep 04: A Question of Quality
2004 Jun 12: Stepping Up to the Plate
2004 Mar 20: Are We There Yet?
2003 Dec 10: Code Confessions
2003 Oct 30: The Alphabet Achievement
2003 Sep 17: Commodities and Identifiers
2003 Aug 10: Identifiers and Barbarians
2003 Apr 22: I Will Never Have To Port This Code
2003 Mar 20: Keys and History
2003 Mar 03: Net Present Value Calculations
2003 Feb 01: Edsger Dijkstra: a brief tribute 
2002 Nov 15: PC Promises
2002 Oct 08: Knowing the Difference
2002 Sep 03: Keeping Up With the Merkles
2002 Jul 26: Modeling Data Management
2002 Jun 13: Cloning Confusion
2002 May 09: The Road to Dystopia
2002 Mar 28: What's in a Name?
2002 Feb 21: Breaking Tradition
2002 Jan 14: This Perfect Day
2001 Dec 05: Spontaneous Order
2001 Nov 12: No News Is Good News
2001 Sep 18: Layoff Lowdown
2001 Aug 10: Illegal Rhythms
2001 May 24: What Time Is It?
2001 Apr 16: Making IT Sense in the Snow
2001 Mar 27: New Year's Revelations
2001 Mar 08: Mental Model Meltdown
2001 Jan 30: The Bored and the Restless
2001 Jan 01: Hollywood Couples
2000 Dec 05: Ten Things I Hate About You
2000 Nov 10: Desperately Seeking Disk Space
2000 Oct 20: Trees in SQL
2000 Sep 29: SMOP
2000 Sep 08: Playing the Name Game
2000 Aug 18: Smarter in Scandinavia
2000 Jul 17: Dated Material
2000 Jun 26: Look Back in Anger
2000 Jun 05: XML Quirks
2000 May 15: On the Trigger
2000 Apr 28: Tools and Nostalgia
2000 Apr 10: Puzzle Time
2000 Oct 10: Cool War
2000 Mar 01: Tapes and Records
2000 Feb 09: Nordic Nerds and Bugs
2000 Jan 20: Okay, Elves, Give Me a Damage Report!
2000 Jan 01: The Day After New Year's Day
1999 Dec 21: Auxiliary Angst
1999 Dec 07: The Hazards of Convenience
1999 Nov 16: Small Companies, SQL Tips, and Puzzles
1999 Oct 26: Scalability
1999 Oct 05: Online Censorship
1999 Sep 14: The Miracle of Bad Screen Design
1999 Aug 24: Partially Baked Ideas
1999 Aug 03: Not Your Father's Education
1999 Jul 13: Linux Buoyed by an Ocean of Support
1999 Jun 22: Victory Is Part Serendipity
1999 Jun 01: Linux Buoyed by an Ocean of Support
1999 May 11: Battle of Bits
1999 Apr 20: Ah, Swede Memories
1999 Mar 30: Gone But Not Forgotten
1999 Mar 09: Controlling Information Flow
1999 Feb 16: The Laws of Systems
1999 Jan 26: International Correlations
1999 Jan 05: Commerce in the Real World
1998 Oct 1998: Spying on Your Children, Employees, and Competitors
1998 Dec 1998: Notes from the Underground
1998 Nov 1998: Compare this
DB/M: (Array Publications, The Netherlands) Newsstand magazine on databases for programmers in Dutch, which I do not speak. The magazine appears nine times a year. I wrote a SQL programming tips column in the years 2002, 2001, and 2000 under the title "SELECT * FROM Atlanta" and "SELECT * FROM Austin". 
2000 #1 Databases en het Web; een wereld van verschil
2000 #2 Denken in SQL
2000 #3 (May) Afleren loont
2000 #4 De berekende kolom als breinbreker
2000 #5 (Sep) De tijd doden (Killing time)
2000 #6 (Oct) Een oude identiteitscrisis (An old identity crisis)
2000 #7 (Nov) Goede tijden, slechte tijden (Good times, bad times)
2000 #8 (Dec) Query on Elm Street
2001 #2 (Apr) Pluk de dagen (Those were the days)
2001 #3 (May) Relationele deling (Relational split)
2001 #4 (Jun) Getructe JOIN's en ander SQL-spul
2001 #6 (Oct) Op pad met SQL
2001 #7 (Nov) Tabellen vergelijken
2001 #8 (Dec) Wie is de baas?
2001 #1 (Feb) Denken in sets
2002 #2 (Mar) Denken in aggregaten
2002 #3 (May) Log-tabel

INTELLIGENT ENTERPRISE: (Miller-Freeman). This is the combination of the old DBMS and DATABASE PROGRAMMING & DESIGN into one magazine. Credits here include web site articles.

1998 Oct (Celko): Spying on your Children, Employees and Competitors

1998 Nov (Celko): Compare this

1998 Dec (Celko): Notes from the Underground

1998 Dec (Celko): Year 2000 Project

1999 Jan 05 (Celko): E-Commerce in the Real World

1999 Jan 26 (Celko): International Correlations

1999 Jan (Celko): Note from the Underground

1999 Feb 16 (Celko): The Laws of Systems

1999 Mar 09 (Celko): Controlling Information Flow

1999 Mar 30 (Celko): Gone but not Forgotten

1999 Apr 20 (Celko): Ah, Swede Memories

1999 May 11 (Celko): Battle of the Bits

1999 Jun 01 (Celko): Linux Buoyed by an Ocean of Support

1999 Jun 22 (Celko): Victory Is Part Serendipity

1999 Jul 13 (Celko): Linux Buoyed by an Ocean of Support

1999 Aug 03 (Celko): Not Your Father's Education

1999 Sep 14 (Celko): The Miracle of Bad Screen Design

1999 Oct 26 (Celko): What Tarzan could teach us

1999 Nov 16 (Celko): Small Companies, SQL Tips and Puzzles

1999 Dec 07 (Celko): The Hazards of Convenience

1999 Dec 21 (Celko): Auxiliary Tables

DBMS: (Miller-Freeman, nee M&T Publishing) Newsstand magazine on databases for programmers. Technical editor in 1992. Regular column named "SQL Explorer" was renamed "SQL for Smarties". DBMS merged with DATABASE PROGRAMMING & DESIGN after 1998 September to become INTELLIGENT ENTERPRISE.

1989 Nov Parts Explosion in SQL

1992 Mar T-joins in SQL

1992 May (SQL Explorer): SQL Coverage

1992 May Single-set Operations in SQL

1992 Jun (SQL Explorer): News from DBExpo

1992 Jul (SQL Explorer): Card Tricks

1992 Aug Join Methods in SQL

1992 Aug (sidebar): A Hashing Primer

1992 Aug (SQL Explorer): Borland in the Desert

1992 Sep (SQL Explorer): ANSI X3H2 and Database World

1992 Sep White Paper: Introduction to Concurrency Control

1992 Oct (SQL Explorer): Northern Exposure

1992 Nov (SQL Explorer): Voting Systems

1992 Dec (SQL Explorer): A Look at Views

1993 Jan (SQL Explorer): An Xbase Range War

1993 Feb (SQL Explorer): By the Numbers

1993 Mar (SQL Explorer): Much Ado about Nothingness

1993 Apr (SQL Explorer): More about Nothingness

1993 May (SQL Explorer): ANSI X3H2 in Salt Lake City

1993 Jun (SQL Explorer): Blizzards, Beer and Brain Damage

1993 Jul (SQL Explorer): Models, Divisors and Logic

1993 Aug (SQL Explorer): Lots of Trips and Traps

1993 Sep (SQL Explorer): Blind in Boston

1993 Oct (SQL Explorer): Fast Times at Rapid City

1993 Nov (SQL Explorer): Home Alone

1993 Dec (SQL Explorer): Shuffle off to Buffalo

1994 Jan (SQL Explorer): Textbase versus Database

1994 Jan Learning Division in Elementary School

1994 Feb (SQL Explorer): Innumeracy Revisited

1994 Mar (SQL Explorer): Down the Mississippi

1994 Apr (SQL Explorer): SQL 101: Basic Table Design I

1994 Apr (with Doug Hubbard) The Road to Normalization

1994 May (SQL Explorer): SQL 101: Part Deux

1994 Jun (SQL Explorer): Computing with the Sharks

1994 Jul (SQL Explorer): SQL in the City of Steel

1994 Aug (SQL Explorer): Traveling on the Trade Show Circuit

1994 Sep (SQL Explorer): The Great Key Debate

1994 Oct (SQL Explorer): The Price of Fame and Glory

1994 Nov (SQL Explorer): Making the Most of Marketing

1994 Dec (SQL Explorer): Publishing at Your Fingertips

1995 Jan (SQL Explorer): Three Little SQLs

1995 Feb (SQL Explorer): On the Road Again

1995 Mar (SQL Explorer): Database in the Windy City

1995 Apr (SQL Explorer): How to Deal with Duplicates

1995 Apr Celko's SQL Puzzles (advertising insert)

1995 May (SQL Explorer): ANSI Work at Jackson Hole

1995 Jun (SQL Explorer): The World of Software

1995 Jul (SQL Explorer): Freaknik meets Geeknik

1995 Aug (SQL Explorer): Decisions, Decisions

1995 Sep (SQL Explorer): Whatever Happened to Xbase?

1995 Oct (SQL Explorer): SQL in Sleepytown

1995 Nov (SQL Explorer): Dragons, Trees and Webs

1995 Dec (SQL Explorer): Real Problems in a Real World

1996 Jan (SQL Explorer): A Little R&R

1996 Feb (SQL Explorer): Old Friends and New Problems

1996 Mar (SQL Explorer): A Look at SQL Trees

1996 Apr (SQL for Smarties): SQL Lessons

1996 May (SQL for Smarties): Non Traditional Databases

1996 Jun (SQL for Smarties): When Good Data Goes Bad

1996 Jul (SQL for Smarties): Soothsayers for Oracle

1996 Aug (SQL for Smarties): Everything You Know Is Wrong

1996 Sep (SQL for Smarties): Databases on the Net

1996 Oct (SQL for Smarties): Going to Extremes

1996 Oct Understanding and Managing Textbases

1996 Nov (SQL for Smarties): Summing with SQL

1996 Dec (SQL for Smarties): Public and Private Data

1997 Jan (SQL for Smarties): The Future of SQL Programming

1997 Feb (SQL for Smarties): Web Searching and Conjugacy

1997 Mar (SQL for Smarties): Random Data and Observations

1997 Apr (SQL for Smarties): Graphs in SQL

1997 May (SQL for Smarties): Parlez-vous SQL?

1997 Jun (SQL for Smarties): Database Insecurity

1997 Jul (SQL for Smarties): Year 2000: Threat or Menace?

1997 Aug (SQL for Smarties): Celko's World Tour

1997 Sep (SQL for Smarties): Underwhelmed by New Technology

1997 Oct (SQL for Smarties): Doing Bad Things Well - Part I

1997 Nov (SQL for Smarties): Doing Bad Things Well - Part II

1997 Dec (SQL for Smarties): SQL-3 Christmas Shopping List

1998 Jan (SQL for Smarties): Making Things Secure

1998 Feb (SQL for Smarties): The Terrors of Translation Tables

1998 Mar (SQL for Smarties): Synchronizing Data Access

1998 Apr (SQL for Smarties): Access Denied

1998 May (SQL for Smarties): Tooling Around

1998 Jun (SQL for Smarties): Call Me an Optimist

1998 Jul (SQL for Smarties): Moving on

1998 Aug (SQL for Smarties): Happier Marriages through Math

1998 Sep (SQL for Smarties): Yet Another SQL Sequel

BOXES & ARROWS: Subscription magazine for DBA's and systems analysts. Wrote a puzzle column of SQL problems until the magazine folded.

1989 Oct Crosstabs in SQL

1989 Nov Bookscout Problem

1990 Mar Tin Card Problem

1990 May Employment Agency Problem

1990 Jun Pascal's Normalization Problem

1990 Sep Sorting Puzzle

1990 Oct ZIP Code Puzzle

1990 Nov Contains Puzzle

1990 Dec Outer Join Puzzle

1991 Jan Parts Explosion Puzzle

1991 Feb Irish Feast Puzzle

1991 Mar Scripts Puzzle

1991 Apr Intra-Tuple totals Puzzle

1991 May Dr. Codd's T-Joins

1991 Jun Partitioning Joins Puzzle

1991 Jul Top Three Salaries Puzzle

1991 Aug Teachers & Classes Puzzle

1991 Sep Parts Explosion II Puzzle

1991 Oct Available Seats Puzzle

1991 Nov Gaps in employment Puzzle

1991 Dec Update Tapes Puzzle

1992 Jan Eighty-twenty Puzzle

1992 Feb Flight Normalization

1992 Mar Median Puzzle

1992 Apr Car Dealer Puzzle

1992 May Mode weights Puzzle

1992 Jun Picking the N-th item

1992 Jul ALL Predicate Puzzle

1992 Aug Updating Salaries Puzzle

1992 Sep Business Days Puzzle

1992 Oct Answer to Settling Business Days

1992 Nov Upcoming Birthdays Puzzle

1992 Dec Harvey's Report Puzzle

1993 Jan Counting Dependents

1993 Feb Industrial Directory

1993 Mar Trucking Timecards

1993 Apr Social Insecurity

1993 May The SQL Hunters

1993 Jun Corey's Puzzle

1993 Jul Sequential Numbers

1993 Aug Lowest Missing Values

1993 Sep Histogram

1993 Oct Posting Grades

1993 Nov Matrix Math

1993 Dec Hotel Days

1994 Jan Traffic

1994 Feb Stove Works

1994 Mar On the Correct Use of VIEWs

1994 Apr Counting fish

1994 May SQL Team Leaders

1994 Jun Taking Care of Customers

1994 Jul A Fishy Problem

1994 Aug Flupperware Salesman

1994 Sep Badges? We Got No Stinkin' Badges

1994 Oct SQL Student

1994 Nov Aging Report

1994 Dec Equal Sets

COMPUTING: (VNU Business Press, UK) A British weekly computer trade paper. Irregular column "Celko on Software" in the "Professions" section.

1993 Oct 21 (Celko on Software): No Good Deed...

1994 Jan 20 (Celko on Software): Mum's the password

1994 Feb 3 (Celko on Software): IT's New Age travails

1994 Feb 17 (Celko on Software): Quality out of control

1994 Mar 3 (Celko on Software): Among untrodden ways

1994 Mar 17 (Celko on Software): Big isn't always better

1994 Mar 31 (Celko on Software): The case in question

1994 Apr 14 (Celko on Software): The software shuffle

1994 Apr 28 (Celko on Software): When better can be worse

1994 May 12 (Celko on Software): Satisfied customers

1994 Jun 30 (Celko on Software): Surrogate lovers?

1994 Jul 21 (Celko on Software): Against intelligence

1994 Aug 11 (Celko on Software): Taxing your ingenuity

1994 Aug 25 (Celko on Software): A game of chance

1994 Sep 8 (Celko on Software): Tries and conversions

1994 Sep 29 (Celko on Software): Taking the King's Road to ruin?

1994 Oct 13 (Celko on Software): Looking into the future

1994 Nov 24 (Celko on Software): Going on the record

1994 Dec 01 (Celko on Software): The synonym labyrinth

1995 Jan 19 (Celko on Software): Preserving the Hierarchy

1995 Jan 26 (Celko on Software): Good things come in trees

1995 Feb 16 (Celko on Software): Keep taking the tabulations

1995 Apr 06 (Celko on Software): How do you pay for yours?

1996 Mar 21 (Celko on Software): Winning Formulas

1996 Apr 18 (Celko on Software): Maintain The Equilibrium

POWERBUILDER DEVELOPER'S JOURNAL: (Sys-Con Publications) WATCOM SQL column.

1994 Sep Deleting Duplicate Rows

1994 Oct Running Statistics

1994 Dec How SQL Gurus Write Queries

1995 Jul Transactions and Concurrency

1995 Sep Finding Subsets in a Table

1995 Nov Scalar Subquery Expressions

1995 Dec Scalar Subquery Expressions: Part II

1996 Jan Thinking in Sets

1996 Mar Quick SQL Tricks

1996 Apr Dr. Codd's T-Join

1996 May Employment Search

1996 Jun Key Makers

1996 Jul Referential Integrity Constraints

1996 Aug IF-THEN-ELSE Expressions

1996 Sep Report Problem

1996 Nov (see SYBASE DEVELOPER'S JOURNAL)

1996 Dec Pi in the Sky

1997 Feb Checking Cross References

1997 Mar The MOD() Squad

1997 Apr The LIST() aggregate function

1997 May Distinct and Group by

1997 Jul Quick SQL Tricks II

1998 Jul A Happy Median

SYBASE DEVELOPER'S JOURNAL: (Sys-Con Publications) Sybase SQL Anywhere supplement.

1996 Nov Dr. Codd's T-Join

1996 Nov Employment Search

COMPUTER WEEKLY: British controlled circulation tabloid

1983 Feb 02 Debugging with a few simple tools to help

1983 Feb 02 Heard the one about the mad program patcher?

1983 Apr 07 The Trouble with Storing Words in a Messy Language

1983 Apr 28 Lasagna Code is Tastier than Spaghetti Code

PC TECHNIQUES: (Coriolis Group) Took over the "Data Points" in 1993

1993 Jun/Jul (HAX 158) Rapid Pythagorean Calculations

1993 Aug/Sep (Data Points): SQL by the Numbers

1993 Oct/Nov (cover story) The State of SQL

1993 Oct/Nov (Tech Buyers Guide) SQL Products

1994 Dec/Jan (Data Points): Trees in SQL

INFORMATION SYSTEMS NEWS (now INFORMATION WEEK) biweekly tabloid newspaper from CMP Publishing, 100,000+ circulation. All articles ran in the software design and software management sections.

1980 Sep 08 Program Tests Basic "Rhino Algorithm"

1980 Oct 06 Text Tools Modernize Programming

1980 Oct 20 Pretty Printers, Style Checkers Aid Programming

1980 Nov 03 Data Dictionary - A Text Tool With Many Uses

1981 Nov 17 Preprocessors Provide Programming Control

1981 Jan 12 Graceful Rejection Part of Program Etiquette

1981 Feb 09 Father Time Software Secrets Allows Updating of Dates

1981 Mar 09 How to Test Programs by Data Path Exercise

1981 Mar 23 High Tech Solutions May be the Long Way Around

1981 Apr 20 Ways to Handle Periods of Less than One Year

1981 May 04 Procedure Tricks and Program Interfaces

1981 May 18 Procedure Options Mix Benefits & Liabilities

1981 Jun 01 BASIC - A Simple Language That's Often Misused

1981 Jun 29 VDT Mail Can Assist Move to "Paperless" Office

1981 Jul 27 Symbolic Systems Served by Data Flow Diagrams

1981 Aug 10 Report Programs - Often Used, Seldom Analyzed

1981 Sep 21 Encoding Systems - How to Handle Variables

1981 Oct 19 A Simple Model of Data Types for Queries

1981 Nov 02 10 Tips For Using Data Flow Diagrams More Efficiently

1981 Nov 16 Homemade Sorting Algorithms Have Advantages

1981 Nov 30 Sort Procedures can be Designed In-house

1982 Jan 11 Real Time Programmers Safer at High Speed

1982 Jan 25 Advent of Metric System Adds Program Woes

1982 Feb 22 Program Comments Often Can Befuddle The Unwary

1982 Mar 22 Assignment Statements Often Far From Simple

1982 Apr 05 Computer Fixes Spelling Faster Than A Scrawl

1982 Apr 19 Linked Lists Provide Direct Approach To Graphs

1982 May 03 Scheduling Jobs to Save Run Time Can Be Tricky

1982 May 17 So-called Software 'Science' Is More Like An Art

1982 May 31 DP Traffic Is Like Auto Traffic

1982 Jun 14 Structured Programs Can Present Layered Tangle

1982 Jul 26 A Nature Lover's guide to 3 Species of Input

1982 Aug 09 Structured Programs Ease 'Bug' Extermination

1982 Aug 25 Structured Programmers Whoop About Loops

1982 Aug 25 Lasagna Code Undercooked, Celko Admits

1982 Oct 18 "Mean Time" Measures Software Life-Cycles, Too

1982 Nov 01 Sampling Speeds Company Report Generation

1983 Jan 24 Figuring Data's Value A Puzzle to Professionals

1983 Mar 07 'Friendly' Systems Worthless If No User Interest

1983 Apr 04 Old Pro Outguns Hotshot Young Programmers

1983 May 30 Methods Solve Management Puzzle of Assigning Tasks

1983 Jun 27 When Centralizing DP, Expect the Unexpected

1983 Jul 25 Producing Work Speedily May Not Bring Reward

1983 Aug 08 Good English is Best Language

1983 Aug 25 The Software Managers Guide to Guesstimating

1983 Sep 19 Now Is The Time To Insert "Program Plugs"

1983 Oct 03 The Computer Dragon -- Too Many feet of Paper

1983 Oct 17 A Model Way To Make Big DP Decisions

1983 Nov 14 Problems Are Not Always Answered By Programming

1983 Nov 28 The Trick Is To Dole Out Just Enough Goodies

1983 Dec 12 Maintenance Remains, Despite Programming Gains

1984 Jan 09 To Save Time, Structured Programs Take Time

1984 Jan 23 'Knowledge-based' Systems Can Be Improvised

1984 Feb 06 Preventive Maintenance Keys On Diagnosis

1984 Mar 12 Technology May Bring Out OA's Darker Side

1984 Mar 19 "Misguided" Users Can Hinder IS Development

1984 Apr 02 Unix: Not An Operating System In The Usual Sense

1984 Apr 16 Data Compression Frees Up Data Base Space

1984 Apr 30 Standards Should Aim First At Consistency

1984 May 23 Computer Fear Hinders System Development

1984 Jul 09 IM's Buying Skills Can Shift To Interviewing

1984 Jul 25 International Programming Presents Problems

1984 Oct 15 Managers Must Sell Staff On Consultant Value

1984 Dec 24 Getting A Little Formal With Pseudo Code

SOFTWARE NEWS (now SOFTWARE Magazine) Controlled Circulation monthly tabloid from Sentry Publishing. Had a regular computer programming puzzle column, "So You Think You Know Your Software", under the pen name Jack McDonald.

1983 Oct A Different Twist on the Game of Life

1983 Nov Find the Bug in This Benchmark Program

1983 Dec Will the Real Programmers Step Forward

1984 Jan Solve the Aardvac Storage Problem

1984 Feb Discovering Tricks with Algol

1984 Apr Find the Bugs and Patch the Puzzle

1984 May True Faith in Structured Programming

1984 Jun Efficiency Stressed in Structured Basic

1984 Jul Sorting Poker Hands

1984 Aug Test Your Skills with the Self-Writing Code

1984 Sep Looks Like These Egyptian Fractions Are a Nile Long

1984 Oct Satisfying the Politicians

1984 Nov Anagraming Made Easier

1984 Dec Finding the Largest Number Can Lead You in Circles

1985 May There's Movement, but Is There Progress?

1987 Oct Improved Programming means Higher Maintenance Costs

MICROTIMES: Give away tabloid for the computer stores

1985 Mar Review of 10-Base, version 1.0

RENAISSANCE: Company magazine for Ross Software

1996 Oct The Year 2000: Threat or Menace?

SMALL SYSTEM WORLD: Monthly magazine for the mini and micro business computer user. Circulation is 40,000+ and is controlled. Held associate editor status during 1981. Irregularly contributed to the puzzle column.

1980 Nov Thinking Big Can Stifle Small Systems

1980 Dec Micro-Languages - An Interactive Technique

1981 Jan Considering Your Data Base Management System.

1981 Feb Distributed Systems - All Things to All People

1981 Mar A Design Methodology for Interactive Systems

1981 May Advanced Structured Programming

1981 Jul Choose the Right Applications Software House

1981 Aug Zeroes, Empty Files and Non-existent Records

1981 Oct How Secure is Your Data?

1981 Nov What to do When the Package Fails

DATA BASE MONTHLY: Paid circulation tabloid for Data General Users.

1981 Nov Algol Often Overlooked, But Powerful

1981 Dec Algol (Part II)

1982 Jan Algol (Part III)

1982 May RTL/2 - A Programming Language for Realtime

1982 Apr Habits Twist Language Goals

ON-LINE ACCESS: Paid circulation tabloid from DBM for Wang users.

1983 Oct Re-Entrant Code Brings Many Happy Returns

SOUTHLAND HIGH TECH: Short-lived give-away paper for Southern California. Did a regular column on software.

1986 Jun 16 User Status and Computers

1986 Jun 30 Laws, Logic and Computers

1986 Jul 14 Faulty Use of Spread Sheets

SYSTEM USER: Controlled circulation newspaper for IBM system users.

1981 Sep A Day in the Life of Melvin Frammis, DBA

1982 Mar Bending the Rod - editorial piece

1988 Jun In Search of a SQL Standard

PRODUCTION NEWS: Trade magazine for computerized printing equipment. Acted as

software advisor.

WOMAN ENGINEER: (Equal Opportunity Publications)

1982 Fall Living in the Electronic Office

DATAMATION: Controlled circulation magazine from Cahner-Ziff.

1982 Dec Machiavelli on Consulting

1991 Oct (letter): A SQL Server Objection...

1992 Aug (letter): SQL's Statistical bend

1994 Jan 21 (Future Vision): Everything You Know is Wrong

1995 Oct 15 (Cover; with J. McDonald): Don't Warehouse Dirty Data

1995 Nov 01 (web page): Killer SQL queries

1996 Jan 01 (Cover): Year 2000: Fix It Now!

LIST: Monthly business user magazine for Fortune 500. Now defunct.

1983 Sep Video Games - Menace to Programming? (Jack McDonald)

1983 Oct Tools For Your Spreadsheet

1983 Nov Tools For Your Wordprocessor

DEC PROFESSIONAL: Controlled circulation magazine for DEC users.

1984 Mar Bubble Sorts: A Second Look

1984 Nov The Worst Programmer I ever Met

1985 Feb How to Debug a Program using the Binary Search

BYTE: (McGraw-Hill)

1983 Nov Simplified Algorithmic Approach to Decision Tables

1997 Jul Double Zero (with Jackie Celko)

1997 Oct Debunking Object Database Myths (with Jackie Celko)

1998 Mar Stored Procedures: Threat or Menace?

COMPUTER LANGUAGES: (Miller-Freeman) Newsstand magazine for micro computer programmers

1984 Dec What Day is It, Exactly?

1986 Mar Three Structured Approaches

1986 Aug (Exotic Languages column) SQL

1987 Jan Data Flow Diagrams

1990 Dec Permutation Generator

1990 Dec (EOF) Table of Cubes (contributor)

1991 Apr (EOF) Purgamentum init, exit purgamentum

1991 Sep (Feedback) Try it again (re: Table of Cubes)

DATA BASED ADVISOR: Newsstand magazine for microcomputer databases.

1985 May 10-Base Version 2.0

UNIX SOFTWARE JOURNAL: Publication of FourGen corporation

Vol 3 No 4 Sitting on the Bench (reprint)

UNIX REVIEW: (Miller-Freeman) Trade magazine for UNIX programmers.

1992 Dec SQL2: The Sequel Arrives

DATABASE PROGRAMMING & DESIGN: (Miller-Freeman) Trade magazine for database programmers. "Celko on SQL" column started in 1990.

1988 Jan Book Review

1988 Feb Two Book Reviews

1988 Mar Book reviews

1988 Dec Inside ANSI X3.H2

1989 Mar DBA Shoptalk: Make or Break Your System

1989 May Reply to C.J. Date's letter

1989 Apr Book reviews on all time favorites

1989 Jun Cracks in the ANSI Wall

1989 Sep DBA Shoptalk: One Null, Two Null, Three Null, Four

1989 Oct Book Review

1989 Nov Bringing ANSI In Line With ISO

1989 Dec DBA Shoptalk: The Zen of SQL

1990 Jan (Celko on SQL): Not Just a Matter of Style

1990 Feb (Celko on SQL): When We Lived in Trees

1990 Mar (Celko on SQL): Crescent City Blowout

1990 Apr (Celko on SQL): Where's the Data?

1990 May (Celko on SQL): Sitting on the Bench

1990 Jun (Celko on SQL): Get that Zebra off my Desk

1990 Jul (Celko on SQL): Trouble in Paradise

1990 Aug (Celko on SQL): Avoiding The Hash Clash

1990 Sep (Celko on SQL): Do You Have the Time?

1990 Oct (Celko on SQL): The Weakest Link

1990 Nov (Celko on SQL): Learning to Add and Subtract

1990 Dec (Celko on SQL): Old Problems, New Tools

1991 Jan (Celko on SQL): Taking it to the Polls

1991 Feb (Celko on SQL): Class is Now in Session

1991 Mar (Celko on SQL): A Taxing Search

1991 Apr (Celko on SQL): Hurry Up and Report

1991 May (Celko on SQL): Have Suitcase, Will Travel

1991 Jun (Celko on SQL): Fear and Loathing at DB/Expo

1991 Jul (Celko on SQL): The 4GL/SQL Manifesto

1991 Aug (Celko on SQL): On Top of the World

1991 Sep (Celko on SQL): Meet Me in Missoula

1991 Oct (Celko on SQL): Hidden Time Bombs

1991 Nov (Celko on SQL): All in a Day's Work

1991 Dec (Celko on SQL): Back to the Future

1992 Jan (Celko on SQL): Who Will Take the Credit?

1992 Feb (Celko on SQL): All the Latest News

1992 Mar (Celko on SQL): Queries and COBOL

1992 Apr (Celko on SQL): Back to Business

1992 May (Celko on SQL): Front Ends for SQL

1992 Jun (Celko on SQL): Online Transaction Processing

1992 Aug (Database Library): A Little Bit of History

1993 Sep Views: More Than Meets the Eye

1993 Sep (Access Path): Medians

1994 Sep Trees, Databases and SQL

COMPUTER DEALER: Trade magazine for retail computer stores.

1983 Jun Can a freelance Consultant Increase Your Business?

1983 Oct Why Is Your Printer Just Sitting There?

1983 Nov Which Operating Systems Will Be Tomorrow's Winners?

1983 Dec Books: A Big Business that Spurs More Business

1984 Nov Sidebar on Radio advertising

RELATIONAL DATABASE JOURNAL (Formerly DB2 Journal): Controlled circulation magazine from Cardinal Business Media Inc.

Aug 1993 SQL And Counting Rows

Jan/Feb 1995 Why not use it ALL?

SELECT: International Oracle Users Group magazine.

1994 Summer The SQL-92 Standard - Good News for Oracle Programmers

1996 Jan Cumulative Statistics and SQL

THE C GAZETTE: magazine for C Language programmers

1989 Autumn (Vol. 4 No. 2) Optimizing Soundex

1990 Autumn (Vol. 5 No. 1) Minimal Swapping Sort

SYSTEMS INTEGRATION: (Cahner-Ziff) controlled circulation monthly.

Took over regular database column (DBMS/Report) in 1990 Dec.

1990 Dec ANSI's SQL2 makes life easier

1991 Jan SQL Report writers don't always speak your language

1991 Feb You'll have less design hassle with these CASE tools

1991 Mar Six fast-paced pathways on the way to learning SQL

1991 Apr Use tools to 'normalize' your file system into a RDBMS

1991 May Fours Ways to put Spreadsheets and Databases together

1991 Jun Two useful GUI toolboxes from Software Development show

1991 Jul Get up to speed with distributed databases

1991 Aug Here are some tools to help you interface with your DB

1991 Sep Retrieve your information with 'textbases'

1991 Oct Shape your database with these two oddball tools

1991 Nov What you need to know about geobases

1991 Dec Gear up your databases for the 'dreaded' year 2000

1992 Jan Use Knowledgebases to build systems that think

1992 Feb Build more secure networks with data-encryption schemes

1992 Apr Four ways to deal with the storage problem

TECH SPECIALIST: (R&D Publications) Took over regular database column (Data Desk) in 1990 Oct.

1990 Sep Check Digits (with Michael Smith)

1990 Oct (Data Desk): Fine Points of SQL: Aggregate Functions

1990 Dec (Data Desk): Data Encoding Schemes

1991 Jan Check Digits II (with Michael Smith)

1991 Jan (Data Desk): SQL Tricks in 4GLs

1991 Mar (Data Desk): Splitting Tables

1991 Apr (Data Desk): Merging Tables

1991 May (Data Desk): Strange Joins in SQL

1991 Oct (Data Desk): SQL and Update Tapes

DR. DOBBS JOURNAL: (M&T Publications, now Miller-Freeman) Newsstand magazine for micro computer programmers

1985 Sep Bose-Nelson Sort

1993 Apr Genetic Algorithms and Database Indexing

1994 Nov Partitions

THE C USERS JOURNAL: (R&D publications)

1990 (Vol. 8 No. 6) Structure Charts

1990 (Vol. 9 No. 1) Some Tips for Quicksort

VB TECH: (Oakly Publishing)

1996 Oct Best Practices: They Should Have Listened

YEAR 2000 JOURNAL:

1997 Oct Weird Dates

CENTURA PRO: (formerly Gupta Pro) company magazine for users of the Centura SQLbase product line.

1996 Dec Soup up your SQL

1997 Oct Jobville

PERSONAL PUBLISHING: Desktop publishing magazine

1986 Aug The ABC's of H & J

HARDCOPY: Controlled circulation magazine for DEC users

1986 Oct The VAX/VMS Virtual Disk Utility

EDUCATIONAL COMPUTER: Primary and secondary school magazine

1983 Jul/Aug Introduction to Stack Architecture

HIGHLIGHTS FOR CHILDREN: Primary school children's magazine

1989 ?? The 6174 Puzzle (with Jackie McDonald)

WRITER'S DIGEST: Magazine for writers.

1984 Contributed pieces on word processing in the 1984 Writer's Digest Guide to Word Processing.

1984 Nov Word Processing: Prep School

OFFICE SYSTEMS '84: Controlled circulation magazine for offices.

1984 Dec PC software opens door to desired applications

THE GAMER: British bimonthly game magazine, now defunct.

1981 Sep/Oct Spot the spots (article on dice)

1982 May/Jun Phalanx (article on board game)

GAMES MAGAZINE: Bi-monthly game and puzzle magazine

1984 Oct Santa's Little Helper

1985 Feb Second-best Poker

GAMES JUNIOR MAGAZINE: game and puzzle magazine for children

1990 Apr/May Overlapping Squares

COMPUSERVE MAGAZINE: customer magazine for CompuServe subscribers

1993 Oct Mensa Puzzle column

WORKING WORLD: Los Angeles giveaway employment magazine

1990 Apr 23 Use your wordprocessor to improve writing skills!

CONTINGENCY JOURNAL: magazine for business contingency planning

1990 Jul-Sep Passwords

ACADEMIC JOURNALS & PUBLICATIONS

SOFTWARE PRACTICE & EXPERIENCE: A John Wiley Interscience Journal

1982 Oct Time Token Design Methodology

SIGPLAN NOTICES:

Journal of ACM Special Interest Group on Programming Languages

1983 Jan A Demonstration of Three Requirement Languages

(with LTC John S. Davis & John Mitchell)

STRUCTURED PROGRAMMING: Springer-Verlag journal on structured programming languages, techniques etc.

1989 Fall Observations about Student Programming Practices

SCHOLASTIC DYNAMATH: Junior high school math supplement from Scholastic press.

1994 Apr Do Fractions like an Egyptian

ABACUS: Springer-Verlag AG publication on computers for non-computer scientists and educated laymen. editor for the Problems & Puzzles.

1984 Spring (Vol. 1 No 3) Mutants of Hanoi

1984 Fall (Vol. 2 No 1) Petri Nets

1986 Fall (Vol. 4 No 1) Jumping Frogs and the Dutch Flag

1987 Winter (Vol. 4 No 2) Games in Two Dimensions

1987 Spring (Vol. 4 No 3) Tree Puzzles

1987 Summer (Vol. 4 No 4) Word Games & Puzzles

1987 Fall (Vol. 5 No 1) List Processing Puzzles

1988 Winter (Vol. 5 No 2) Strange Birds & Unusual Logic

1988 Spring (Vol. 5 No 3) Elevator Puzzles

1988 Summer (Vol. 5 No 4) Self-Descriptive Arrays