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
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
Phil Factor Robyn Page TSQL String Array Workbench Robyn and Phil show how to use XML-based arrays to make string handling easier in SQL Server 2005/2008, and illustrate... 16 March 2008 17 min read
Alex Kuznetsov Close Those Loopholes: Stress-Test those Stored Procedures You can write a stored procedure that tests perfectly in your regression tests. You will hand it to the tester... 03 February 2008 10 min read
Alex Kozak Numeral Systems and Numbers Conversion in SQL Numeral systems can be fascinating. In everyday programming, we are now becoming quite insulated from the need to convert between... 10 December 2007 19 min read
Phil Factor Robyn Page TSQL Regular Expression Workbench Robyn and Phil start by writing a gentle introduction to using Regular expressions for validation, data cleaning and data import... 27 November 2007 19 min read
Phil Factor Robyn Page Importing Text-based data: Workbench Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to... 23 October 2007 16 min read
Alex Kozak Find Missing Date Ranges in SQL Often, the quickest way to determine whether you have missing data in a table such a ledger or journal is... 11 October 2007 13 min read
Cristian Lefter Logon Triggers Login Triggers were quietly introduced in SP2 to tighten up the security features of SQL Server to comply with the... 10 October 2007 28 min read
William Brewer Quantifying Text differences in TSQL In TSQL there is a limit to the way you can compare text strings. They're either equal or not. Sooner... 20 September 2007 14 min read
Alex Kuznetsov and Alex Styler Close These Loopholes – Testing Database Modifications In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give... 02 September 2007 13 min read
Alex Kozak The Puzzle of ‘Rating Decomposition’ When reading rating information, how do you you knew how many points each separate voter gave if you only know... 29 August 2007 18 min read
Alex Kuznetsov and Alex Styler Close those Loopholes – Testing Stored Procedures Alex and Alex continue their series of articles on 'Unit Testing' database development work with some examples of unit testing... 20 August 2007 9 min read
Alex Kuznetsov Close These Loopholes in Your Database Testing Alex starts of a series of articles on 'Unit Testing' your database development work. He starts off by describing five... 31 July 2007 7 min read
Remi Gregoire RBAR: ‘Row By Agonizing Row’ Remi Gregoire describes the vice of RBAR Database Programming, 'Row By Agonising Row', and illustrates how the effect of RBAR... 26 July 2007 15 min read
