(Paul Zikopoulos) In my latest articles, I’ve been writing about the IBM Rational Data Architect (Rational DA) integrated development environment (IDE), a tool that’s specifically designed for those involved in data server design and schema evolution. So far, I’ve shown you how to add a database con
Other News
Database Bulls of Info-Storage on Linux – Oracle and IBM DB2
The most important point in any database software is its compliance to ACID properties. These are set of properties that guarantees that a transaction ( all the steps right from start to end e.g sign in to sign out) executed in orderly and reliable manner. Say for an example if you have to transfer
Oracle: Standby Automatic File Management
(Paul Moen) So you have followed the recipes to create a standby database, setup the database to switch logs automatically, and now, as with any good database, the space required to support the application grows and grows and grows.
Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic
(Denis Gobo) You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those in a lookup table and then you create another table where you store all the categories for each customer.
Source Control and Databases
(András Belokosztolszki) Many DBAs must have made and heard the request for a source control mechanism for SQL Server databases. It sounds like a brilliant idea. Once implemented, one could easily go back to a specific database schema version, compare it against the current version, and have plenty
Why Doesn’t MySQL support Millisecond DATETIME Resolution?
(Kevin Burton) Apparently, there’s been an outstanding bug for nearly two years for MySQL to add support for millisecond storage in DATETIME and TIME data types.
FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000
Under high memory pressure, an access violation may occur when you try to log in to an instance of Microsoft SQL Server 2000. Therefore, you cannot log in.
DB2 9 for z/OS, compression, REORG/LOAD, and a possible surprise
(Willie Favero) Today’s post is a short heads-up for those of you that have just moved to DB2 9 for z/OS and also use table space compression (did you notice I have to start identifying whether I’m talking about table space or index compression now). If you are satisfied with your compression’s dict
Announcing the Microsoft Office Interactive Developer Map built with WPF
(Erika Ehrli) You never know what surprises each day will bring to you. Two days ago I didn’t know today was the day when we were finally sharing with the world our new learning tool for Office developers: The Microsoft Office Interactive Developer Map.
Pinning Objects to Improve Apps Performance
(Avanish Srivatsav) Keeping database packages in the Oracle database’s System Global Area (SGA) shared pool is a common practice. This is also called pinning. One common misconception is that pinning is not useful or needed in later Oracle database versions such as 10g and above, since those relea