Eric Brown Troubleshooting with Dynamic Management Views If you work with SQL Server 2000, then you know how painful it is to triage a server that has "gone astray". Eric Brown thinks... 12 April 2007 5 min read
Greg Larsen Building my First SQL Server 2005 CLR Greg Larsen provides a step-by-step tour of the hurdles he had to jump in building and deploying his first serious CLR stored procedure.… 06 December 2006 9 min read
Eric Brown Encryption without the Confusion Eric Brown demonstrates some practical encryption techniques in SQL Server 2005, to protect both your objects and your data.… 29 November 2006 14 min read
Tony Davis SQL Server, PostgresSQL and Fish Curry An interview with Adam Machanic, discussing hot new features of SQL 2005, stored procedures, fish curry and mor… 16 August 2006 18 min read
Hilary Cotter SQL Server Full Text Search Language Features, Part 2 Extensive coverage of the query-time behaviour of SQL Server Full-text search, demonstrating how searches are expanded by the parser before hitting the full-text index.… 04 July 2006 13 min read