SQL Connections is SQL Server Magazine Live and features over 40 non-stop SQL Server 2000 & SQL Server 7.0 sessions at the beautiful Hyatt Grand Cypress Resort. Come hear Microsoft's Ryan Trout, Swynk.com's Steve Wynkoop, and many other SQL Server experts reveal the latest SQL Server secr
Author: SSWUG Research
Using COALESCE to Build Comma-Delimited String
From SQL Team, Garth is back with another article. This one talks about building a comma-separated value string for use in HTML SELECT tags. It's also handy anytime you need to turn multiple records into a CSV field. It's a little longer and has some HTML but a good read.
PyTREX
PyTREX is an implementation of Tree Regular Expressions for XML (TREX) in Python. This first release includes basic support for the concepts described in sections 1 through 6 of the TREX tutorial.
XML for C# Programmers [Part I]
If you are writing XML applications using Visual Studio 6.0, then using MSXML 3.0 is a great option to work with XML documents. But if you are writing code for the .NET platform, the language of choice is C# (pronounced C Sharp) and XML classes provided by the .NET Framework are the preferred way of
XslTransport for PocketSOAP
XslTransport is a COM component that integrates with Simon Fell's PocketSOAP toolkit. It works as a replacement for the HTTP transport bindings that the PocketSOAP provides. XslTransport allows you to specify a local XSL document to be used to transform the message into a response.
Not All SQL Server Indexes Are Created Equal
If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. But this article is not about them. This article is about whether or not the SQL Server Query Optimizer will use your carefully crafted indexes. You may
Perception vs. Reality
From Sqlmag, by Michael Otey Coming on the heels of Oracle's latest $1 million challenge, the recent Transaction Processing Performance Council (TPC) Web site reorganization seems to be further evidence that Oracle is more worried about Microsoft and SQL Server 2000 than you might expect. I
OpenOffice.org filters using the XML based file format
This document explains the implementation of OpenOffice.org import and export filter components, focusing on filter components based on the OpenOffice.org XML file format. It is intended as a brief introduction to developers that want to implement OpenOffice.org filters for foreign file formats.
Quotable XML
Andrew Kuchling has created Quotation Exchange Language (QEL), for the encoding of quotation collections.
ADO.NET's Primary Objects
By Michael Otey The Microsoft .NET Framework promises to dramatically change the way you and I develop applications—including how we provide data access. ADO.NET, the next generation of ADO, will be the primary data access API for Microsoft .NET applications. If you already know ADO, you'll