This article describes how to use the connection affinity mask option that is available in SQL Server 2000 SP1 or later.
Author: SSWUG Research
Software Assurance Coming Soon to a SQL Server Near You
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.
Chemists get Jumbo sized tools release
Peter Murray-Rust and Henry Rzepa have announced new and updated tools and demonstrations the Chemical Markup Language, described as "the most mature and developed 'science domain specific' application of XML."
Programming Web Services with XML-RPC
by Simon St. Laurent, Joe Johnston, Edd Dumbill – This excerpt from O'Reilly & Associates' recently published Programming Web Services with XML-RPC discusses using PHP to integrate two web applications into a single interface. In the given example, the authors show how a technology news serv
Write a simple XML message broker for custom XML messages
In this article, the first of three, Dirk Reinshagen discusses XML messaging, specifically the basic premise of XML messaging, what it is, and why it is useful. Further, he presents a simple XML message broker for custom XML messages. In the course of developing this broker, he introduces general br
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
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
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.
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
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