(Jeff Web) With names like SOAP and REST, you’d expect a couple cute jokes here. Perish the thought; I promised code in my last post and code you shall have. The VB/VBA tools and samples from Microsoft demonstrate calling web services through SOAP interfaces. For example, the Office Web Services
Other News
Handling Simple XML Using T-SQL
(Eli Leiba) This article describes how to traverse a simple XML file that has only 2 attributes (name and value, like a dictionary). And get the results in a single column in SQL SERVER result set. (R)
Part 2: Simplify performance management and tuning with DB2 Performance Expert
(Werner Schuetz) Part 1 of this article introduced the DB2 Performance Expert (DB2 PE), a tool that simplifies the tasks of monitoring and administering your DB2 UDB servers. Now, Part 2 shows you a number of practical scenarios, demonstrating how to use the tool to analyze factors which directl
Installing Oracle Database 10g on Linux x86
(John Smiley) This is the first in a series of guides that provide all the steps for installing the major components of Oracle 10g software on Linux. All three of the certified English-language distributions of Linux are covered in detail (Asianux is not covered), and the articles assume that inexpe
Microsoft, SQL Server and Performance Management: The Business Scorecards Accelerator, Part 2
(Trey Johnson and Pam Barker) This is the second of a two-part series walking you through the new performance management solution from Microsoft, Microsoft Office Business Scorecards Solution Accelerator. Part 2 focuses on bringing the scorecard to life and porting the information to a portal.
Use ISO Images Without Burning to Disk
(Andy Warren) For those of you who have an MSDN subscription you may have noticed that many of the downloads are now available as ISO images (basically a copy of the data as it exists on disk, sector by sector). Win XP makes short work of burning those images to CD as readable files, but so far
Oracle security patches causing headaches
(Robert Westervelt) Oracle security expert Arup Nanda said Oracle’s latest alert is frustrating to DBAs since very little information was released with each patch. With little information to go on, many enterprises are being forced to take entire systems out of production, Nanda said. (R)
Patterns: Information Aggregation and Data Integration with DB2 Information Integrator
(Nagraj Alur) This IBM Redbook documents and prototypes the role of DB2 Information Integrator technologies and architecture in IBM’s Patterns for e-business using a typical customer insight e-business scenario. It is aimed at an audience of IT architects and data integration professionals responsib
IBM’s Jones: ‘Stinger’ Targets Enterprises with Automation, Price Freeze
(Lisa Vaas) Jeff Jones, director of strategy for IBM’s DB2 Universal Database, says IBM is wielding affordability and automation as it prepares for battle in the new world of second-generation databases. As the company prepares to unleash Stinger, code name for DB2 UDB 8.2, he took time out to c
Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Design
(William Pearson) Optimization of MSAS requires an in-depth knowledge of many factors, including the manner in which MSAS executes queries within the client/server architecture that embodies it. From the perspective of the cubes that MSAS produces, our primary concerns, from a performance standp