(Jim Mulkey and Nancy Lilly) In the world of DB2 utilities, great emphasis is placed on the contrasts between one vendor’s performance benchmark and another’s. However, benchmarks no longer tell the whole story. The requirements for backup and recovery, as well as the method used to evaluate the suc
Other News
DB2 Universal Database for Windows High Availability Support Using Microsoft Cluster Server
(Aslam Nomani and Lan Pham) DB2 Universal Database (UDB) is the industry’s first multimedia, Web-ready relational database management system, strong enough to meet the demands of large corporations and flexible enough to serve medium-sized and small e-businesses. DB2 Universal Database combines inte
Oracle Goes Grid
Oracle Corp. has announced plans to incorporate grid-computing techniques and standards across its product line in the forthcoming Oracle 10g release. According to Robert Shimp, Oracle vice president of database marketing, “grid computing will be every bit as significant as the Internet” in its impo
XML Advances on B2B Front
(Dan Wahlin) Extensible Markup Language (XML) has evolved considerably in its short five-year history. It started out as a simple way to mark up data and relied on seasoned technologies for data validation, such as document type definitions (DTDs). As XML has matured, the World Wide Web Consortium (
HOWTO: Import FileSystem Data Using DTS and Index Server
DTS Import Wizard does not show Index Server OLE DB Provider in the list of sources. However, you can specify a distributed query with Index Server OLE DB provider as the source of your data. Steps to Copy FileSystem Data –Run SQL Enterprise Manager and run Data Transformation Import Wizard.
The Long, Long Arm of SGML
(Kendall Grant Clark) Writing about XML invites a certain humanistic pretension, for several reasons. First, all this talk of universality and frictionless information exchange bears uncanny allusions, for those of us who inhabit certain parts of the ideological landscape, to what Christians used to
New CONNECT BY Features in Oracle Database 10g
(Jonathan Gennick) Recently I wrote about Oracle’s support for hierarchical queries in an OTN article titled Querying Hierarchies: Top-of-the-Line Support. While writing that article, I learned about some exciting, new features in Oracle Database 10g that strengthen Oracle’s already robust support f
SQL Audit tools contest – win free software
SQL-Server-Performance.Com and LockwoodTech Software are offering you an opportunity to participate in the shaping of a new software product for SQL Server. LockwoodTech Software has recently introduced Log Navigator, a software utility designed to read SQL Server’s transaction log. Although rec
DB2 Basics: Creating your first trigger in DB2 Universal Database
(Kulvir Singh Bhogal) When certain events take place in an IBM DB2 Universal Database database, you can fire triggers that can perform other actions. In this article, you’ll explore the world of triggers and see how they can be used to enforce business rules in your database. You’ll also learn how t
Create Editable XML Documents Using XPath and the TreeView Control
(Alex Hildyard) Recently, I was working on the user interface for a tool to maintain an online catalog. Because the catalog featured so many products, it made sense to categorize them in some way. The catalog administrator would need the ability to delete and define new categories, nest categories w