By Brian Moran – If you don't know about Microsoft's Software Assurance (SA) program, now's the time to start learning. This fall, SA is coming to a SQL Server near you.
Other News
Understanding How to Configure a SQL Server Connection Affinity Mask
This article describes how to use the connection affinity mask option that is available in SQL Server 2000 SP1 or later.
Deleting Data from SQL Tables
Oftentimes, it becomes necessary to remove obsolete information from a relational database. Fortunately, Structured Query Language provides a flexible DELETE command that can be used to remove some or all of the information stored within a table.
Working XML: Using XSLT for content management
This is the first installment of Working XML, a column with companion project code that demonstrates the evolution of full-fledged XML applications. In this column, author and software consultant Benoît Marchal introduces XM (XSLT Make), a simple and affordable Web publishing content-management solu
XML Basics (part 1)
Struggling with XML? Can't figure out the difference between an entity and a namespace? Fear not – our XML series has all the answers. This introductory article discusses the origins and design goals of XML, the basic rules of XML markup, and how to use elements and attributes in an XML document
Slippery SOAP
by Edd Dumbill – Earlier this month, the W3C's XML Protocol Working Group released a Working Draft of SOAP 1.2. This specification is notable for several reasons. First, it's the first version of the protocol produced inside the W3C, rather than being a submission from member companies. Seco
Useful Undocumented SQL Server Extended Stored Procedures
by Alexander Chigrik – In this article, I want to tell you about some useful undocumented extended stored procedures. These extended stored procedures work with SQL Server 7.0, as well as with SQL Server 2000.
SQL Server 2000 User-Defined Functions White Paper
The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create
How Fuzzy Query Works
SQL has certain limitations. In recent years, an increasing number of people have begun to realize the need for a technology to reach beyond the barriers that SQL presents. One of the most significant barriers that people come up against when attempting to retrieve data from a database using SQL is
Parser updates support XML Schema
By Natalie Walker Whitlock – Learn about W3C XML Schema Recommendation support in new versions of the Apache XML Project's Xerces parsers.