In this FAQ of the week, you'll see one of the most common bugs that programmers run into when programming using ADO against a SQL Server.

Taming the Stateless Beast: Managing Session State

by Additional Articles

Microsoft MSDN

Performance Tuning

Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.

XP_ENUM Stored Procedures

by Brian Knight

SQLServerCentral.com

Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.

SQL Server CE: New Version Lets You Store and Upda

by Additional Articles

Microsoft MSDN

Miscellaneous

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.

Tame Those Strings - Part 6

by Steve Jones

SQLServerCentral.com

Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.

The Guru's Guide to T-SQL

by Steve Jones

SQLServerCentral.com

Book Reviews

Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.

PASS 2001 North America - Register and Save $500

by Additional Articles

PASS

Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!

Clonation and the Case of Table Dolly, Part 2

by Additional Articles

Microsoft MSDN

.Net

In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.