If you need to store XML data in DB2, translate XML to relational data, or shred relational data into XML, the XML Extender for DB2 is an essential utility. But it’s not always straightforward. Find out what it can do and what problems to expect.
Other News
Code Centric: T-SQL Programming with Stored Procedures and Triggers
Book by Garth Wells – If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. You’ll learn “real-world” coding and how to build non-trivial applications.
When managing database environments, integration is key
By Ellen O’Brien – When managing complex database environments, IT vendors and buyers agree on the three top priorities: integration, integration and integration.The challenge of integrating data is not a new one. However, restrictions on IT spending and staffing in the last year have placed
User Defined Functions
Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the many ways functions can be used.
Common XSLT Tasks – Part I (Transformation and Sorting)
In this five-part article series, we’ll present examples that illustrate some common XSLT tasks such as transforming XML, sorting, generating nodes, conditions and looping, recursion, and so on. In this first part, we’ll see examples of transforming XML and sorting.
Tools For Developing VoiceXML Apps
By Hitesh Seth – In this issue we’ll focus on the tools available to aid development and testing of VoiceXML-based components and applications. We’ll discuss how to use the tools to test and debug such applications from a normal Touch-Tone-based phone.
Tip: SAX and document order — deliver maximally contiguous text
By Howard Katz – Previous tips in this series have explored how SAX can help delineate the relationships that exist between nodes in your XML documents. The tips have examined the use of document order and document order indices (DOIs) to track both parent-to-child and sibling-to-sibling relationshi
An Introduction to Streaming Transformations for XML
This article introduces Streaming Transformations for XML (STX), a template-based XML transformation language that operates on streams of SAX events. STX resembles XSLT 1.0, the tree-driven transformation language for XML, but STX offers unique features and advantages for some applications.
Analysis Services optimization tips
Here are fifteen little known tips that you can use to ensure your Analysis Services are performing in the most efficient manner possible.
HOWTO: Insert New Values to a Uniqueidentifier Column in SQL Server CE
SQL Server 2000 Windows CE Edition supports the uniqueidentifier data type. By default, the SQL Server NEWID function is not used in SQL Server CE to generate a unique value for the uniqueidentifier column. However, the ROWGUIDCOL attribute for a column has been overloaded to indicate that a default