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.
Author: SSWUG Research
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.
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
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.
Learn to Use XML with DB2
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.
Instant Insight
By Alan Joch – More-sophisticated, integrated business intelligence tools and technology give an increasingly wider ranger of businesses new, immediate competitive powers.
Altova ship their end user XML editor Authentic free of charge
Allowing the no-cost deployment of editing applications authored with their XSLT Designer, Altova appears to be positioning themselves as a cost-effective alternative to the XML abilities of the forthcoming Microsoft Office 11.
Oracle Preps Realtime Communications Features For Collaboration Suite
By Paula Rooney – Oracle remains on track to ship realtime communications features in its collaboration suite in mid-2003 and is unfazed–at least publicly–by the entry of AOL and Yahoo into the corporate instant messaging market.
Hot backup and recovery with Perl
By FRANK PANTALEO – This script is very useful for DBAs who want to use Perl for doing hot backups. Perl DBI/DBD provides very close integration and control of the state of the database. It also allows real time queries that allow the script to be self-learning about what dbf’s are in the database.
Build Smart With Data Shaping
by Jeff Jones – One of the most sought-after goals in data applications is end-to-end speed. You should look for a good balance of speed and development time to achieve this goal. I’ll show you how to create more efficient data shaping to make your hierarchical data as lean and as fast as possible.