All Articles -> SQL Server Application Design

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

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

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

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

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

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

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

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

Getting Started with ObjectSpaces ( 31 December 2003 - Bill Graziano - 0 Comments)

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

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

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

The Truth About Access ( 26 August 2001 - Damian Maclennen - 8 Comments)

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

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

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

Temporary Tables ( 17 January 2001 - Bill Graziano - 13 Comments)

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

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

Database Server Sizing ( 12 December 2000 - Chris Miller - 3 Comments)

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

Images and SQL Server ( 6 November 2000 - Bill Graziano - 30 Comments)

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

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

Cursors: An Overview ( 30 August 2000 - Bill Graziano - 0 Comments)

Global Variables ( 24 August 2000 - Chris Miller - 2 Comments)

Time Zones ( 17 August 2000 - Chris Miller - 0 Comments)

Handling Exceptions ( 24 July 2000 - Bill Graziano - 1 Comment)

Getting the time zone ( 20 July 2000 - Bill Graziano - 1 Comment)

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