Joe Celko Avoiding the EAV of Destruction A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a... 18 June 2009 11 min read
Robert Sheldon XML Data Modification Language Workbench XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases,... 28 April 2009 21 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server CLR Regex Functions: Build Your Own Assembly (SQL Server 2022 and Earlier) Build and deploy CLR regex functions for SQL Server 2022 and earlier without Visual Studio. Complete VB.NET assembly with REGEXP_LIKE,... 15 April 2009 15 min read
Joe Celko Median Workbench SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median,... 05 April 2009 15 min read
Alex Kuznetsov Brain Teaser for Pi Day Alex has come up with a great idea for Pi Day. We should celebrate by trying to come up with... 02 March 2009 2 min read
Joe Celko Divided We Stand: The SQL of Relational Division Businesses often require reports that require more than the classic set operators. Surprisingly, a business requirement can often be expressed... 17 February 2009 17 min read
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
T-SQL Programming Anith Sen in T-SQL Programming Concatenate Row Values in SQL Server: STRING_AGG and T-SQL Methods Learn how to concatenate row values in SQL Server using STRING_AGG (SQL Server 2017+), FOR XML PATH, recursive CTEs, and... 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
