by Lars Marius Garshol – Many years ago, I started looking into SGML and XML as a way to make information more manageable and findable, which was something I had been working on for a long time. It took me several years to discover that, although SGML and XML helped, they did not actually solve the
Author: SSWUG Research
How to Upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster
by Brad M. McGehee – Learn how to upgrade your current SQL Server 7.0 cluster to a SQL Server 2000 cluster.
Discover the Useful System.Xml.Schema Classes
by Dan Wahlin – Schemas handle functionality related to XML, ADO.NET, Web services, and more. Learn the main classes within the System.Xml.Schema namespace to programmatically manipulate schemas in .NET.
Security’s tight for SQL server software
By Wylie Wong – The next version of SQL Server, code-named "Yukon," will include a long list of new security-related features when it debuts in 2003, said James Hamilton, SQL Server’s design architect. He said that Microsoft’s database team spent more than a month auditing the software code for secu
SQL Server 2000 undocumented system tables
Alexander Chigrik decodes some SQL Server 2000 Undocumented System Tables.
Converting between XML Schema and CLR Types using the XmlConvert Class
This sample application demonstrates how to use the XmlConvert class to convert from XML Schema data types to corresponding CLR types (and vice versa), and shows how to use the EncodeName() method to ensure that dynamically created XML element and attribute names do not contain prohibited characters
Controlling the DOCTYPE and XML Declaration
by Bob DuCharme – XSLT processors usually create result documents that are well-formed XML with a simple XML declaration at the top. They don’t have to add that XML declaration, though; it’s easy to suppress it. It’s also easy to add one and control exactly what it shows, such as an encoding declara
Namespaces 1.1 in Last Call
The W3C has released a new Last Call Working Draft of Namespaces in XML 1.1.
JUNOScript: An XML-based Network Management API
JUNOScript is an XML-based API for managing devices. It allows access to both operational and configuration data using a simple RPC mechanism. Sessions can be established using a variety of connection-oriented access methods. This document describes the framing protocol, message c
Converting Multiple Rows into a CSV String (Set Based Method)
Based the problem outlined in RocketScientist’s article (entitled Converting Multiple Rows into a CSV String), I would like to present an alternative method for accomplishing a similar task. This article will show a faster method to convert multiple rows into multiple CSV strings.
