András Belokosztolszki Removing Duplicates from a Table in SQL Server Sometimes, in SQL, it is the routine operations that turn out to be the trickiest for a DBA or developer.... 11 February 2009 13 min read
Phil Factor The TSQL of Text Files Phil returns to the old subject of 'Getting text-based data in and out of SQL Server'. He shows various easy... 19 January 2009 15 min read
Joe Celko Temporal Data Techniques in SQL In the first part of this series on Temporal Data, Joe explained how it is that the Common Era calendar... 18 January 2009 12 min read
Joe Celko Temporal Datatypes in SQL Server In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses... 16 December 2008 10 min read
Joe Celko Unique Experiences! You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause... 18 November 2008 14 min read
Phil Factor Robyn Page SQL Server Matrix Workbench In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in... 15 November 2008 13 min read
Joe Celko Constraint Yourself! In his first article for Simple-Talk, Joe Celko demystifies the use of Constraints, and points out that they are an... 26 October 2008 13 min read
Alex Kozak The Bejeweled Puzzle in SQL Alex Kozak provides another SQL puzzle to hone your SQL Skills with. … 09 October 2008 6 min read
Anith Sen Faking Arrays in Transact SQL It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL.... 16 September 2008 20 min read
Anith Sen Concatenating Row Values in Transact-SQL It is an interesting problem in Transact SQL, for which there are a number of solutions and considerable debate. How... 31 July 2008 17 min read
William Brewer JSON and other data serialization languages The easiest way to speed up an Ajax application is to take out the 'X' and use JSON rather than... 18 July 2008 9 min read
Alex Kozak Missing Date Ranges- the Sequel Alex Kozak returns with another Date puzzle. A readers question gives Alex the inspiration to see if is possible to... 16 June 2008 7 min read
Alex Kuznetsov Close these Loopholes – Reproduce Database Errors This is the final part of Alex's ground-breaking series on unit-testing Transact-SQL code. Here, he shows how you can test... 23 May 2008 8 min read
Nigel Rivett Identity Columns When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the... 12 May 2008 12 min read
William Brewer SQL Code Layout and Beautification William Brewer takes a look at the whole topic of SQL Code layout and beautification, an important aspect to SQL... 11 May 2008 16 min read
Phil Factor Robyn Page SQL String User Function Workbench: part 2 In which Robyn and Phil continue with their popular series on TSQL String User-functions. In this final episode, they pull... 28 April 2008 14 min read
Alex Kuznetsov The Case of the Skewed Totals Even when your code tests out perfectly in the standard test cell, you can experience errors in the real production... 15 April 2008 7 min read
Phil Factor Robyn Page SQL String User Function Workbench: part 1 Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python... 15 April 2008 15 min read
Joe Webb Building Effective SQL Server Notification Applications Part 2 Joe Webb provides a guided tour of his top ten favorite enhancements to SQL 2005 Notification Services.… 11 April 2008 15 min read
Getting HTML Data: Workbench Robyn and Phil start their investigation into XHTML by showing how to use TSQL to parse it to extract data,... 27 March 2008 17 min read
