Questions, Answers, and Tips About SQL Server Investigate how to install multiple instances of SQL Server, use the TOP statement with a local variable, use UDFs in SQL Server 2000, store extended properties, and more.
Author: SSWUG Research
Using Site Server Search to Index XML documents
By Paul Hammond – I recently spent some time discussing integration issues with a client who wanted to use XML to store articles for a magazine style website. His XML data was stored in physical XML files on the web server, with all of the articles for a "magazine edition" in a single XML fi
XHTML Basic moves to Recommendation
Modularization of XHTML may still be in Candidate Recommendation, but XHTML Basic, built on top of it, is now a W3C Recommendation.
UDDI: an XML Web Service
The Universal Description, Discovery, and Integration (UDDI) Service is now up and running at Microsoft, IBM, and Ariba. This is an online Web Service that you can use from your applications to dynamically discover other online services, all neatly packaged in a simple XML interface.
The Route to Scalability
By Michael Otey – Despite the impressive Transaction Processing Performance Council (TPC) scores that Microsoft generated by using scale-out technology and SQL Server's federated-databases feature, it's too soon to count out scale-up technology based on SMP systems. Adding more processing po
Microsoft, Sun in New Clash
Despite Zachman's rosy comments, the sailing has not been smooth for Microsoft with BizTalk Server and the underlying BizTalk Framework technology.
Free XML Training: Introduction to XML: 6 Weeks free online course from Barnes & Noble University
XML is the newest and hippest Web technology. Bookstore shelves are stuffed with XML books and every other magazine article is about some facet or another of XML. So what’s all the fuss about, anyway? This course is designed to answer that very question. I’ll explain what XML is, introduce you to it
Read free chapter from book: XML in a Nutshell : Chapter 9 XPath
XPath is a non-XML language used to identify particular parts of XML documents. XPath lets you write expressions that refer to the document's first person element, the seventh child element of the third person element, the ID attribute of the first person element whose contents are the string &#
First complete draft of XForms published
The W3C's XForms Working Group has published their first complete working draft for the next generation of XML-based web forms.
Database Scanner 4.0.1
By Brian Knight – Database Scanner 4.0.1 from Internet Security Systems (ISS) is a must-have for any DBA responsible for security. Database Scanner lets you set security policies on your SQL Server 7.0 and 6.x systems, then lets you audit your systems to see whether you're complying with those p