(Marcin Policht) In this article of our series presenting SQL Server 2000 Security, we are turning our attention towards Data Transformation Services. If you are not familiar with this topic, it might be helpful to first review its coverage on the DatabaseJournal Web site. The referenced information
Author: SSWUG Research
Running WSAD and WAS with Oracle
(Troy Holmes) During a recent EAI project, it came to my attention that it is difficult to find documentation on the topic of installing Oracle into WebSphere Studio Application Developer (WSAD) and WebSphere Application Server (WAS) 5.0. This article will attempt to expedite the search for this inf
Perl Parser Performance
(Petr Cimprich) There was one dominant XML parser in Perl a few years ago; parsing an XML document was synonymous for using the XML::Parser module. The module written by Larry Wall and Clark Cooper worked as an interface to James Clark’s expat XML parser, and it didn’t leave much room for compet
DTS Parallel Processing
(Leo Peysakhovich) Recently I faced a task, as a part of regular maintenance, to rebuild all the indexes in the databases. Nothing special, but that instance of SQL Server has anywhere between 200 and 400 databases. Each of them is fairly small but it takes hours to rebuild indexes manually or even
Store Integers as Decimal Data Type
(Brian Moran) I need to store integers—account numbers and other IDs—that have 20 or more digits. Storage and retrieval of these integers needs to be accurate, with no rounding, so I can’t use the float data type. I’ve seen recommendations to others in this situation to store the integers in a CHAR(
Moving Data Faster
(Arup Nanda) Lora, the DBA at Acme Bank, is at the center of attention in a high-profile meeting of the bank’s top management team. The objective is to identify ways of enabling end users to slice and dice the data in the company’s main data warehouse. At the meeting, one idea presented is to create
Lightweight XML Editing in Word 2003
(Evan Lenz) Did you know that Word documents can be saved in XML format? As of Microsoft Office 2003, the second option in Word’s Save As dialog–right under “Word Document (*.doc)”–is “XML Document (*.xml)”. This format is Microsoft’s own XML vocabulary for Word documents, called Wordprocessin
Comparing the Distributed DB2 UDB Servers
(Paul C. Zikopoulos) In a side-by-side comparison table, This article makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 Universal Database (DB2) server family.
Introduction to Web Services Technologies: SOA, SOAP, WSDL and UDDI
(Thomas Erl) This sample chapter delves into the concepts and technology behind Web services, including Web services and the service-oriented architecture (SOA), Web Services Definition Language (WSDL), Simple Object Access Protocol (SOAP), and Universal Description, Discovery, and Integration (UDDI
MDX Essentials: Numeric Functions: Introduction to the AVG() Function
(William Pearson) In this lesson, we will introduce a commonly used numeric function in the MDX toolset, the AVG() function. The general purpose of the AVG() function, as we shall discover, is to return the average of the tuples occupying a set. We will consider elementary uses of the function in th