(Tyler Anderson) Atom is a growing syndication format favored by many over the major syndication format, RSS. With any indexing system like Atom, you never want to intentionally create duplicate feeds as this can overwrite the older, original id element. And duplicated entries (if they aren’t overwr
Other News
Finding Foreign Key Constraints in Oracle
(JP Vijaykumar) Many times developers find it difficult to delete records from parent tables when child records reference those tables through foreign key (referential integrity) constraints.
Subclassing and Overriding ASP.NET Pages—Part I
(Dino Esposito) A client recently approached me and said “we need to enter changes to some ASP.NET pages. Can you help?” Like any consultant would, I promptly replied “Sure. Tell me more.” But the client didn’t actually have much more to share than the URLs to the pages. In a nutshell, the client ha
Create custom notifications with SQL Server 2005
(Tim Chapman) In my article on sending e-mail with Database Mail in SQL Server 2005, I discussed how crucial it is to be notified when problems occur so that you can make adjustments to fix the problem and ultimately prevent it from happening again. This week, I will build a small custom notificatio
Now Available: Profiling in MySQL
(Jeremy Cole) Back around November 2005, I started working on query profiling in MySQL via the SHOW PROFILE and SHOW PROFILES commands. It’s been an interesting ride, but profiling support is finally available in public releases of MySQL starting with MySQL Community 5.0.37!
Oracle Accuses SAP of ‘Massive’ Theft
Oracle threw a firebomb of accusations at SAP today, charging its enterprise software rival with corporate theft “on a grand scale.”
Migrating WebSphere InterChange Server artifacts to WebSphere Process Server artifacts, Part 2: Understanding the WebSphere Process Server SCA components
(Lisa A. Seacat) In Part 2 of this series, we’ll describe the SCA components that are generated when you migrate WebSphere InterChange Server collaboration objects to WebSphere Process Server.
Anixter’s Migration to DB2 for z/OS Version 8
(Damon Anderson and Bernie O’Connor) This case study of Anixter’s migration to DB2 for z/OSVersion 8 is presented largely in chronological order. It contains informationon our training, planning, risk identification and mitigation, installation, configuration, testing and implementation. We hope our
Abstracting Database Access Using Polymorphism with Objects in PHP 5
(Alejandro Gervasio) Polymorphism is an object-oriented programming concept that can be difficult to understand. This article, the first of a three-part series, walks you through the basics of Polymorphism so that you can make use of it in your own applications. The specific example in this article
SQL analytics: A self-service model
(Jeffrey R. McCormick) SQL analytics remains one of the best-kept secrets of the Oracle database. It represents the latest advancement in the evolution of delivering powerful analytic capabilities to end users. How quickly the business will benefit is largely in the hands of database teams and their