by Kendall Grant Clark – In this week’s column I will focus on two of the bread and butter issues of the XML development community: XML subsetting and XML namespace management. While both of these issues are among the permanent topics of conversation (that is, “permathreads”) on the XML-DEV mailing
Other News
Troubleshooting SQL Server 2000 installation issues
By Alexander Chigrik – Should you have problems installing SQL Server 2000, review this troubleshooting checklist to find potential solutions.
How I used SQL Server CE in my eVB application
In this article, Steven Heyvaert shares some of the SQL Server CE knowledge he has gained implementing SQL Server CE into his eVB application. In addition to the code snippets covering a variety of routine CE database access scenarios, there is also code to fill a grid with a CE recordset.
Oracle lends support to UnitedLinux
By Michael S. Mimoso – Oracle Corp. has entered into an agreement to provide level 1, 2 and 3 technical support for enterprise customers using UnitedLinux’s distribution of Linux. In addition to supporting its own products on the UnitedLinux distribution, it will also support the operating system.
Displaying Dependencies
I get different results when I use the sp_depends system stored procedure to display my database object dependencies instead of using the Display Dependencies window in SQL Server Enterprise Manager. Why?
Export TABLE Records into Flat File with INSERTs
by Dave Nikhil – This procedure writes an ASCII file to specified folder. UTL_FILE_DIR parameter must be set in the init.ora file prior to installing and running the procedure. This package looks for TABLE COLUMNS in USER_TAB_COLUMNS data dictionary. So user will be able to fetch the data onl
HOW TO: Import XML into SQL Server with the XML Bulk Load Component
Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database.
Peek Into the Future of XSLT 2.0
XSLT 2.0 provides powerful new features that XSLT 1.0 was missing. Although XSLT 2.0 is still under development, Mike Kay’s Saxon 7 implementation lets you experiment with the new capabilities now.
Web services in serious jeopardy
By David Berlind – When people ask me to define Web services, I tell them that it’s primarily an idea hatched by IBM and Microsoft to steal customers from each other.
Upgrading SQL Server, part I: Overview and project planning
By Jeremy Kadlec – This article is the first of a multi-part series detailing the SQL Server upgrade process from the technical, logistical and business perspective.