Guest Authors

Alerts for when Login Failures Strike (14 July 2008)

Using xp_ReadErrorLog in SQL Server 2005 (12 May 2008)

Detroit Area SQL Server User Group (10 July 2007)

Using SQL Server 2005 fulltext search from ASP.NET 2.0 (5 February 2007)

Best Practices for Query Parameterization (24 January 2007)

Query Parameterization and Plan Cache (23 January 2007)

Using Fuzzy Lookup Transformations in SQL Server Integration Services (22 January 2007)

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

Computing the Trimmed Mean in SQL (29 June 2004)

Computing Percentiles in SQL Server (20 May 2004)

Find Nth maximum value in SQL Server (11 April 2004)

Optimizing Performance / Indexes on Temp Tables (5 January 2004)

Anticipating Primary Key Violations (23 November 2003)

Replicating SQL Server 2000 across Heterogeneous Databases (24 August 2003)

Regular Expressions in T-SQL (24 June 2003)

Who Needs Change Management? (15 June 2003)

XML Validator (9 February 2003)

Horizontal and Vertical Partitioning in Replication (30 January 2003)

Using DTS and FTP to Push Files (13 January 2003)

Using SQL DMO and Windows Script to customize script generation (23 September 2002)

Performing a Cascade Delete in SQL Server 7 (4 April 2002)

Simulating Constants Using User Defined Functions (24 February 2002)

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

Transact-SQL (20 December 2000)

SQL Server 2000 Performance Tuning Tools (22 September 2000)