(Uche Ogbuji) SOAP technologies usually exchange XML over HTTP, but SOAP has its pros and cons, and a lot discussion has focused on how to use XML more directly to communicate between applications. This tip describes the direct approach, and discusses where it is most appropriate. It also discusses
Other News
Getting Syntax Help for DTSRun
(Darren Green) If you are having problems with the syntax for the dtsrun command line, or just want an easy way of generating a valid command line first time, try using the dtsrunui utility. As the name indicates it is very similar to dtsrun, but with a user interface. This allows you to easily sele
Building Dictionaries With SAX
(Uche Ogbuji) People have always liked to complain that Python is slow. People have always liked to complain that XML processing is slow. I’ve always thought both complaints are typically misguided. Neither Python nor XML emerged out of the need for ultrasonic speed at runtime. Python emerged as an
Isolation Level
The isolation level used during the execution of SQL statements determines the degree to which the activation group is isolated from concurrently executing activation groups. Thus, when activation group P executes an SQL statement, the isolation level determines: –The degree to which rows retri
Overview of the Critical Update for SQL Server 2000 Desktop Engine (Windows) on Windows Server 2003
Microsoft has released an update to Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) on Microsoft Windows Server 2003. This update addresses issues with WMSDE when used with Microsoft Windows SharePoint Services on computers that are running Windows Server 2003. This article describes how
Learn to Use XML with DB2
(Greg Nash) My employer has just spun off our product testing facility into an independent organization, able to seek other clients. They will have their own, independent data systems but background data must be sent and test results must be retrieved to our core system with minimal effort. XML
SQL Server 2000 Wait Types
You may have wondered what the different wait types mean that you see listed with certain transactions with SQL Server. This handy table will explain each, along with some tips to address them.
Introduction to MSSQL Server 2000 Analysis Services: Reporting Options for Analysis Services Cubes: ProClarity Professional, Part I
(William Pearson) In this two-part article, we will return briefly to our exploration of what has continued to be a popular topic (and which, as I mentioned in Article Ten, results in several e-mails each week in my inbox), Reporting Options for Analysis Services Cubes. As I stated before, our focus
A Fresh Look at Data Striping in DB2 Universal Database Version 8.1
(Paul C. Zikopoulos and Roman B. Melnyk) The Version 8.1 release of IBM DB2 Universal Database (DB2 UDB) late last year came with the ability to start a new data stripe on the underlying storage units. In this article, we introduce you to this new feature and the problems that it solves, and take yo
A survey of XML standards: Part 1
(Uche Ogbuji) The world of XML is vast and growing, with a huge variety of standards and technologies that interact in complex ways. It can be difficult for beginners to navigate the most important aspects of XML, and for users to keep track of new entries and changes in the space. In this series of