August 2000

SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users

SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data retrieval and manipulation, queries, and HTTP access. It concludes with a discussion of performance improvements in SQL Server 2000. Carl Nolan

Develop a Web Service: Up and Running with the SOAP Toolkit for Visual Studio

The new Simple Object Access Protocol (SOAP) Toolkit for Visual Studio 6.0 provides the infrastructure for developers to build, expose, and consume Web services. With a few exceptions that are outlined in the toolkit, the SOAP Toolkit complies with the SOAP version 1.1 specification. It includes the Remote Object Proxy Engine (ROPE), a Service Description and Code Generation Wizard, and code that provides ASP and ISAPI reference implementations of SOAP listeners. This article describes the tools and the object model of the SOAP Toolkit, and then demonstrates ASP and ISAPI implementations of a functional Web service using this toolkit. Rob Caron

XSL Transformations: XSLT Alleviates XML Schema Incompatibility Headaches

The XSL Transformations (XSLT) specification defines an XML-based language for expressing transformation rules that map one XML document to another. XSLT has many of the constructs found in traditional programming languages, including variables, functions, iteration, and conditional statements. In this article you'll learn how to use the XSLT instructions and template rules, manage namespaces, control transformation output, use multiple stylesheets, and employ pattern-matching with template rules. A sidebar explains how to access XSLT from MSXML using the IXSLTemplate and IXSLProcessor interfaces. Don Box, Aaron Skonnard, John Lam

Migrating Your ASP Apps from Windows NT 4.0 to Windows 2000

In order to take advantage of new features in Windows 2000 and IIS 5.0, you must first migrate your Windows NT 4.0-based ASP applications to Windows 2000. This article provides a multi-step migration plan. It discusses how to install and configure IIS 5.0, set up security, migrate MTS packages to COM+ applications, and handle differences in the ASP object models. Also included are guidelines for setting up Visual Basic and Visual C++ for development in Windows 2000 and information on what to expect when moving ASP components to the new OS. Shelley Powers

Editor's Note: Greetings from Tech•Ed!

New Stuff: Resources for Your Developer Toolbox

Theresa W. Carey

Web Q&A: Sending E-mail from Forms, Database Solutions, Web Site Planning

Robert Hess

Cutting Edge: SQL Server 7.0 and OLE DB Heterogeneous Queries

Dino Esposito

Serving the Web: XML Data Manipulation with ADO 2.5

Ken Spencer

Visual Programmer: Writing ActiveX Controls in Visual Basic versus Visual C++

George Shepherd

Bugslayer: A COM Symbol Engine Aids Debugging

John Robbins

Security Briefs: Explore the Security Support Provider Interface Using the SSPI Workbench Utility

Keith Brown

Wicked Code: Implementing Handler Marshaling Under Windows 2000: DeviceClient Sample App

Jeff Prosise

C++ Q&A: Windows 2000 File Dialog Revisited; Autocompletion and the ACTest Demo App

Paul DiLascia

MSDN Update: News this Month from MSDN

Code Download
.Chm Files