By Kim Moutsos – Where would we be without Edgar F. Codd? Codd, who died in April at the age of 79, elevated database management to a science when he described a relational model of data — one firmly grounded in predicate logic and mathematics — in a series of papers published between 1969 and 1981.
Other News
Tools Give Oracle DBAs Better Protection, More Control
By Lisa Vaas – The long-anticipated unveiling of Oracle Corp.’s grid vision at OracleWorld here Monday was greeted by the rollout of new products to support Oracle databases, including extended data protection from DataMirror’s iReflect high-availability software and extended cross-platform support
All About Nothing
By Russ Whitney – OLAP cubes are notorious for having lots of empty (or null) cells. Including these empty cells in your result sets can bog down your analysis applications. But you can use these tricks to eliminate empties.
Microsoft Reminds Users About SQL Server 7.0 SP4 Patch
In the wake of the most recent wave of Internet viruses, Microsoft sent a reminder to SQL Server 7.0 users about an available security patch.
Take Advantage of Powerful System-Supplied UDFs in SQL Server 2000
Baya Pavliashvili and Kevin Kline explore a set of SQL Server user-defined functions from Microsoft that are related to traces.
Oracle’s database name game
By Robert Westervelt – Did you hear the one about 10G? It’s the price users will pay per seat for Oracle’s new database. Get it? That’s a joke. All right, it’s not a gut-buster, but it does represent the sort of satire sometimes generated when IT companies attempt to convey new strategies and direct
Identify Missing Sequence Numbers
By Murthy Mamidanna – We often have a need to locate missing primary key sequence numbers. The miss of sequence could have happened either because the cache option was left at default value (i.e., 20) at the time of creation of the sequence or through a drop of records (due to exceptions) by a progr
DB2 security and instances
This tutorial introduces you to DB2 security and instances. To understand the concepts described in this tutorial, you should already have a basic knowledge of database concepts…(R)
Updated! DB2 Version 8 Connectivity Cheat Sheet
By Raul F. Chong – Are you a user of the DB2 V8 Connectivity Cheat Sheet? Check out the newly updated version. It contains all new scenarios, including iSeries connectivity!
Certification Strategies
By Howard Fosdick – When it comes to DB2 certification, take a tip from The Beatles and look for a little help from your friends. Professional friends are some of the best certification resources.