(Clayton Donley) One of the things that makes the English language so difficult to learn for non-native speakers is the way one word can mean so many different things. Not just homonyms such as “their” and “there,” but even the exact same word with the same pronunciation and inflection. For exam
Other News
DB2 at a Glance: The Big Picture (Sample Chapter)
(Raul Chong, Clara Liu, Sylvia Qi and Dwaine Snow)This chapter provides an overview of the DB2 core concepts using a “big picture” approach. It introduces SQL statements and their classification in Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).
HA DB2 (Partitioned Database) using Tivoli System Automation
(Harish Chauhan) In this document, I have tried to explain each and every step that is required in setting up a Highly Available DB2 cluster. A cluster has lot of components like shared disks, SAN switch, nodes, software, connectivity, etc. I have written this document keeping in mind a novice so af
Lightweight UI Test Automation for ASP.NET Web Apps
(James McCaffrey) The release of ASP.NET revolutionized Web development and made it easy to create full-featured Web applications. Visual Studio 2005 and ASP.NET 2.0 will let you add even more functionality to your applications, but the more features a Web application has, the more important testing
Using Nulls in DB2
(Craig S. Mullins) A null represents missing or unknown information at the column level. If a column “value” can be null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may
Oracle Database 10g high availability with RAC, Flashback and Data Guard (Chapter 8)
(Matthew Hart and Scott Jesse) This chapter is entitled “Backup and recovery for high availability environments.” It helps dispel the myth that backing up a database is not an HA technique — that backups are the fallback when the database has already gone down, is unavailable, and there is no other
Best of the Rest (DBA Features in Oracle 10g)
(Arup Nanda) Wow! This is the final week of our amazing journey into the most important new features for DBAs in Oracle Database 10g. Over these last 19 installments I have attempted to cover all the tools, tips, and techniques that have this fundamental appeal: making our jobs easier and more satis
SQL Server Data Mining Programmability
(Bogdan Crivat) Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.
What’s New in ADO.NET 2.0 for SQL Developers
(Dino Esposito) To write effective .NET data-driven applications, a deep understanding of the ADO.NET object model is essential. In version 2.0 of the .NET Framework, the set of classes that form the ADO.NET object model are nearly identical to those in version 1.1, but Microsoft has introduced a fe
The Linux Letter: Taming Complexity with Open Source and i5
(Barry L. Kline) The office is closed today, but I am here because I am awaiting the arrival of my IBM CE. During the week, our database server (an IBM pSeries running AIX and Oracle) spontaneously rebooted, rudely cutting off the 30+ users who had been enjoying its services. Once the system was