(Jayaram Krishnaswamy) Microsoft breathed new life into legacy office documents by opening an XML window (Office Open XML) to its office products through its royalty-free XPS specification. XPS stands for XML Paper Specification that specifies cross-platform, open standard, document representation t
Other News
SQL Server 2005 Integration Services – Part 48
(Marcin Policht) In the most recent installments of our series dedicated to SQL Server 2005 Integration Services, we started exploring database maintenance functionality. Our interest in this subject (within the context of our series) results from the fact that SSIS Designer of Business Intelligence
Get your DB2 for z/OS system ready for Developer Workbench V9.2
(Marichu Scanlon) This article discusses the system-related tasks that you, as a DB2 for z/OS V8 or V9 user, should consider when utilizing the functions in Developer Workbench (DWB). It provides an overview of DWB, then discusses customization JCLs, RACFs, and migration considerations. Finally, you
SQL Server Management Objects
(John Papa) Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition La
Merge Tables Gotcha
(Peter Zaitsev) I had the interesting customer case today which made me to do a bit research on the problem.
FIX: The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services
When you try to connect to a remote Microsoft Windows 2000 Server-based computer by using the Remote Desktop Connection service or by using a Terminal Services session, the Sqldumper.exe utility in Microsoft SQL Server 2000 cannot generate a filtered SQL Server dump file. Additionally, you receive t
XBRL, XML with a mind for business
(Daniel Rubio) Web services have effectively established a cross-platform solution around the classical “handshake” in client/server architectures, but the actual payload exchanged between parties can have very distinct formats depending on the nature of an application. In an attempt to standardize
Declare the Coolest XQuery Variables
(Anghel Leonard) This tip shows how to declare some important variables in XQuery.
XML Notepad 2007
(Martin Heller) In case you missed it, Microsoft resurrected the old XML Notepad last year. The new version, XML Notepad 2007, is a .NET 2.0 application for which source code is available on CodePlex. I find it the application quite useful.
IDUG Highlights
(Philip Nelson) I’m writing this in the departure lounge at San Francisco airport, on the way home from this year’s IDUG (International DB2 User Group) North American conference.