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
Mario Broodbakker Investigating SQL Server 2008 Wait Events with XEVENTS Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy... 24 July 2008 9 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
Randy Volters DML Trigger Status Alerts When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part,... 04 July 2008 9 min read
Brad McGehee Professional Certification for DBAs In this article, republished from Brad McGehee's book 'How to Become an Exceptional DBA', Brad explains why there are several... 16 June 2008 16 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
Jason Cook Installing SQL Backup on Multiple Servers using SQL Multi Script Jason Cook shows you how you can use SQL Multi Script to install or upgrade your SQL Backup server components... 06 June 2008 12 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
Grant Fritchey Execution Plan Basics Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up... 11 May 2008 44 min read
David Leibowitz SSIS Package Componentization In this article, David Leibowitz describes methods for scalable SQL Server 2005 Integration Services package creation. If you're no stranger... 29 April 2008 21 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
Hugh Bin-Haad The Concept of Cardinal Reciprocity- A Primer Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a... 01 April 2008 12 min read
David Connell Towards a Better Beta David Connell describes how the team that developed Red-Gate's SQL Data Generator tool came to realise that database developers and... 31 March 2008 11 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
