(Brad M. McGehee) When it comes to auditing index use in SQL Server databases, I sometimes get overwhelmed. For example, how to do you go about auditing indexes in a database with over 1,500 tables? While auditing a single index is relatively straight-forward, auditing thousands of them in multiple
Other News
What’s New in WebSphere Portal v5.1?
(Richard Gornitsky and Rob Will) WebSphere Portal, the leading enterprise portal package on the market, is about to ship a major new release designed to take integration and flexibility deeper and further than ever before. WebSphere Portal lets programmers focus on developing the business functi
Third-Party Support An Option For PeopleSoft Customers
(Charles Babcock) Jack Hughes, IS director for The Park Associates, operator of a 27-unit nursing home chain, says he’s not worried whether Oracle will support his PeopleSoft applications.
Consuming Asynchronous Web Services
(Thiru Thangarathinam) In this article, we will see how to use Web services in a real-time Web application. Even though Web services are very powerful and based on open Internet protocols such as XML, HTTP and SOAP (that accounts for platform independence), using them in a real-time Web site require
How XInclude Simplifies XML Doc Integration
(Vance McCarthy) The W3C’s release of recommended specs for XInclude 1.0 should make it much easier, and cleaner, to integrate multiple XML documents together into a single composite. In specific, XInclude 1.0 would create a “standard inclusion mechanism” for the XML mark up language, which would
Backup and Recovery for High-Availability Environments (Sample Chapter)
(Matthew Hart and Scott Jesse) An analysis of backup and recovery issues that get opened with Oracle Support Services revealed an interesting point: in situations where backups existed for recovery, a full restore of the entire database was initiated 40 percent of the time. In other words, when a h
Achieving the Highest Levels of Parallel Sysplex Availability in a DB2 Environment
(Frank Kyne and Glenn McGeoch) Maintaining high availability in a Parallel Sysplex requires planning and effort on the part of many individuals in multiple disciplines. DB2 is just one component of a highly available environment. This Redpaper provides additional information to the Parallel Sysp
Oracle/PLSQL: ORA-00933 Error
This article explains how to resolve the error of executing an SQL statement with an inappropriate clause.
Using the Observer Pattern in .NET
(Michael Weier) I recently visited a friend who received a binary clock as a gift. Throughout the afternoon, I found myself almost hypnotized by the marching of the lights across the clock face. When I left, I was convinced that it would be a great example of the Observer pattern. This article demon
Why there’s no need to abandon .NET for open source
(Tony Patton) A client recently greeted me with a barrage of complaints about Microsoft, product costs, and so forth. They wondered aloud whether they ought to assemble a strategy for moving to an open source platform to save money. Now, I’m not one to start an argument about the merits of consumer