by Alexander Chigrik – In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only the sysfiles1 system table is stored in each database).
Author: SSWUG Research
Auxiliary Tables, Bit by Bit
By Itzik Ben-Gan – Auxiliary tables are extra, “helper” tables you create in your database specifically to help you provide T-SQL solutions. With auxiliary tables, you can write shorter, simpler, and more elegant code. I can best explain the concept of using auxiliary tables through an example. In t
Putting XSL transformations to work
By Mark Colan – This paper introduces the Extensible Stylesheet Language (XSL) and highlights several real-world business scenarios that benefit from the use of XSL transformations. XML data comes in many forms, so one of the most important technologies needed for XML applications is the ability to
PHP and XML: Parsing RSS 1.0
by Kevin Yank – In this article, we'll learn how to use PHP to read an XML document and display the data it contains as a Web page. The example we'll use is a Resource Description Framework (RDF) Site Summary (RSS) 1.0 document, although the techniques presented here apply to any situation w
Fast XML Access in .NET Using the XMLTextReader Class
by Peter G. Aitken – Microsoft's .NET Framework offers lots of goodies for developers. With the ever-increasing importance of XML, you would expect a full set of powerful XML tools to be included. And you'd be right; the .NET Framework does not disappoint. Grouped together in the System.XML
Advanced SQL Techniques – Part 1: Analyzing Duplicate Records
By David Penton – The following is an analysis of records in a table, some of which may be duplicated. Many different things can be accomplished with this method, including looking for duplicates, looking for records that are duplicated n times, deleting duplicates, etc.
AGS SQL Scribe
SQL Scribe is a documentation tool created with the developer in mind. SQL Scribe will interrogate a SQL 7.0 or 2000 database and extract the database schema. This schema information is stored in an MS Access 2000 database. Using any readily available browser the developers can navigate though the
OLAP Survey Respondents Give Analysis Services High Marks
By Kathy Blomstrom – SQL Server 2000’s integrated Analysis Services functionality came out on top in several categories in the recent 2001 OLAP Survey, conducted by Survey.com and published by The OLAP Report. The survey asked more than 644 OLAP users from 46 countries to rate 11 vendors on implemen
Modeling XML Vocabularies with UML: Part III
by Dave Carlson – This article is the third installment in a series on using UML to model XML vocabularies. The examples are based on a simple purchase order schema included in the W3C XML Schema Primer, and we've followed an incremental development approach to define and refine this vocabulary
Using JDBC to extract data into XML
By Nicholas Chase – This tutorial is designed to assist Java developers who need to extract information from a database and place it into an XML document. The tutorial assumes that you are already familiar with Java and XML in general, and the Document Object Model (DOM) in particular. You sh