(Nicholas Chase) As Web services grow in popularity, enterprising Web and application developers create new and innovative applications with their data. In addition to single-service applications, developers are creating mashups, applications that combine data from multiple services to create someth
Author: SSWUG Research
Oracle Acquires Sigma Dynamics
(Renee Boucher Ferguson) Oracle quietly announced Aug. 23 that it acquired the intellectual property assets of Sigma Dynamics, a company that develops predictive analytics technology.
SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer
If you run Microsoft SQL Server 2000 or Microsoft SQL Server 2005 on a Microsoft Windows Server 2003 Service Pack 1 (SP1)-based computer, SQL Server may temporarily stop responding (hang) in certain cases. Depending on the severity of the problem, this behavior may take from several milliseconds to
SQL & XQuery tutorial for IBM DB2, Part 3: SQL joins and unions
(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial describes two ways to combine data from different tables in an IBM DB2 database: by joining the tables with inner or outer joins and by using the UNION, EXCEPT, and INTERSECT operators, which take the intermediate result set from one query
XML in Focus
(Ken North) DB2 9’s “pureXML” technology is speeding development for early customers, including financial-services giant Storebrand. Explore the developer-friendly features behind the radical improvements.
Automate XML file updates, Part 2: Use Apache Ant and conversion stylesheets to update your XML
(Tom Coppedge) This is the second part of a three-part tutorial series that describes a method for automating updates to a library of XML files so that they all conform to an updated XML schema. Here, in Part 2, you learn to install, configure, and run Ant and Java SE to iteratively transform each o
Study Guide for DataStage Certification
(Vincent McBurney) I’ve received the question a few times now – what should be studied before taking a DataStage Certification exam. Here is a list of sections of manuals to study and some exercise ideas to go with it.
A Return to Command-Line Control with Windows Powershell
(Drew Georgopulos) Back in the days of personal computing, the user could control almost every aspect of his or her machine’s environment and behavior from the command line. If you really needed extra power, GW-BASIC let you interact with the system. As Windows got bigger and bigger, the graphical u
Ground Up: Master Pages in ASP.NET 2.0
(Doug Seven) In this intorductory series I will show you how to use the new Master Pages feature of ASP.NET 2.0 to manage the look and feel of your website from a single location. In the second installment of the series I will show you how to add Theme support to enable quicly modifying the look and
Maintaining Transactional Replication with SQL Server 2005
(Baya Pavliashvili) The first article in this series introduced you to replication setup with SQL Server 2005. In a simple scenario, replication setup is straightforward; however, replication does require some maintenance. This article shows you how to maintain replication stored procedures, how to