In a logical expression, the comparison of the Data Transformation Services (DTS) Connection Object password will always return false and an empty string will be returned when attempting to display the password. This only occurs after installing Service Pack 2 for SQL Server 7.0.
Other News
When To Use the Order By Clause
(G Vijayakumar) When I was using SQL Server, I was not using the “order by” clause properly. I always say myself that when I want the data in a particular order, I should use order by clause in select statement otherwise leave to the SQL Server. I presumed MS-SQL Server will return the data in i
Why use DITA to produce HTML deliverables?
(John Hunt, Don Day, Erik Hennum, Michael Priestley and Dave A. Schell) The Darwin Information Typing Architecture (DITA) is an XML-based format for structuring and authoring technical content. This article explores advantages DITA provides for producing HTML content — including easy global cha
Integrate xmlspy 2004 Into VS.NET
(Dan Wahlin) Altova’s xmlspy has been one of the top XML editors for several years due to its support for XML document editing, schema design and validation, XSLT editing and debugging, and WSDL/SOAP capabilities. I’ve been a fan of xmlspy, but have often wished there were a way to integrate it into
Encrypted or Signed Non-XML Docs Require AutoSMIME
Commerce Interchange Pipeline Manager transmit profiles can be configured with several different signature and/or encryption components. If a transmit profile is used to send a signed and/or encrypted non-XML business document to a standard receive location on another Commerce Server, then the trans
9i RAC: Manual Backup and Recovery
(Shankar Govindan) When we plan to move a large database or a heavily used OLTP database to a cluster setup, to get enough mileage from the horizontal scaling of 9i RAC, we normally have lots of questions on how we are going to handle various database maintenance that are traditionally done, how we
Optimizer Statistics with DBMS_STATS in Oracle 10g
When a SQL statement is executed, the database must convert the query into an execution plan and choose the best way to retrieve the data. For Oracle, each SQL query has many choices for execution plans: –Including which index to use to retrieve table row. –What order in which to join mult
Building and Scaling SAP Business Information Warehouse on DB2 UDB ESE
(Chuck Ballard) SAP is a leading ERP vendor, with a large install base. A key element in their product set is the SAP Business Information Warehouse (BW). The primary objective of this IBM Redbook is to provide guidelines to help you implement your SAP Business Information Warehouse on DB2 UDB ESE.
DB2 Web service engines on Linux with Kylix 3: Part 1
(Bob Swart) This article demonstrates how to build a SOAP Web service engine with Kylix 3 on Linux, exposing the data from DB2 UDB database tables to the outside world.
Beating the Odds
(Craig Utley) Data-warehousing projects are prone to failure. How prone is subject to debate. Various studies show wildly different percentages of failure. For example, according to the Data Warehousing Information Center article “The Case Against Data Warehousing” (http://www.dwinfocenter.org/again