Managed Stored Procedures and User Defined Functions - Part I
Darshan Singh   (Thursday, December 09, 2004)
By now you might have heard that SQL Server 2005 hosts the .NET 2.0 runtime. This enables writing stored procedures, functions and triggers using any of the managed languages, such as C# and VB .NET. This article is based on my first experience with SQLCLR integration, where I converted some of the documented and un-documented extended stored procedures to managed procedures and functions.
www.YukonXML.com/articles/sqlclr

A Quick Introduction to SQL Server Management Objects (SMO)
Darshan Singh   (Thursday, July 29, 2004)
Microsoft SQL Server 2000 supports a COM-based object model, called SQL-DMO, which can be used to programmatically manage the SQL Servers. SQL Server 2005 replaces SQL-DMO with two .NET based object libraries: SQL Server Management Objects (SMO) & Replication Management Objects (RMO). In this short tutorial, I'll show you how you can use SMO in your .NET applications.
www.YukonXML.com/articles/smo

Essential XQuery - The XML Query Language
Darshan Singh   (Monday, February 02, 2004)
XQuery or XML Query Language is a W3C specification designed to provide a flexible and standardized way of searching through (semi-structured) data that is either physically stored as XML or virtualized as XML (such as XML Views over relational data). To give you an analogy, SQL is used to query relational data, XQuery is a standard language for querying XML data. This article is an introduction to XQuery language (based on November 2003 working draft).
www.YukonXML.com/articles/xquery/

XML in SQL Server 2000 and SQLXML
Darshan Singh   (Monday, January 26, 2004)
Microsoft® SQL Server™ 2000 first introduced native support for XML and HTTP. Since then, to keep up with XML, Web services and .NET advancements, Microsoft has made available add-ons to SQL Server 2000 in the form of SQLXML Web releases. This article begins with explaining the built-in XML and HTTP support in SQL Server 2000 and then it describes the features available in the recent SQLXML Web release (version 3.0, service pack 2).
www.YukonXML.com/articles/sql2000xml/