(Brian Walker) This tip continues the system stored procedure series with a routine to create a fixed-width file containing data from a single column. (R)
Other News
SQL Server Programming: From 2000 to 2005
Presented as a Microsoft Mini-Code Camp, this full day of instruction highlights the programming aspects of SQL Server 2005 as it has evolved from SQL Server 2000. This presentation was authored and presented jointly with Adam Machanic.
Middleware is in the Open, Finally
(Alan Radding) Maybe you can view it as some sort of perverse testament to the robustness of today’s open-application environment, but application development and deployment has gotten very complicated. There are too many message protocols, data formats, component types, services and such for develo
High-Availability Clustering in Java Applications
(Michael Nash) Because most developers are firm believers in Murphy’s law, it behooves you to examine ways of making applications as “failure-proof” as possible. This leads to better “availability,” in market-speak—in other words, it means an application that is up and operational as much of the tim
How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005
This article discusses how to use XQuery in Microsoft SQL Server 2005 to query XML data from a Microsoft SQL Server 2000 database. You may want to include well-formed XML tags in the text data of the SQL Server 2000 database before you query the data from SQL Server 2005.
Information Integration Live!
IBM Information Integration Live! delivers leading edge insight on every aspect of information integration with dozens of product roadmap, case study, technical deep dive and tips and tricks sessions. Subject areas include: –,aster data management –infrastructure rationalization –business
DB2 Basics: An introduction to the SQL/XML publishing functions
(Roman Melnyk) You can use the SQL/XML publishing functions to produce a tagged XML document from relational data. IBM DB2 Universal Database (DB2 UDB) includes built-in SQL/XML publishing functions that make it easy to publish XML documents using data that is stored in a DB2 database. This article
Enriching Enterprise Grid Management
(Terrence O’Donnell) In response to a call for broader management of enterprise grid environments from its communities of partners, customers, and developers in the Oracle Enterprise Manager Partner Program, Oracle recently launched Release 2 of Oracle Enterprise Manager 10g Grid Control (Oracle Gri
‘Unable to validate product key’ during installation of SQL Server 2000 Standard Edition
During the installation of SQL Server 2000 Standard Edition using VLA media on a server running Windows 2000 SP4, you receive the error message “Unable to validate product key” on the CD-key page of the installation wizard.
Custom Web Controls Demystified, Part 1
(Miguel A. Castro) When ASP.NET was released in 2002, it gave Web developers a whole new design paradigm to work with; one that varied greatly from the classic Active Server Pages (ASP) that many Web developers had worked with in the past.