(Kalen Delaney) Ownership chaining, which I described in “Crossing the Line: Ownership Chains” (February 2004, InstantDoc ID 40963), offers a limited way to specify what context a particular executable module should use when being executed. The context depends on the owner of the module and the iden
Other News
Parsing non-XML Documents
One of the neatest tricks that a SAX filter can perform is presenting something that isn’t an XML document as if it were one. The client application doesn’t need to know that what it’s parsing is really a tab-delimited text file or a relational database if the filter hides all those details and just
What Are ANSI Joins, And Why Should I Use Them?
(Mark Rittman) If you’ve ever had to port a Microsoft SQL Server or Access database over to Oracle, you’ve probably come across the different way joins are put together for these databases. For example,you might come across a query looking like this; SELECT pub_name, title FROM publishers INNER J
SQL Server Failover Clustering
This chapter introduces Microsoft® SQL Server™ 2000 failover clustering, which is available only in SQL Server 2000 Enterprise Edition. It describes single instance failover clustering (active/passive) as the recommended approach for the Office Solution Accelerator for Intranets. This chapter also d
Hooking Up with IBM DB2 Universal Database Version 8 Using Java
(Kulvir Bhogal and Grant Hutchinson) DB2 UDB provides for JDBC connectivity through a number of Java classes and interfaces that implement the JDBC specification. The implementation is known as a JDBC driver. DB2 currently offers JDBC drivers known as legacy/CLI drivers and the universal JDBC driver
SQL Server performance counters do not work on Windows NT Server 4.0
Microsoft SQL Server version 6.5 performance counters do not appear if you do not have Microsoft Windows NT administrative access to the target computer that is running Windows NT Server 4.0 or if you do not have other access that gives you READ permission to the registry of the target computer.
Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Incremental Update Wizard
(William E. Pearson, III) This is the fifth article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of
A Standards-based Look at XAML’s Features
(Nigel McFarlane) icrosoft’s XAML markup language floats on top of the .NET platform. It is compiled into .NET classes, usually C#, which reduces it to a set of objects. Along with a host of other XML dialects it is an example of a new type of specification for GUIs. This article takes a look at XAM
Tips for using Tivoli Storage Manager with DB2
(Marin Komadina) As a final word about Tivoli Storage Manager (TSM) database backup, here are a few tips I have found working with the TSM system. Only the most interesting tips are included since presenting all of them would be beyond the scope of this article. This article covers: –Tips Us
A Practical Guide to Data Warehousing in Oracle, Part 5
(Dave Aldridge) On a regular OLTP system, the integrity of the data is generally supported in two ways – firstly by logic embedded in the application, and secondly by constraints placed on the logical structure of the database itself. The two may be complementary, as a designer may rely on the latte