By Shane Dovers – Optimum portability is one of the most important goals in creating a Data Transformation Services package that can execute properly on virtually any server.
Author: SSWUG Research
Express Your Business with IBM DB2
By Patricia Fusco – Dubbed DB2 Universal Database Express, IBM’s new full-function database for the mid-market is designed to install itself with no mouse clicks required and is priced 30 percent less than other database management systems.
Access DB2 with Web services
By Quentin Presley – Web services enable you to quickly integrate applications across multiple platforms, systems and even across businesses. This tutorial demonstrates how easily you can make your DB2 data accessible through Web services. It shows how to use the Application Developer configuration
DB2 regular expressions for the SQL-challenged
By Jim Keohane – Fans of MySQL and mSQL taunt DB2 users about DB2’s lack of support for the non-standard RLIKE/REGEXP facility in SELECT and other SQL statements.
Visualizing XSLT in SVG
by Chimezie Ogbuji – There are a number of visual tools employed by XML editors and viewers which make verbose XML documents easier to browse and manipulate. XML Spy is, for example, such a tool. This article will introduce how SVG can be used to create a visual representation of an XSLT stylesheet.
OASIS and RosettaNet Set Standards Alliance
By Michael Singer – The two groups look to streamline Web services development by working closely together on specs as ebXML and the Universal Business Language (UBL).
HOW TO: Do Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET
This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OLEDB or the ODBC managed provider.
Cleaning up after Oracle
By James Giordano – Regardless if you are the DBA or the sysadmin, you need to be concerned with the task of cleaning up the filesystems that Oracle uses. There are three areas to be concerned with, archive logs, trace files, and logs files.
Using LOBs and extenders in DB2
In today’s enterprise, unstructured data — video files, sound files, picture files, and even large text files — is increasingly common. Nonetheless, database management systems have only recently been able to effectively deal with this data type. This tip from author Susan Lawson, provided by Info
BMC, Quest Tackle DB2
By Lisa Vaas – Users of IBM’s DB2 software can turn to tools from BMC Software Inc. and Quest Software Inc. to manage the enterprise DBMS.