Articles on Application Design

Getting the time zone ( 20 July 2000 - Bill Graziano

SQL Server and OLE DB Heterogeneous Queries ( 18 July 2000 - Bill Graziano

Handling Exceptions ( 24 July 2000 - Bill Graziano

Time Zones ( 17 August 2000 - Chris Miller

Global Variables ( 24 August 2000 - Chris Miller

Cursors: An Overview ( 30 August 2000 - Bill Graziano

OSQL: Storing result of a Stored Procedure in a file ( 17 October 2000 - Bill Graziano

Images and SQL Server ( 6 November 2000 - Bill Graziano

Indexed Views in SQL Server 2000 ( 18 October 2000 - Doug Carpenter

SQL for Threaded Discussion Forums ( 4 February 2001 - Bill Graziano

Database Server Sizing ( 12 December 2000 - Chris Miller

SQL for Threaded Discussion (Part II) ( 7 December 2000 - Bill Graziano

Searching on SQLTeam.com ( 2 January 2001 - Bill Graziano

Intro to User Defined Functions (Updated) ( 8 January 2001 - Garth Wells

Temporary Tables ( 17 January 2001 - Bill Graziano

Error handling in long-running batch jobs ( 29 January 2001 - Guest Authors

Using COALESCE to Build Comma-Delimited String ( 1 February 2001 - Garth Wells

The Truth About Access ( 26 August 2001 - Damian Maclennen

Archiving data from production databases ( 7 May 2002 - Bill Graziano

.NET Data Access Architecture Guide for SQL Server ( 2 June 2002 - Bill Graziano

Sample Chapter: The Guru's Guide to SQL Server Architecture ( 30 October 2003 - Bill Graziano

Getting Started with ObjectSpaces ( 31 December 2003 - Bill Graziano

How to Asynchronously Execute a DTS package from ASP or ASP.NET ( 27 March 2005 - Guest Authors

GeoCoding with SQL Server and Google ( 8 August 2005 - Bill Graziano

Presentation: What I Wish Developers Knew About SQL Server ( 17 November 2005 - Bill Graziano

How SQL Server 2005 Enables Service-Oriented Database Architectures ( 8 September 2006 - Bill Graziano

Multiple Active Result Sets (MARS) ( 3 April 2007 - Mladen Prajdić

Multiple Active Result Sets (MARS) – Transactions and Debugging ( 17 June 2007 - Mladen Prajdić

What I Wish Developers Knew About SQL Server (Presentation) ( 11 October 2007 - Bill Graziano

Application Locks (or Mutexes) in SQL Server 2005 ( 7 January 2008 - Mladen Prajdić