(Jayaram Krishnaswamy) This third article in the series on using XML with SQL Server 2000 covers more information on using Xpath quesries. Jayaram Krishnaswamy writes about using the XML View Mapper to create XML views to use in Xpath queries and how to use Xpath queries with the database.
Other News
Consider algorithms other than Soundex
(Scott Stephens) Soundex is a phonetic normalization function that gets around the problem of sorting information by last names with different spellings but similar or identical sounds. Find out how alternate algorithms, such as Metaphone, have overcome some of Soundex’s weaknesses.
MySQL AB Launches Worldwide Tour of MySQL 5.0 Training Workshops; Developers & DBAs can get Up-and-Running with the New Enterprise Capabilities of Leading Open Source Database
MySQL AB, developer of the world’s most popular open source database, announced a series of two-day training workshops designed to introduce developers and DBAs to the new enterprise features and capabilities of the company’s forthcoming MySQL 5.0 product.
Going Native, Part 3
(Ronald Bourret) In parts one and two of this article, we discussed how native XML databases are used to store and query document-centric XML; integrate data; and work with semi-structured data. In this, the final part, we discuss their use in schema evolution, long-running transactions, handlin
Extracting data from Oracle
(Kent Milligan) We have a Oracle V8i sitting on a Sun Solaris Server. We have another DB2 database on iSeries (version V5R3M0). Our aim is to extract data from the Oracle database every 30 minutes (it will not be a straight pull but will involve massaging the data) and loading onto DB2/400. At the m
MultiView and View Controls in ASP.NET 2.0
(Jason N. Gaylord) In ASP.NET 1.x, the Panel control was used to segregate controls into groups. Many developers would use a Panel to hide or show controls for a particular purpose. For instance, if the user clicked on a particular button, a DataGrid may appear. However, if the user clicked on a dif
The CREATE GLOBAL CUBE statement or training data mining models are unsuccessful after you use Kerberos authentication to connect to a computer that is running SQL Server 2000 Analysis Services
Consider the following scenario. You use Kerberos authentication to connect to a computer that is running Microsoft SQL Server 2000 Analysis Services from your Microsoft ASP.NET application. When you then try to run a statement, you receive the following error message: The operation requested fai
Q&A: Oracle’s security head talks from the trenches
(Scarlet Pruitt) Although no longer in the U.S. Navy, Mary Ann Davidson has placed herself on the front lines of an escalating war. It’s not a battle between nations, or over land or principle, but instead a fight for information – perhaps yours.
Understanding dimensions in an OLAP solution
(Arthur Fuller) In almost every small organisation I’ve been with, and, surprisingly, in many medium-size organisations as well, there is no OLAP database. This may be in part because of a lack of human resources.
Performing Base Conversions
(Itzik Ben-Gan) A frequent request that pops up in public SQL Server newsgroups is how to perform base conversions. That is, you store values as character strings containing digits in a given base and want to convert them to a target base. Typically, you need to store values in a nondecimal base whe