by Srinivas Pandrangi, Alex Cheng, et al. – In the first two parts of this series, you saw a general introduction to XQuery syntax, capabilities, and the XQuery data model. In this part, you’ll learn how to use XQuery’s powerful FLWR (for, let, where, return) expressions and see the similarities bet
Community
Moving SQL Server Databases to a New Location with Detach/Attach
This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database.
GenerateScript
Created by: Alexander Chigrik – This script will generate script for all tables and all dependent objects for the given database. You can pass the Server name, user name, user password, database name and file name into GenerateScript stored procedure
Oracle plans to make unstructured data searchable
by Eric Doyle – Businesses will be able to search unstructured data held in anything from e-mail to Powerpoint slides, if an Oracle project achieves its aim.
Can EDI Survive XML Challenge?
By Dan Orzech – With support from high-tech’s heavy hitters, XML-based RosettaNet is becoming a popular way for companies to synch up their supply chains.
Build Generic Page-Specific Help with XML in ASP
by Philip Dickerson – In this article, you’ll see several possible approaches for implementing context-specific Web help pages, as well as a discussion of the strengths and weaknesses of each approach.
SVG Tips and Tricks: Adobe’s SVG Viewer
by Antoine Quint – Since Adobe’s SVG Viewer is the main SVG implementation, with 160 million deployed units and counting, I thought it would be a good idea to take a look at some special features that only the Adobe SVG Viewer offers to its users. Want to see what we can do with it? Grab a copy of v
Interesting SQL-Based Web-Site Implementation
Several people have asked since SQL Server Live! Spring 2002 what the site was that was used in several of the demonstrations. The site is entirely SQL Server-driven, and the backend is millions of rows of data that is searched and used to find the issues about your car. It was challen
Find Recently Scanned (Full) Tables and Recently Used Indexes
This tip comes from Vijay Fernando, Oracle DBA (Data Warehousing), at Intel India Pvt. Ltd., in Bangalore, Karnataka, India.
Benchmarking Java XML processors
Pankaj Kumar has announced XPB4J, a tool for measuring and comparing XML parsing/processing performance.