Joe Celko SQL View: Beyond the Basics Following up from his popular article, SQL View Basics, Joe delves into the main uses of views, explains how the... 28 May 2012 13 min read
Phil Factor The TSQL of CSV: Comma-Delimited of Errors Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from,... 13 April 2012 20 min read
Joe Celko Bin Packing Problems: The SQL The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world... 22 March 2012 10 min read
Jeremiah Peschka SQL Server Functions: The Basics SQL Server's functions are a valuable addition to TSQL when used wisely. Jeremiah provides a complete and comprehensive guide to... 10 November 2011 41 min read
William Brewer Database Source Control – The Cribsheet As part of our long-running Cribsheet series, we asked William to come up with a brief summary of what was... 08 November 2011 25 min read
Joe Celko Voting Paradoxes: a SQL Stumper Voting systems can become very complex, and some of them are easy to manipulate by tactical voting. Joe takes a... 28 October 2011 9 min read
Joe Celko Mimicking Network Databases in SQL Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a... 26 September 2011 11 min read
Joe Celko Mimicking Magnetic Tape in SQL The sequential nature of early data storage devices such as punched card and magnetic tape once forced programmers to devise... 17 August 2011 10 min read
Phil Factor SQL Programmer’s workshop Phil Factor records, as closely as possible, the twists and turns of creating a SQL Server T-SQL stored procedure, describing... 05 August 2011 26 min read
T-SQL Programming Solomon Rutzky in T-SQL Programming CLR Performance Testing Are Common Language Runtime routines in SQL Server faster or slower than the equivalent TSQL code? How would you go... 21 July 2011 19 min read
Phil Factor How to develop TSQL Code The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored... 24 June 2011 15 min read
Joe Celko A Tale of Identifiers Identifiers aren't locators, and they aren't pointers or links either. They are a logical concept in a relational database, and,... 09 June 2011 14 min read
Joe Celko TIME Gentlemen please! The SQL Server temporal datatypes If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to... 12 May 2011 12 min read
Phil Factor PATINDEX Workbench The PATINDEX function of SQL Server packs powerful magic, but it is easy to get it wrong. Phil Factor returns... 12 May 2011 14 min read
David Berry Performance Implications of Parameterized Queries Why don't we emphasize the huge advantages of parameterized queries over ad-hoc queries in SQL Server? There is a severe... 28 April 2011 19 min read
Joe Celko SQL Server CASE Law SQLs CASE expressions can be powerful magic, but can trap the unwary who are used to the more familiar CASE... 03 March 2011 11 min read
Joe Celko Look-up Tables in SQL Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a... 01 February 2011 18 min read
Nick Harrison Database Refactoring Although the methodology of refactoring code has been adopted enthusiastically, the same has not really been the case with databases.... 01 February 2011 17 min read
Robert Sheldon Data Conversion in SQL Server Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a... 06 January 2011 17 min read
Dennis Lloyd Sebastian Meine SQL Server Unit Testing with tSQLt When one considers the amount of time and effort that Unit Testing consumes for the Database Developer, is surprising how... 06 January 2011 11 min read
