Greg Larsen Choosing between CLR and T-SQL stored procedures: a simple benchmark In this short article, Greg Larsen performance benchmarks alternative CLR-based and T-SQL stored procedure solutions for retrieving operating system file information. He also assesses other... 24 April 2007 6 min read
Phil Factor Reading and Writing Files in SQL Server using T-SQL SQL Server provides several "standard" techniques by which to read and write to files but, just occasionally, they aren't quite up to the task at... 10 April 2007 10 min read
Keith Fletcher Creating Cross Tab Queries and Pivot Tables in SQL For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored procedure will allow you to... 27 March 2007 18 min read
Pop Rivett Pop Rivett and the Case of the Rogue SPIDs A process in a complex database occasionally, and apparently randomly, manages to put table locks on vital tables. Several applications are brought to a complete... 22 March 2007 6 min read
Phil Factor Robyn Page The Helper Table Workbench Cursors and iterations are both renowned for slowing down Transact SQL code, but sometimes seem unavoidable. In this workbench, Robyn Page and Phil Factor demonstrate... 16 March 2007 16 min read
Phil Factor Robyn Page SQL Server Security Workbench Part 1 Robyn Page and Phil Factor present practical T-SQL techniques for controlling access to sensitive information within the database, and preventing malicious SQL injection attacks.… 06 March 2007 17 min read
Phil Factor Robyn Page SQL Server Excel Workbench The need to produce Excel reports from SQL Server is very common. Here, Robyn Page and Phil Factor present practical techniques for creating and manipulating... 06 February 2007 15 min read
Phil Factor The Ultimate Excuse Database Is your IT project in trouble? Do you need to create a smokescreen so that no-one can pin the blame on you? No problem! Marvel... 15 January 2007 11 min read
William Brewer Towards the Self-Documenting SQL Server Database William Brewer investigates an unsung hero in SQL Server, extended properties, and shows how to use them to create self-documenting SQL Server databases.… 01 December 2006 16 min read
Pop Rivett Pop Rivett’s SQL Server FAQ Pop Rivett dispenses pearls of SQL Server wisdom, this time tackling the setting of variables from dynamic SQL. Bah, humbug.… 18 September 2006 3 min read
Douglas Reilly Database Geek of the Week: Itzik Ben-Gan Itzik Ben-Gan is a writer and mentor, he writes a monthly column for SQL Server Magazine and co-authored Advanced Transact-SQL for SQL Server 2000.… 05 September 2005 12 min read